private void DBData_IU()
{
using (SqlConnection sqlConnection = new SqlConnection(hbl.GetCon()))
{
sqlConnection.Open();
SqlCommand sqlCommand = sqlConnection.CreateCommand();
SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
sqlCommand.Connection = sqlConnection;
sqlCommand.Transaction = sqlTransaction;
sqlCommand.CommandType = CommandType.StoredProcedure;
try
{
string Xml = string.Empty;
Xml = cf.DataTableToXml(F8_dt1);
//for (int i = 0; i < F8_dt1.Rows.Count; i++)
//{
HikiateHenkouShoukaiEntity entity = new HikiateHenkouShoukaiEntity();
entity.InsertOperator = OperatorCD;
entity.PC = PCID;
// entity.ShouhinCD = F8_dt1.Rows[i]["商品"].ToString();
// entity.ShouhinName = F8_dt1.Rows[i]["商品名"].ToString();
// entity.ColorNO = F8_dt1.Rows[i]["カラー"].ToString();
// entity.SizeNO = F8_dt1.Rows[i]["サイズ"].ToString();
// entity.JuchuuSuu = F8_dt1.Rows[i]["受注数"].ToString();
// entity.ChakuniYoteiSuu = F8_dt1.Rows[i]["着荷予定数"].ToString();
// entity.MiHikiateSuu = F8_dt1.Rows[i]["未引当数"].ToString();
// entity.HikiateZumiSuu = F8_dt1.Rows[i]["引当済数"].ToString();
// entity.ChakuniSuu = F8_dt1.Rows[i]["着荷済数"].ToString();
// entity.ShukkaSiziSuu = F8_dt1.Rows[i]["出荷指示数"].ToString();
// entity.ShukkaSuu = F8_dt1.Rows[i]["出荷済数"].ToString();
// entity.HikiateSuu = F8_dt1.Rows[i]["引当調整数"].ToString();
// entity.JuchuuNO_JuchuuGyouNO = F8_dt1.Rows[i]["受注番号-行番号"].ToString();
// entity.TokuisakiRyakuName = F8_dt1.Rows[i]["得意先名"].ToString();
// entity.KouritenRyakuName = F8_dt1.Rows[i]["小売店名"].ToString();
// entity.NyuukoDate = F8_dt1.Rows[i]["入庫日"].ToString();
// entity.JuchuuDate = F8_dt1.Rows[i]["受注日"].ToString();
// entity.KibouNouki = F8_dt1.Rows[i]["希望納期"].ToString();
// entity.JANCD = F8_dt1.Rows[i]["JANCD"].ToString();
// entity.SoukoCD = F8_dt1.Rows[i]["倉庫"].ToString();
// hbl.DBData_IU(entity);
//}
string return_BL = hbl.DBData_IU(entity, Xml, sqlCommand);
sqlTransaction.Commit();
if (return_BL == "true")
{
bbl.ShowMessage("I101");
}
Modified_Panel(); //Clear Data
}
catch (Exception ex)
{
sqlTransaction.Rollback();
bbl.ShowMessage(ex.Message);
}
}
}
