protected void Page_Load(object sender, EventArgs e) { BcodeList = Cnf07.GetList(); WherehouseList = Cnf10.GetList("004"); InReasonList = Cnf10.GetList("S15"); CurrencyList = Cnf10.GetList("073"); Inf29.CreateKeywordSP(); }
public static int AddItem(Inf29 inf29, Inf29.ImportItemRow inf29aRow) { if (inf29aRow == null || inf29aRow.Count == 0) { throw new ArgumentNullException("inf29aRow"); } var lastSeq = GetLastSeq(inf29.inf2901_docno); int inf29a02_seq = ++lastSeq; var fields = inf29aRow.Keys.ToArray(); string fieldNamesSql = String.Join(", ", fields); string paramsFieldsSql = String.Join(",@", fields); using (var conn = new SqlConnection { ConnectionString = MyConnStringList.AzureGoodeasy }) using (var sqlCmd = conn.CreateCommand()) { conn.Open(); sqlCmd.CommandText = String.Format(@" INSERT INTO [dbo].[inf29a] ( [inf29a00_inf29id] ,[inf29a01_docno] ,[inf29a02_seq] ,adduser ,adddate ,{0} ) OUTPUT INSERTED.ID VALUES ( @inf29a00_inf29id ,@inf29a01_docno ,@inf29a02_seq ,@adduser ,@adddate ,@{1} ) ", fieldNamesSql, paramsFieldsSql); sqlCmd.Parameters.AddWithValue("@inf29a00_inf29id", inf29.id); sqlCmd.Parameters.AddWithValue("@inf29a01_docno", inf29.inf2901_docno); sqlCmd.Parameters.AddWithValue("@inf29a02_seq", inf29a02_seq); sqlCmd.Parameters.AddWithValueSafe("@adduser", inf29aRow.adddate); sqlCmd.Parameters.AddWithValue("@adddate", inf29aRow.adddate); foreach (var field in fields) { sqlCmd.Parameters.AddWithValueSafe("@" + field, inf29aRow[field]); } int id = (int)sqlCmd.ExecuteScalar(); return(id); } }
public static List <Inf29a> AddItem(Inf29 inf29, List <Inf29a> inf29aList) { if (inf29aList == null || inf29aList.Count == 0) { throw new ArgumentNullException("inf29aList"); } try { using (var conn = new SqlConnection { ConnectionString = MyConnStringList.AzureGoodeasy }) using (var sqlCmd = conn.CreateCommand()) { conn.Open(); sqlCmd.CommandText = @" INSERT INTO [dbo].[inf29a] ( [inf29a00_inf29id] ,[inf29a01_docno] ,[inf29a02_seq] ,[inf29a05_pcode] ,[inf29a05_shoes_code] ,[inf29a33_product_name] ,[inf29a17_runit] ,[inf29a10_cost_one0] ,[inf29a10_ocost_one] ,[inf29a40_tax] ,[inf29a13_sold_qty] ,[inf29a24_retrn_qty] ,[inf29a16_gift_qty] ,[inf29a26_box_qty] ,[inf29a10_cost_one] ,[inf29a06_qty] ,[inf29a38_one_amt] ,[remark] ,[adduser] ,[adddate]) OUTPUT INSERTED.ID VALUES ( @inf29a00_inf29id ,@inf29a01_docno ,@inf29a02_seq ,@inf29a05_pcode ,@inf29a05_shoes_code ,@inf29a33_product_name ,@inf29a17_runit ,@inf29a10_cost_one0 ,@inf29a10_ocost_one ,@inf29a40_tax ,@inf29a13_sold_qty ,@inf29a24_retrn_qty ,@inf29a16_gift_qty ,@inf29a26_box_qty ,@inf29a10_cost_one ,@inf29a06_qty ,@inf29a38_one_amt ,@remark ,@adduser ,@adddate ) "; foreach (var inf29a in inf29aList) { sqlCmd.Parameters.Clear(); sqlCmd.Parameters.AddWithValue("@inf29a00_inf29id", inf29.id); sqlCmd.Parameters.AddWithValue("@inf29a01_docno", inf29.inf2901_docno); sqlCmd.Parameters.AddWithValue("@inf29a02_seq", inf29a.inf29a02_seq); sqlCmd.Parameters.AddWithValueSafe("@inf29a05_pcode", inf29a.inf29a05_pcode); sqlCmd.Parameters.AddWithValueSafe("@inf29a05_shoes_code", inf29a.inf29a05_shoes_code); sqlCmd.Parameters.AddWithValueSafe("@inf29a33_product_name", inf29a.inf29a33_product_name); sqlCmd.Parameters.AddWithValueSafe("@inf29a17_runit", inf29a.inf29a17_runit); sqlCmd.Parameters.AddWithValueSafe("@inf29a10_cost_one0", inf29a.inf29a10_cost_one0); sqlCmd.Parameters.AddWithValueSafe("@inf29a10_ocost_one", inf29a.inf29a10_ocost_one); sqlCmd.Parameters.AddWithValueSafe("@inf29a40_tax", inf29a.inf29a40_tax); sqlCmd.Parameters.AddWithValueSafe("@inf29a13_sold_qty", inf29a.inf29a13_sold_qty); sqlCmd.Parameters.AddWithValueSafe("@inf29a24_retrn_qty", inf29a.inf29a24_retrn_qty); sqlCmd.Parameters.AddWithValueSafe("@inf29a16_gift_qty", inf29a.inf29a16_gift_qty); sqlCmd.Parameters.AddWithValueSafe("@inf29a26_box_qty", inf29a.inf29a26_box_qty); sqlCmd.Parameters.AddWithValueSafe("@inf29a10_cost_one", inf29a.inf29a10_cost_one);//大單位換算值 sqlCmd.Parameters.AddWithValueSafe("@inf29a06_qty", inf29a.inf29a06_qty); sqlCmd.Parameters.AddWithValueSafe("@inf29a38_one_amt", inf29a.inf29a38_one_amt); sqlCmd.Parameters.AddWithValueSafe("@remark", inf29a.remark); sqlCmd.Parameters.AddWithValue("@adduser", inf29a.adduser ?? ""); sqlCmd.Parameters.AddWithValue("@adddate", inf29a.adddate); int id = (int)sqlCmd.ExecuteScalar(); inf29a.id = id; } } } catch (Exception ex) { } return(inf29aList); }
public static List <Inf29a> AddItem(Inf29 inf29, List <Inf29a> inf29aList) { if (inf29aList == null || inf29aList.Count == 0) { throw new ArgumentNullException("inf29aList"); } using (var conn = new SqlConnection { ConnectionString = MyConnStringList.AzureGoodeasy }) using (var sqlCmd = conn.CreateCommand()) { conn.Open(); sqlCmd.CommandText = @" INSERT INTO [dbo].[inf29a] ( [inf29a00_inf29id] ,[inf29a01_docno] ,[inf29a02_seq] ,[inf29a04_sizeno] ,[inf29a05_pcode] ,[inf29a05_shoes_code] ,[inf29a09_retail_one] ,[inf29a09_oretail_one] ,[inf29a10_ocost_one] ,[inf29a10_cost_one] ,[inf29a11_dis_rate] ,[inf29a12_sub_amt] ,[inf29a13_sold_qty] ,[inf29a14_trn_type] ,[inf29a17_runit] ,[inf29a26_box_qty] ,[inf29a33_product_name] ,[inf29a36_odds_amt] ,[inf29a38_one_amt] ,[inf29a39_price] ,[inf29a40_tax] ,[inf29a41_pcat] ,[adduser] ,[adddate]) OUTPUT INSERTED.ID VALUES ( @inf29a00_inf29id ,@inf29a01_docno ,@inf29a02_seq ,@inf29a04_sizeno ,@inf29a05_pcode ,@inf29a05_shoes_code ,@inf29a09_oretail_one ,@inf29a09_retail_one ,@inf29a10_ocost_one ,@inf29a10_cost_one ,@inf29a11_dis_rate ,@inf29a12_sub_amt ,@inf29a13_sold_qty ,@inf29a14_trn_type ,@inf29a17_runit ,@inf29a26_box_qty ,@inf29a33_product_name ,@inf29a36_odds_amt ,@inf29a38_one_amt ,@inf29a39_price ,@inf29a40_tax ,@inf29a41_pcat ,@adduser ,@adddate ) "; foreach (var inf29a in inf29aList) { sqlCmd.Parameters.Clear(); sqlCmd.Parameters.AddWithValue("@inf29a00_inf29id", inf29.id); sqlCmd.Parameters.AddWithValue("@inf29a01_docno", inf29.inf2901_docno); sqlCmd.Parameters.AddWithValue("@inf29a02_seq", inf29a.inf29a02_seq); sqlCmd.Parameters.AddWithValueSafe("@inf29a04_sizeno", inf29a.inf29a04_sizeno); sqlCmd.Parameters.AddWithValueSafe("@inf29a05_pcode", inf29a.inf29a05_pcode); sqlCmd.Parameters.AddWithValueSafe("@inf29a05_shoes_code", inf29a.inf29a05_shoes_code); sqlCmd.Parameters.AddWithValueSafe("@inf29a09_retail_one", inf29a.inf29a09_retail_one); sqlCmd.Parameters.AddWithValueSafe("@inf29a09_oretail_one", inf29a.inf29a09_oretail_one); sqlCmd.Parameters.AddWithValueSafe("@inf29a10_ocost_one", inf29a.inf29a10_ocost_one); sqlCmd.Parameters.AddWithValueSafe("@inf29a10_cost_one", inf29a.inf29a10_cost_one); sqlCmd.Parameters.AddWithValueSafe("@inf29a11_dis_rate", inf29a.inf29a11_dis_rate); sqlCmd.Parameters.AddWithValueSafe("@inf29a12_sub_amt", inf29a.inf29a12_sub_amt); sqlCmd.Parameters.AddWithValueSafe("@inf29a13_sold_qty", inf29a.inf29a13_sold_qty); sqlCmd.Parameters.AddWithValueSafe("@inf29a14_trn_type", inf29a.inf29a14_trn_type); sqlCmd.Parameters.AddWithValueSafe("@inf29a17_runit", inf29a.inf29a17_runit); sqlCmd.Parameters.AddWithValueSafe("@inf29a26_box_qty", inf29a.inf29a26_box_qty); // sqlCmd.Parameters.AddWithValueSafe("@inf29a31_currency", inf29a.inf29a31_currency); // sqlCmd.Parameters.AddWithValueSafe("@inf29a32_exchange_rate", inf29a.inf29a32_exchange_rate); sqlCmd.Parameters.AddWithValueSafe("@inf29a33_product_name", inf29a.inf29a33_product_name); sqlCmd.Parameters.AddWithValueSafe("@inf29a36_odds_amt", inf29a.inf29a36_odds_amt); sqlCmd.Parameters.AddWithValueSafe("@inf29a38_one_amt", inf29a.inf29a38_one_amt); sqlCmd.Parameters.AddWithValueSafe("@inf29a39_price", inf29a.inf29a39_price); sqlCmd.Parameters.AddWithValueSafe("@inf29a40_tax", inf29a.inf29a40_tax); sqlCmd.Parameters.AddWithValueSafe("@inf29a41_pcat", inf29a.inf29a41_pcat); sqlCmd.Parameters.AddWithValue("@adduser", inf29a.adduser); sqlCmd.Parameters.AddWithValue("@adddate", inf29a.adddate); int id = (int)sqlCmd.ExecuteScalar(); inf29a.id = id; } } return(inf29aList); }