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 CreateUpdate() { StringBuilder source = new StringBuilder(); //创建方法头 source.AppendLine("public void _Update(" + tableInfo.TypeFullName + " model, SqlTranExtensions _SqlTranExtensions){"); source.AppendLine(tryStart()); //创建SQL语句头 source.AppendLine(string.Format("strSql.Append(\"update {0} set \");", tableInfo.Table.Name)); //创建更新字段列表 source.AppendLine(AttributeHelper.GetUpdateColumns(tableInfo.Columns)); //创建参数列表 source.AppendLine("SqlParameter[] parameters = {" + AttributeHelper.GetSqlParameterDeclare(tableInfo.Columns) + "};"); //创建参数赋值 source.AppendLine(AttributeHelper.GetSqlParameterValue(tableInfo.Columns)); //创建执行命令 source.AppendLine("if(_SqlTranExtensions != null){_SqlTranExtensions.Add(strSql.ToString(),parameters);return;}"); //判断数据库 source.AppendLine(@"if(DataHelper.IsAccess){ DbHelperOleDb.ExecuteSql(strSql.ToString(), DataHelper.GetOleDbParameterBySqlParameter(parameters)); }else{ DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }"); source.AppendLine(tryEnd()); source.AppendLine("}"); return(source.ToString()); }
private string CreateDelete() { StringBuilder source = new StringBuilder(); //创建方法头 source.AppendLine(" public void _Delete(" + AttributeHelper.PrimaryKeyTypeToCs(primaryKey) + " " + primaryKey.Name + ", SqlTranExtensions _SqlTranExtensions){"); source.AppendLine(tryStart()); //创建SQL语句头 source.AppendLine(string.Format("strSql.Append(\"delete from {0} \");", tableInfo.Table.Name)); //创建以主键为条件语句 source.AppendLine(AttributeHelper.GetPrimaryKeyWhere(primaryKey)); //创建参数列表 source.AppendLine("SqlParameter[] parameters = {" + AttributeHelper.GetSqlParameterDeclare(new ColumnAttribute[] { primaryKey }) + "};"); //创建参数赋值 source.AppendLine(AttributeHelper.GetSqlParameterValue(new ColumnAttribute[] { primaryKey }).Replace("model.", "")); //创建执行命令 source.AppendLine("if(_SqlTranExtensions != null){_SqlTranExtensions.Add(strSql.ToString(),parameters);return;}"); //判断数据库 source.AppendLine(@"if(DataHelper.IsAccess){ DbHelperOleDb.ExecuteSql(strSql.ToString(), DataHelper.GetOleDbParameterBySqlParameter(parameters)); }"); source.AppendLine(@"else{ DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }"); source.AppendLine(tryEnd()); source.AppendLine("}"); return(source.ToString()); }