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