private string CreateAdd()
{
StringBuilder source = new StringBuilder();
//创建方法头
source.AppendLine("public int _Add(" + tableInfo.TypeFullName + " model, SqlTranExtensions _SqlTranExtensions){");
source.AppendLine(tryStart());
//创建SQL语句头
source.AppendLine("strSql.Append(\"insert into " + tableInfo.Table.Name + "(\");");
//创建列名列表
source.AppendLine("strSql.Append(\"" + AttributeHelper.GetColunsString(tableInfo.Columns, true) + ")\"" + ");");
source.AppendLine("strSql.Append(\" values (\");");
//创建列名值列表
source.AppendLine(string.Format("strSql.Append(\"{0})\");", AttributeHelper.GetValuesString(tableInfo.Columns, true)));
source.AppendLine("strSql.Append(\";select @@IDENTITY\");");
//创建参数列表
source.AppendLine("SqlParameter[] parameters = {" + AttributeHelper.GetSqlParameterDeclare(tableInfo.Columns, true) + "};");
//创建参数赋值
source.AppendLine(AttributeHelper.GetSqlParameterValue(tableInfo.Columns, true));
//创建执行命令
source.AppendLine("if(_SqlTranExtensions != null){_SqlTranExtensions.Add(strSql.ToString(),parameters);return 0;}");
//判断数据库
source.AppendLine("object obj = null;");
source.AppendLine(@"if(DataHelper.IsAccess){
obj = DbHelperOleDb.GetSingle(strSql.ToString(), DataHelper.GetOleDbParameterBySqlParameter(parameters));
}else{
obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
}");
source.AppendLine("return obj == null ? -1 : Convert.ToInt32(obj);");
source.AppendLine(tryEnd());
source.AppendLine("}");
return(source.ToString());
}
private string CreateGetList1()
{
StringBuilder source = new StringBuilder();
//创建方法头
source.AppendLine("public DataSet _GetList(int Top, string strWhere, SqlParameter[] cmdParms, string filedOrder ){");
source.AppendLine(tryStart());
//创建SQL语句头
source.AppendLine("strSql.Append(\"select \");");
//创建Top
source.AppendLine("if (Top > 0) strSql.Append(\" top \" + Top.ToString());");
//创建字段列表
source.AppendLine(string.Format("strSql.Append(\" {0} \");", AttributeHelper.GetColunsString(tableInfo.Columns)));
//创建From
source.AppendLine(string.Format("strSql.Append(\" FROM {0} \");", tableInfo.Table.Name));
//创建Where
source.AppendLine("if (strWhere.Trim() != \"\") strSql.Append(\" where \" + strWhere);");
//创建Order
source.AppendLine("if(filedOrder.Trim()!=\"\")strSql.Append(\" order by \" + filedOrder);");
//创建执行命令
//判断数据库
source.AppendLine(@"if(DataHelper.IsAccess){
return DbHelperOleDb.Query(strSql.ToString(), DataHelper.GetOleDbParameterBySqlParameter(cmdParms));
}");
source.AppendLine(@"else{
return DbHelperSQL.Query(strSql.ToString(), cmdParms);
}");
source.AppendLine(tryEnd());
source.AppendLine("}");
return(source.ToString());
}
