📄 builderframeone.cs
字号:
plus.Append(base.Space(4) + "{\r\n");
plus.Append(base.Space(5) + "if((ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()==\"1\")||(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString().ToLower()==\"true\"))\r\n");
plus.Append(base.Space(5) + "{\r\n");
plus.Append(base.Space(6) + "" + columnName + "=true;\r\n");
plus.Append(base.Space(5) + "}\r\n");
plus.Append(base.Space(5) + "else\r\n");
plus.Append(base.Space(5) + "{\r\n");
plus.Append(base.Space(6) + "" + columnName + "=false;\r\n");
plus.Append(base.Space(5) + "}\r\n");
plus.Append(base.Space(4) + "}\r\n\r\n");
continue;
}
case "byte[]":
{
plus.Append(base.Space(4) + "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")\r\n");
plus.Append(base.Space(4) + "{\r\n");
plus.Append(base.Space(5) + "" + columnName + "=(byte[])ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();\r\n");
plus.Append(base.Space(4) + "}\r\n");
continue;
}
}
plus.AppendSpaceLine(4, "" + columnName + "=ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();");
}
plus.AppendSpaceLine(3, "}");
plus.AppendSpaceLine(2, "}");
return plus.Value;
}
private string CreatGetModelSQL()
{
StringBuilder builder = new StringBuilder();
builder.Append("\r\n");
builder.Append(base.Space(2) + "/// <summary>\r\n");
builder.Append(base.Space(2) + "/// 得到一个对象实体\r\n");
builder.Append(base.Space(2) + "/// </summary>\r\n");
builder.Append(base.Space(2) + "public void GetModel(" + CodeCommon.GetInParameter(base.Keys) + ")\r\n");
builder.Append(base.Space(2) + "{\r\n");
builder.Append(base.Space(3) + "StringBuilder strSql=new StringBuilder();\r\n");
builder.Append(base.Space(3) + "strSql.Append(\"select \");\r\n");
builder.Append(base.Space(3) + "strSql.Append(\"" + base.Fieldstrlist + " \");\r\n");
builder.Append(base.Space(3) + "strSql.Append(\" from " + base.TableName + " \");\r\n");
if (CodeCommon.GetWhereExpression(base.Keys).Length > 0)
{
builder.Append(base.Space(3) + "strSql.Append(\" where " + CodeCommon.GetWhereExpression(base.Keys) + ");\r\n");
}
else
{
builder.Append(base.Space(3) + "//strSql.Append(\" where 条件);\r\n");
}
builder.Append(base.Space(3) + "DataSet ds=" + base.DbHelperName + ".Query(strSql.ToString());\r\n");
builder.Append(base.Space(3) + "if(ds.Tables[0].Rows.Count>0)\r\n");
builder.Append(base.Space(3) + "{\r\n");
foreach (ColumnInfo info in base.Fieldlist)
{
string columnName = info.ColumnName;
switch (CodeCommon.DbTypeToCS(info.TypeName))
{
case "int":
{
builder.Append(base.Space(4) + "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")\r\n");
builder.Append(base.Space(4) + "{\r\n");
builder.Append(base.Space(5) + "" + columnName + "=int.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());\r\n");
builder.Append(base.Space(4) + "}\r\n");
continue;
}
case "decimal":
{
builder.Append(base.Space(4) + "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")\r\n");
builder.Append(base.Space(4) + "{\r\n");
builder.Append(base.Space(5) + "" + columnName + "=decimal.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());\r\n");
builder.Append(base.Space(4) + "}\r\n");
continue;
}
case "DateTime":
{
builder.Append(base.Space(4) + "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")\r\n");
builder.Append(base.Space(4) + "{\r\n");
builder.Append(base.Space(5) + "" + columnName + "=DateTime.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());\r\n");
builder.Append(base.Space(4) + "}\r\n");
continue;
}
case "string":
{
builder.Append(base.Space(4) + "" + columnName + "=ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();\r\n");
continue;
}
case "bool":
{
builder.Append(base.Space(4) + "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")\r\n");
builder.Append(base.Space(4) + "{\r\n");
builder.Append(base.Space(5) + "if((ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()==\"1\")||(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString().ToLower()==\"true\"))\r\n");
builder.Append(base.Space(5) + "{\r\n");
builder.Append(base.Space(6) + "" + columnName + "=true;\r\n");
builder.Append(base.Space(5) + "}\r\n");
builder.Append(base.Space(5) + "else\r\n");
builder.Append(base.Space(5) + "{\r\n");
builder.Append(base.Space(6) + "" + columnName + "=false;\r\n");
builder.Append(base.Space(5) + "}\r\n");
builder.Append(base.Space(4) + "}\r\n\r\n");
continue;
}
case "byte[]":
{
builder.Append(base.Space(4) + "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")\r\n");
builder.Append(base.Space(4) + "{\r\n");
builder.Append(base.Space(5) + "" + columnName + "=(byte[])ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();\r\n");
builder.Append(base.Space(4) + "}\r\n");
continue;
}
}
builder.Append(base.Space(4) + "" + columnName + "=ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();\r\n");
}
builder.Append(base.Space(3) + "}\r\n");
builder.Append(base.Space(2) + "}");
return builder.ToString();
}
private string CreatUpdateParam()
{
StringPlus plus = new StringPlus();
StringPlus plus2 = new StringPlus();
StringPlus plus3 = new StringPlus();
plus.AppendSpaceLine(2, "/// <summary>");
plus.AppendSpaceLine(2, "/// 更新一条数据");
plus.AppendSpaceLine(2, "/// </summary>");
plus.AppendSpaceLine(2, "public void Update()");
plus.AppendSpaceLine(2, "{");
plus.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
plus.AppendSpaceLine(3, "strSql.Append(\"update " + base.TableName + " set \");");
int num = 0;
foreach (ColumnInfo info in base.Fieldlist)
{
string columnName = info.ColumnName;
string typeName = info.TypeName;
string length = info.Length;
bool isIdentity = info.IsIdentity;
bool isPK = info.IsPK;
plus2.AppendSpaceLine(5, "new " + base.DbParaHead + "Parameter(\"@" + columnName + "\", " + base.DbParaDbType + "." + CodeCommon.DbTypeLength(base._dbtype, typeName, length) + "),");
plus3.AppendSpaceLine(3, string.Concat(new object[] { "parameters[", num, "].Value = ", columnName, ";" }));
num++;
if ((!info.IsIdentity && !info.IsPK) && !base.Keys.Contains(info))
{
plus.AppendSpaceLine(3, "strSql.Append(\"" + columnName + "=@" + columnName + ",\");");
}
}
if (plus.Value.IndexOf(",") > 0)
{
plus.DelLastComma();
}
plus.AppendLine("\");");
if (this.GetWhereExpression(base.Keys).Length > 0)
{
plus.AppendSpace(3, "strSql.Append(\" where " + this.GetWhereExpression(base.Keys) + "\");\r\n");
}
else
{
plus.AppendSpace(3, "//strSql.Append(\" where 条件);\r\n");
}
plus.AppendSpaceLine(3, "" + base.DbParaHead + "Parameter[] parameters = {");
if (plus2.Value.IndexOf(",") > 0)
{
plus2.DelLastComma();
}
plus.Append(plus2.Value);
plus.AppendLine("};");
plus.AppendLine(plus3.Value);
plus.AppendSpaceLine(3, "" + base.DbHelperName + ".ExecuteSql(strSql.ToString(),parameters);");
plus.AppendSpaceLine(2, "}");
return plus.ToString();
}
private string CreatUpdateProc()
{
StringPlus plus = new StringPlus();
StringPlus plus2 = new StringPlus();
plus.AppendSpaceLine(2, "/// <summary>");
plus.AppendSpaceLine(2, "/// 更新一条数据");
plus.AppendSpaceLine(2, "/// </summary>");
plus.AppendSpaceLine(2, "public void Update()");
plus.AppendSpaceLine(2, "{");
plus.AppendSpaceLine(3, "int rowsAffected;");
plus.AppendSpaceLine(3, "" + base.DbParaHead + "Parameter[] parameters = {");
int num = 0;
foreach (ColumnInfo info in base.Fieldlist)
{
string columnName = info.ColumnName;
string typeName = info.TypeName;
string length = info.Length;
plus.AppendSpaceLine(5, "new " + base.DbParaHead + "Parameter(\"@" + columnName + "\", " + base.DbParaDbType + "." + CodeCommon.DbTypeLength(base._dbtype, typeName, length) + "),");
plus2.AppendSpaceLine(3, string.Concat(new object[] { "parameters[", num, "].Value = ", columnName, ";" }));
num++;
}
if (plus.Value.IndexOf(",") > 0)
{
plus.DelLastComma();
}
plus.AppendLine("};");
plus.AppendLine(plus2.Value);
plus.AppendSpaceLine(3, "" + base.DbHelperName + ".RunProcedure(\"UP_" + base.TableName + "_Update\",parameters,out rowsAffected);");
plus.AppendSpaceLine(2, "}");
return plus.Value;
}
private string CreatUpdateSQL()
{
StringBuilder builder = new StringBuilder();
builder.Append("\r\n");
builder.Append(base.Space(2) + "/// <summary>\r\n");
builder.Append(base.Space(2) + "/// 更新一条数据\r\n");
builder.Append(base.Space(2) + "/// </summary>\r\n");
builder.Append(base.Space(2) + "public void Update()\r\n");
builder.Append(base.Space(2) + "{\r\n");
builder.Append(base.Space(3) + "StringBuilder strSql=new StringBuilder();\r\n");
builder.Append(base.Space(3) + "strSql.Append(\"update " + base.TableName + " set \");\r\n");
foreach (ColumnInfo info in base.Fieldlist)
{
string columnName = info.ColumnName;
string typeName = info.TypeName;
string length = info.Length;
bool isIdentity = info.IsIdentity;
bool isPK = info.IsPK;
if ((!info.IsIdentity && !info.IsPK) && !base.Keys.Contains(info))
{
if (CodeCommon.IsAddMark(typeName.Trim()))
{
builder.Append(base.Space(3) + "strSql.Append(\"" + columnName + "='\"+" + columnName + "+\"',\");\r\n");
}
else
{
builder.Append(base.Space(3) + "strSql.Append(\"" + columnName + "=\"+" + columnName + "+\",\");\r\n");
}
}
}
builder.Remove(builder.Length - 6, 1);
builder.Append(base.Space(3) + "strSql.Append(\" where " + CodeCommon.GetWhereExpression(base.Keys) + "\");\r\n");
builder.Append(base.Space(3) + "" + ba⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -