📄 builderweb.cs
字号:
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
string deText = field.DeText;
if (deText.Trim() == "")
{
deText = columnName;
}
strclass.AppendSpaceLine(1,"<tr>");
strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"30%\" align=\"right\">" );
strclass.AppendSpaceLine(2, deText );
strclass.AppendSpaceLine(1, "</td>" );
strclass.AppendSpaceLine(1,"<td height=\"25\" width=\"*\" align=\"left\">" );
switch (columnType.Trim())
{
case "bit":
strclass.AppendSpaceLine(2, "<asp:CheckBox ID=\"chk" + columnName + "\" Text=\"" + deText + "\" runat=\"server\" Checked=\"False\" />" );
break;
default:
strclass.AppendSpaceLine(2, "<asp:Label id=\"lbl" + columnName + "\" runat=\"server\"></asp:Label>");
break;
}
strclass.AppendSpaceLine(1, "</td></tr>" );
}
strclass.AppendLine("</table>" );
return strclass.ToString();
}
/// <summary>
/// 增删改3个页面代码
/// </summary>
public string GetWebHtmlCode(bool ExistsKey, bool AddForm, bool UpdateForm, bool ShowForm, bool SearchForm)
{
StringPlus strclass = new StringPlus();
if (AddForm)
{
strclass.AppendLine(" <!--******************************增加页面代码********************************-->");
strclass.AppendLine(GetAddAspx());
}
if (UpdateForm)
{
strclass.AppendLine(" <!--******************************修改页面代码********************************-->");
strclass.AppendLine(GetUpdateAspx());
}
if (ShowForm)
{
strclass.AppendLine(" <!--******************************显示页面代码********************************-->");
strclass.AppendLine(GetShowAspx());
}
return strclass.ToString();
}
#endregion
#region 表示层 CS
/// <summary>
/// 生成表示层页面的CS代码
/// </summary>
/// <param name="ExistsKey"></param>
/// <param name="AddForm">是否生成增加窗体的代码</param>
/// <param name="UpdateForm">是否生成修改窗体的代码</param>
/// <param name="ShowForm">是否生成显示窗体的代码</param>
/// <param name="SearchForm">是否生成查询窗体的代码</param>
/// <returns></returns>
public string GetWebCode(bool ExistsKey, bool AddForm, bool UpdateForm, bool ShowForm, bool SearchForm)
{
StringPlus strclass = new StringPlus();
if (AddForm)
{
strclass.AppendLine(" /******************************增加窗体代码********************************/");
strclass.AppendLine(GetAddAspxCs() );
}
if (UpdateForm)
{
strclass.AppendLine(" /******************************修改窗体代码********************************/");
strclass.AppendLine(" /*修改代码-显示 */");
strclass.AppendLine(GetUpdateShowAspxCs() );
strclass.AppendLine(" /*修改代码-提交更新 */");
strclass.AppendLine(GetUpdateAspxCs() );
}
if (ShowForm)
{
strclass.AppendLine(" /******************************显示窗体代码********************************/");
strclass.AppendLine(GetShowAspxCs() );
}
//if (DelForm)
//{
// strclass.Append(" /******************************删除窗体代码********************************/" );
// strclass.Append("");
// strclass.Append(CreatDeleteForm() );
//}
return strclass.Value;
}
/// <summary>
/// 得到表示层增加窗体的代码
/// </summary>
public string GetAddAspxCs()
{
StringPlus strclass = new StringPlus();
StringPlus strclass0 = new StringPlus();
StringPlus strclass1 = new StringPlus();
StringPlus strclass2 = new StringPlus();
strclass.AppendLine();
strclass.AppendSpaceLine(1,"string strErr=\"\";");
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
string deText = field.DeText;
bool ispk = field.IsPK;
bool IsIdentity = field.IsIdentity;
if ((ispk) || (IsIdentity))
{
continue;
}
switch (CodeCommon.DbTypeToCS(columnType.Trim().ToLower()).ToLower())
{
case "int":
case "smallint":
strclass0.AppendSpaceLine(1,"int " + columnName + "=int.Parse(this.txt" + columnName + ".Text);" );
strclass1.AppendSpaceLine(1,"if(!PageValidate.IsNumber(txt" + columnName + ".Text))" );
strclass1.AppendSpaceLine(1,"{");
strclass1.AppendSpaceLine(2,"strErr+=\"" + columnName + "不是数字！\\\\n\"; ");
strclass1.AppendSpaceLine(1,"}");
break;
case "float":
case "numeric":
case "decimal":
strclass0.AppendSpaceLine(1,"decimal " + columnName + "=decimal.Parse(this.txt" + columnName + ".Text);" );
strclass1.AppendSpaceLine(1,"if(!PageValidate.IsDecimal(txt" + columnName + ".Text))");
strclass1.AppendSpaceLine(1,"{");
strclass1.AppendSpaceLine(2,"strErr+=\"" + columnName + "不是数字！\\\\n\"; " );
strclass1.AppendSpaceLine(1,"}" );
break;
case "datetime":
case "smalldatetime":
strclass0.AppendSpaceLine(1,"DateTime " + columnName + "=DateTime.Parse(this.txt" + columnName + ".Text);" );
strclass1.AppendSpaceLine(1,"if(!PageValidate.IsDateTime(txt" + columnName + ".Text))" );
strclass1.AppendSpaceLine(1,"{" );
strclass1.AppendSpaceLine(1,"strErr+=\"" + columnName + "不是时间格式！\\\\n\"; " );
strclass1.AppendSpaceLine(1,"}" );
break;
case "bool":
strclass0.AppendSpaceLine(1,"bool " + columnName + "=this.chk" + columnName + ".Checked;" );
break;
case "byte[]":
strclass0.AppendSpaceLine(1,"byte[] " + columnName + "= new UnicodeEncoding().GetBytes(this.txt" + columnName + ".Text);" );
break;
default:
strclass0.AppendSpaceLine(1,"string " + columnName + "=this.txt" + columnName + ".Text;" );
strclass1.AppendSpaceLine(1,"if(this.txt" + columnName + ".Text ==\"\")" );
strclass1.AppendSpaceLine(1,"{" );
strclass1.AppendSpaceLine(2,"strErr+=\"" + columnName + "不能为空！\\\\n\"; " );
strclass1.AppendSpaceLine(1,"}" );
break;
}
strclass2.AppendSpaceLine(1,"model." + columnName + "=" + columnName + ";" );
}
strclass.AppendLine(strclass1.ToString() );
strclass.AppendSpaceLine(1,"if(strErr!=\"\")" );
strclass.AppendSpaceLine(1,"{" );
strclass.AppendSpaceLine(2,"MessageBox.Show(this,strErr);" );
strclass.AppendSpaceLine(2,"return;" );
strclass.AppendSpaceLine(1,"}" );
strclass.AppendLine(strclass0.ToString() );
strclass.AppendSpaceLine(1, ModelSpace + " model=new " + ModelSpace + "();" );
strclass.AppendLine(strclass2.ToString());
strclass.AppendSpaceLine(1, BLLSpace + " bll=new " + BLLSpace + "();" );
strclass.AppendSpaceLine(1,"bll.Add(model);");
return strclass.Value;
}
/// <summary>
/// 得到修改窗体的代码
/// </summary>
public string GetUpdateAspxCs()
{
StringPlus strclass = new StringPlus();
StringPlus strclass0 = new StringPlus();
StringPlus strclass1 = new StringPlus();
StringPlus strclass2 = new StringPlus();
strclass.AppendLine();
strclass.AppendSpaceLine(1,"string strErr=\"\";");
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
bool ispk = field.IsPK;
bool IsIdentity = field.IsIdentity;
if ((ispk) || (IsIdentity))
{
continue;
}
switch (CodeCommon.DbTypeToCS(columnType.Trim().ToLower()).ToLower())
{
case "int":
case "smallint":
strclass0.AppendSpaceLine(1,"int " + columnName + "=int.Parse(this.txt" + columnName + ".Text);" );
strclass1.AppendSpaceLine(1,"if(!PageValidate.IsNumber(txt" + columnName + ".Text))" );
strclass1.AppendSpaceLine(1,"{" );
strclass1.AppendSpaceLine(2,"strErr+=\"" + columnName + "不是数字！\\\\n\"; " );
strclass1.AppendSpaceLine(1,"}" );
break;
case "float":
case "numeric":
case "decimal":
strclass0.AppendSpaceLine(1,"decimal " + columnName + "=decimal.Parse(this.txt" + columnName + ".Text);" );
strclass1.AppendSpaceLine(1,"if(!PageValidate.IsDecimal(txt" + columnName + ".Text))" );
strclass1.AppendSpaceLine(1,"{" );
strclass1.AppendSpaceLine(2,"strErr+=\"" + columnName + "不是数字！\\\\n\"; " );
strclass1.AppendSpaceLine(1,"}" );
break;
case "datetime":
case "smalldatetime":
strclass0.AppendSpaceLine(1,"DateTime " + columnName + "=DateTime.Parse(this.txt" + columnName + ".Text);" );
strclass1.AppendSpaceLine(1,"if(!PageValidate.IsDateTime(txt" + columnName + ".Text))" );
strclass1.AppendSpaceLine(1,"{" );
strclass1.AppendSpaceLine(2,"strErr+=\"" + columnName + "不是时间格式！\\\\n\"; " );
strclass1.AppendSpaceLine(1,"}" );
break;
case "bool":
strclass0.AppendSpaceLine(1,"bool " + columnName + "=this.chk" + columnName + ".Checked;" );
break;
case "byte[]":
strclass0.AppendSpaceLine(1,"byte[] " + columnName + "= new UnicodeEncoding().GetBytes(this.txt" + columnName + ".Text);" );
break;
default:
strclass0.AppendSpaceLine(1,"string " + columnName + "=this.txt" + columnName + ".Text;" );
strclass1.AppendSpaceLine(1,"if(this.txt" + columnName + ".Text ==\"\")" );
strclass1.AppendSpaceLine(1,"{" );
strclass1.AppendSpaceLine(2,"strErr+=\"" + columnName + "不能为空！\\\\n\"; " );
strclass1.AppendSpaceLine(1,"}" );
break;
}
strclass2.AppendSpaceLine(1,"model." + columnName + "=" + columnName + ";" );
}
strclass.AppendLine(strclass1.ToString() );
strclass.AppendSpaceLine(1,"if(strErr!=\"\")" );
strclass.AppendSpaceLine(1,"{" );
strclass.AppendSpaceLine(2,"MessageBox.Show(this,strErr);" );
strclass.AppendSpaceLine(2,"return;" );
strclass.AppendSpaceLine(1,"}" );
strclass.AppendLine(strclass0.ToString() );
strclass.AppendLine();
strclass.AppendSpaceLine(1,ModelSpace + " model=new " + ModelSpace + "();" );
strclass.AppendLine(strclass2.ToString());
strclass.AppendSpaceLine(1,BLLSpace + " bll=new " + BLLSpace + "();" );
strclass.AppendSpaceLine(1,"bll.Update(model);");
return strclass.ToString();
}
/// <summary>
/// 得到修改窗体的代码
/// </summary>
public string GetUpdateShowAspxCs()
{
StringPlus strclass = new StringPlus();
strclass.AppendLine();
string key = Key;
strclass.AppendSpaceLine(1,"private void ShowInfo(" + LTP.CodeHelper.CodeCommon.GetInParameter(Keys) + ")" );
strclass.AppendSpaceLine(1,"{" );
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -