📄 builderdal.cs
字号:
strclass.AppendSpaceLine(2, "public void Update(" + ModelSpace + " model)" );
strclass.AppendSpaceLine(2, "{" );
strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();" );
strclass.AppendSpaceLine(3, "strSql.Append(\"update " + _tablename + " set \");" );
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
string Length = field.Length;
bool IsIdentity = field.IsIdentity;
bool isPK = field.IsPK;
if (field.IsIdentity || field.IsPK || (Keys.Contains(field)))
{
continue;
}
strclass.AppendSpaceLine(3, "if (model." + columnName + " != null)");
strclass.AppendSpaceLine(3, "{");
if ((dbobj.DbType == "Oracle") && (columnType.ToLower() == "date" || columnType.ToLower() == "datetime"))
{
strclass.AppendSpaceLine(4, "strSql.Append(\"" + columnName + "=to_date('\" + model." + columnName + ".ToString() + \"','YYYY-MM-DD HH24:MI:SS'),\");");
}
else
if (CodeCommon.IsAddMark(columnType.Trim()))
{
strclass.AppendSpaceLine(4, "strSql.Append(\"" + columnName + "='\"+model." + columnName + "+\"',\");" );
}
else
{
strclass.AppendSpaceLine(4, "strSql.Append(\"" + columnName + "=\"+model." + columnName + "+\",\");" );
}
strclass.AppendSpaceLine(3, "}");
}
//去掉最后的逗号
strclass.AppendSpaceLine(3, "int n = strSql.ToString().LastIndexOf(\",\");");
strclass.AppendSpaceLine(3, "strSql.Remove(n, 1);");
strclass.AppendSpaceLine(3, "strSql.Append(\" where " + LTP.CodeHelper.CodeCommon.GetModelWhereExpression(Keys) + "\");");
strclass.AppendSpaceLine(3, "" + DbHelperName + ".ExecuteSql(strSql.ToString());" );
strclass.AppendSpace(2, "}");
return strclass.ToString();
}
/// <summary>
/// 得到Delete的代码
/// </summary>
/// <param name="_tablename"></param>
/// <param name="_key"></param>
/// <returns></returns>
public string CreatDelete()
{
StringPlus strclass = new StringPlus();
strclass.AppendLine("");
strclass.AppendSpaceLine(2,"/// <summary>" );
strclass.AppendSpaceLine(2,"/// 删除一条数据" );
strclass.AppendSpaceLine(2,"/// </summary>" );
strclass.AppendSpaceLine(2,"public void Delete(" + LTP.CodeHelper.CodeCommon.GetInParameter(Keys) + ")" );
strclass.AppendSpaceLine(2,"{" );
strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();" );
if (dbobj.DbType != "OleDb")
{
strclass.AppendSpaceLine(3, "strSql.Append(\"delete " + _tablename + " \");" );
}
else
{
strclass.AppendSpaceLine(3, "strSql.Append(\"delete from " + _tablename + " \");" );
}
strclass.AppendSpaceLine(3, "strSql.Append(\" where " + LTP.CodeHelper.CodeCommon.GetWhereExpression(Keys) + "\" );" );
strclass.AppendSpaceLine(3, DbHelperName + ".ExecuteSql(strSql.ToString());" );
strclass.AppendSpace(2,"}");
return strclass.ToString();
}
/// <summary>
/// 得到GetModel()的代码
/// </summary>
/// <param name="DbName"></param>
/// <param name="_tablename"></param>
/// <param name="_key"></param>
/// <param name="ModelName"></param>
/// <returns></returns>
public string CreatGetModel()
{
if (ModelSpace == "")
{
//ModelSpace = "ModelClassName"; ;
}
StringPlus strclass = new StringPlus();
strclass.AppendLine();
strclass.AppendSpaceLine(2, "/// <summary>" );
strclass.AppendSpaceLine(2, "/// 得到一个对象实体" );
strclass.AppendSpaceLine(2, "/// </summary>" );
strclass.AppendSpaceLine(2, "public " + ModelSpace + " GetModel(" + LTP.CodeHelper.CodeCommon.GetInParameter(Keys) + ")" );
strclass.AppendSpaceLine(2, "{" );
strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();" );
strclass.AppendSpace(3, "strSql.Append(\"select " );
if ((dbobj.DbType == "SQL2005") || (dbobj.DbType == "SQL2000"))
{
strclass.Append(" top 1 ");
}
strclass.AppendLine( " \");");
strclass.AppendSpaceLine(3, "strSql.Append(\" " + Fieldstrlist + " \");" );
strclass.AppendSpaceLine(3, "strSql.Append(\" from " + _tablename + " \");" );
strclass.AppendSpaceLine(3, "strSql.Append(\" where " + LTP.CodeHelper.CodeCommon.GetWhereExpression(Keys) + "\" );" );
strclass.AppendSpaceLine(3, ModelSpace + " model=new " + ModelSpace + "();" );
strclass.AppendSpaceLine(3, "DataSet ds=" + DbHelperName + ".Query(strSql.ToString());" );
strclass.AppendSpaceLine(3, "if(ds.Tables[0].Rows.Count>0)" );
strclass.AppendSpaceLine(3, "{" );
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
switch (CodeCommon.DbTypeToCS(columnType))
{
case "int":
{
strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")" );
strclass.AppendSpaceLine(4, "{" );
strclass.AppendSpaceLine(5, "model." + columnName + "=int.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());" );
strclass.AppendSpaceLine(4, "}" );
}
break;
case "long":
{
strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model." + columnName + "=long.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());");
strclass.AppendSpaceLine(4, "}");
}
break;
case "decimal":
{
strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")" );
strclass.AppendSpaceLine(4, "{" );
strclass.AppendSpaceLine(5, "model." + columnName + "=decimal.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());" );
strclass.AppendSpaceLine(4, "}" );
}
break;
case "float":
{
strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model." + columnName + "=float.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());");
strclass.AppendSpaceLine(4, "}");
}
break;
case "DateTime":
{
strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")" );
strclass.AppendSpaceLine(4, "{" );
strclass.AppendSpaceLine(5, "model." + columnName + "=DateTime.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());" );
strclass.AppendSpaceLine(4, "}" );
}
break;
case "string":
{
strclass.AppendSpaceLine(4, "model." + columnName + "=ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();" );
}
break;
case "bool":
{
strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")" );
strclass.AppendSpaceLine(4, "{" );
strclass.AppendSpaceLine(5, "if((ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()==\"1\")||(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString().ToLower()==\"true\"))" );
strclass.AppendSpaceLine(5, "{" );
strclass.AppendSpaceLine(6, "model." + columnName + "=true;" );
strclass.AppendSpaceLine(5, "}" );
strclass.AppendSpaceLine(5, "else" );
strclass.AppendSpaceLine(5, "{" );
strclass.AppendSpaceLine(6, "model." + columnName + "=false;" );
strclass.AppendSpaceLine(5, "}" );
strclass.AppendSpaceLine(4, "}" );
}
break;
case "byte[]":
{
strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")" );
strclass.AppendSpaceLine(4, "{" );
strclass.AppendSpaceLine(5, "model." + columnName + "=(byte[])ds.Tables[0].Rows[0][\"" + columnName + "\"];" );
strclass.AppendSpaceLine(4, "}" );
}
break;
case "Guid":
{
strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")" );
strclass.AppendSpaceLine(4, "{" );
strclass.AppendSpaceLine(5, "model." + columnName + "=new Guid(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());" );
strclass.AppendSpaceLine(4, "}" );
}
break;
default:
strclass.AppendSpaceLine(4, "//model." + columnName + "=ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();" );
break;
}
}
strclass.AppendSpaceLine(4, "return model;" );
strclass.AppendSpaceLine(3, "}" );
strclass.AppendSpaceLine(3, "else" );
strclass.AppendSpaceLine(3, "{" );
strclass.AppendSpaceLine(4, "return null;" );
strclass.AppendSpaceLine(3, "}" );
strclass.AppendSpace(2, "}");
return strclass.ToString();
}
/// <summary>
/// 得到GetList()的代码
/// </summary>
/// <param name="_tablename"></param>
/// <param name="_key"></param>
/// <returns></returns>
public string CreatGetList()
{
StringPlus strclass = new StringPlus();
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// 获得数据列表");
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public DataSet GetList(string strWhere)");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
strclass.AppendSpace(3, "strSql.Append(\"select ");
strclass.AppendLine(Fieldstrlist + " \");");
strclass.AppendSpaceLine(3, "strSql.Append(\" FROM " + TableName + " \");");
strclass.AppendSpaceLine(3, "if(strWhere.Trim()!=\"\")");
strclass.AppendSpaceLine(3, "{" );
strclass.AppendSpaceLine(4, "strSql.Append(\" where \"+strWhere);");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "return " + DbHelperName + ".Query(strSql.ToString());");
strclass.AppendSpaceLine(2, "}");
return strclass.Value;
}
/// <summary>
/// 得到GetList()的代码
/// </summary>
/// <param name="_tablename"></param>
/// <param name="_key"></param>
/// <returns></returns>
public string CreatGetListByPageProc()
{
StringPlus strclass = new StringPlus();
strclass.AppendSpaceLine(2, "/*");
//strclass.AppendSpaceLine(2, "/// <summary>");
//strclass.AppendSpaceLine(2, "/// 分页获取数据列表");
//strclass.AppendSpaceLine(2, "/// </summary>");
//strclass.AppendSpaceLine(2, "public DataSet GetList(int PageSize,int PageIndex,string strWhere)");
//strclass.AppendSpaceLine(2, "{");
//strclass.AppendSpaceLine(3, "" + DbParaHead + "Parameter[] parameters = {");
//strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "tblName\", " + DbParaDbType + ".VarChar, 255),");
//strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "fldName\", " + DbParaDbType + ".VarChar, 255),");
//strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "PageSize\", " + DbParaDbType + "." + CodeCommon.CSToProcType(dbobj.DbType, "int") + "),");
//strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "PageIndex\", " + DbParaDbType + "." + CodeCommon.CSToProcType(dbobj.DbType, "int") + "),");
//strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "IsReCount\", " + DbParaDbType + "." + CodeCommon.CSToProcType(dbobj.DbType, "bit") + "),");
//strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "OrderType\", " + DbParaDbType + "." + CodeCommon.CSToProcType(dbobj.DbType, "bit") + "),");
//strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "strWhere\", " + DbParaDbType + ".VarChar,1000),");
//strclass.AppendSpaceLine(5, "};");
//strclass.AppendSpaceLine(3, "parameters[0].Value = \"" + TableName + "\";");
//strclass.AppendSpaceLine(3, "parameters[1].Value = \"" + _key + "\";");
//strclass.AppendSpaceLine(3, "parameters[2].Value = PageSize;");
//strclass.AppendSpaceLine(3, "parameters[3].Value = PageIndex;");
//strclass.AppendSpaceLine(3, "parameters[4].Value = 0;");
//strclass.AppendSpaceLine(3, "parameters[5].Value = 0;");
//strclass.AppendSpaceLine(3, "parameters[6].Value = strWhere; ");
//strclass.AppendSpaceLine(3, "return " + DbHelperName + ".RunProcedure(\"UP_GetRecordByPage\",parameters,\"ds\");");
//strclass.AppendSpaceLine(2, "}");
strclass.AppendSpaceLine(2, "*/");
return strclass.Value;
}
#endregion//数据层
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -