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