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()); }