/// <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}"); }