/// <summary>
/// 创建更新方法
/// </summary>
/// <param name="table">表对象</param>
/// <param name="storedProcedurePrefix">存储过程前缀</param>
/// <param name="streamWriter">写入文件流</param>
private static void CreateUpdateMethod(Table table, string storedProcedurePrefix, StreamWriter streamWriter)
{
if (table.PrimaryKeys.Count > 0 && table.Columns.Count != table.PrimaryKeys.Count && table.Columns.Count != table.ForeignKeys.Count)
{
// 插入空行
streamWriter.WriteLine();
streamWriter.WriteLine();
// 头
streamWriter.WriteLine("\t\t/// <summary>");
streamWriter.WriteLine("\t\t/// 更新记录");
streamWriter.WriteLine("\t\t/// </summary>");
streamWriter.Write("\t\tpublic static void Update(" + Utility.FormatPascal(table.ProgrammaticAlias) + " " + table.ProgrammaticAlias.ToLower() + ")");
streamWriter.WriteLine("\t\t{");
streamWriter.WriteLine("\t\t\tString strSpName = \"" + storedProcedurePrefix + table.Name + "Update\";");
streamWriter.WriteLine("\t\t\tSqlParameter[] sqlSpParaArray = new SqlParameter[" + table.Columns.Count.ToString() + "];");
// 创建参数
streamWriter.WriteLine("\t\t\t// 创建参数");
for (int i = 0; i < table.Columns.Count; i++)
{
Column column = (Column)table.Columns[i];
streamWriter.WriteLine("\t\t\t" + "sqlSpParaArray[" + i.ToString() + "] =" + Utility.CreateSqlParameterNoCommand(table, column, false) + ";");
}
streamWriter.WriteLine("\t\t\t" + "DataProvider.Instance.ExecuteSp(strSpName,sqlSpParaArray);");
streamWriter.WriteLine("");
streamWriter.WriteLine("\t\t}");
}
}
/// <summary>
/// 创建新增方法
/// </summary>
/// <param name="table">表对象</param>
/// <param name="storedProcedurePrefix">存储过程前缀</param>
/// <param name="streamWriter">写入文件流</param>
private static void CreateInsertMethod(Table table, string storedProcedurePrefix, StreamWriter streamWriter)
{
// Append the method header
streamWriter.WriteLine("\t\t/// <summary>");
streamWriter.WriteLine("\t\t/// 新增记录");
streamWriter.WriteLine("\t\t/// </summary>");
streamWriter.Write("\t\tpublic static void Insert(" + Utility.FormatPascal(table.ProgrammaticAlias) + " " + table.ProgrammaticAlias.ToLower() + ")");
streamWriter.WriteLine("\t\t{");
streamWriter.WriteLine("\t\t\tString strSpName = \"" + storedProcedurePrefix + table.Name + "Insert\";");
streamWriter.WriteLine("\t\t\tSqlParameter[] sqlSpParaArray = new SqlParameter[" + table.Columns.Count.ToString() + "];");
// 创建参数
streamWriter.WriteLine("\t\t\t// 创建参数");
for (int i = 0; i < table.Columns.Count; i++)
{
Column column = (Column)table.Columns[i];
streamWriter.WriteLine("\t\t\t" + "sqlSpParaArray[" + i.ToString() + "] =" + Utility.CreateSqlParameterNoCommand(table, column, true) + ";");
}
streamWriter.WriteLine("\t\t\t" + "DataProvider.Instance.ExecuteSp(strSpName,sqlSpParaArray);");
streamWriter.WriteLine("");
streamWriter.WriteLine("\t\t}");
}
