public string DBData_IU(HikiateHenkouShoukaiEntity entity, string xml_detail, SqlCommand sqlCommand)
{
sqlCommand.CommandText = "sp_HikiateHenkoShoukai_DataIU";
sqlCommand.Parameters.Clear();
var parameters = new SqlParameter[3];
parameters[0] = new SqlParameter("@Operator", SqlDbType.VarChar)
{
Value = entity.InsertOperator
};
parameters[1] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = entity.PC
};
parameters[2] = new SqlParameter("@xml", SqlDbType.Xml)
{
Value = xml_detail
};
if (parameters != null)
{
parameters = ChangeToDBNull(parameters);
}
sqlCommand.Parameters.AddRange(parameters);
sqlCommand.ExecuteNonQuery();
return("true");
}
public DataTable D_Exclusive_Lock_Check(HikiateHenkouShoukaiEntity se)
{
CKMDL ckmdl = new CKMDL();
var parameters = new SqlParameter[5];
parameters[0] = new SqlParameter("@DataKBN", SqlDbType.Int)
{
Value = se.DataKBN
};
parameters[1] = new SqlParameter("@Number", SqlDbType.VarChar)
{
Value = se.Number
};
parameters[2] = new SqlParameter("@OperatorCD", SqlDbType.VarChar)
{
Value = se.OperatorCD
};
parameters[3] = new SqlParameter("@Program", SqlDbType.VarChar)
{
Value = se.ProgramID
};
parameters[4] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = se.PC
};
DataTable dt = ckmdl.SelectDatatable("D_Exclusive_Lock_Check", GetConnectionString(), parameters);
return(dt);
}
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);
}
}
}
private HikiateHenkouShoukaiEntity GetRequired_UIData()
{
HikiateHenkouShoukaiEntity entity = new HikiateHenkouShoukaiEntity();
entity.SerialKBN = 99;
entity.SlipNO = string.Empty;
entity.ProcessKBN = 10;
entity.InsertOperator = base_entity.OperatorCD;
entity.PC = base_entity.PC;
entity.ProgramID = base_entity.ProgramID;
entity.Mode = string.Empty;
entity.KeyItem = string.Empty;
return(entity);
}
private void D_Exclusive_OneNumber_Insert(DataRow dr)
{
if (!string.IsNullOrWhiteSpace(dr["受注番号"].ToString()))
{
string JuchuuNO = dr["受注番号"].ToString();
DataRow[] selectRow = F8_dt1.Select("受注番号 ='" + JuchuuNO + "'");
if (selectRow.Length == 0)
{
return;
}
HikiateHenkouShoukaiEntity chkLockEntity = new HikiateHenkouShoukaiEntity();
chkLockEntity.DataKBN = 1;
chkLockEntity.Number = JuchuuNO;
chkLockEntity.ProgramID = ProgramID;
chkLockEntity.PC = PCID;
chkLockEntity.OperatorCD = OperatorCD;
hbl.D_Exclusive_Lock_Check(chkLockEntity);
}
}
//For ZaikoIkkatuSaiHikiate Prj
public void IData_DB(HikiateHenkouShoukaiEntity entity)
{
CKMDL ckmdl = new CKMDL();
ckmdl.UseTran = true;
entity.Sqlprms = new SqlParameter[8];
entity.Sqlprms[0] = new SqlParameter("@SerialKBN", SqlDbType.Int)
{
Value = entity.SerialKBN
};
entity.Sqlprms[1] = new SqlParameter("@SlipNo", SqlDbType.VarChar)
{
Value = entity.SlipNO
};
entity.Sqlprms[2] = new SqlParameter("@ProcessKBN", SqlDbType.Int)
{
Value = entity.ProcessKBN
};
entity.Sqlprms[3] = new SqlParameter("@OperatorCD", SqlDbType.VarChar)
{
Value = entity.InsertOperator
};
entity.Sqlprms[4] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = entity.PC
};
entity.Sqlprms[5] = new SqlParameter("@Program", SqlDbType.VarChar)
{
Value = entity.ProgramID
};
entity.Sqlprms[6] = new SqlParameter("@Mode", SqlDbType.VarChar)
{
Value = entity.Mode
};
entity.Sqlprms[7] = new SqlParameter("@KeyItem", SqlDbType.VarChar)
{
Value = entity.KeyItem
};
ckmdl.InsertUpdateDeleteData("sp_ZaikoIkkatuSaiHikiate_Process", GetConnectionString(), entity.Sqlprms);
}
public DataTable Select_DisplayData(HikiateHenkouShoukaiEntity h_entity)
{
CKMDL ckmdl = new CKMDL();
h_entity.Sqlprms = new SqlParameter[27];
h_entity.Sqlprms[0] = new SqlParameter("@Representation", SqlDbType.Int)
{
Value = h_entity.Representation
};
h_entity.Sqlprms[1] = new SqlParameter("@BrandCD", SqlDbType.VarChar)
{
Value = h_entity.BrandCD
};
h_entity.Sqlprms[2] = new SqlParameter("@ChakuniYoteiNO", SqlDbType.VarChar)
{
Value = h_entity.ChakuniYoteiNO
};
h_entity.Sqlprms[3] = new SqlParameter("@KanriNO", SqlDbType.VarChar)
{
Value = h_entity.KanriNO
};
h_entity.Sqlprms[4] = new SqlParameter("@YearTerm", SqlDbType.VarChar)
{
Value = h_entity.YearTerm
};
h_entity.Sqlprms[5] = new SqlParameter("@SeasonSS", SqlDbType.Int)
{
Value = h_entity.SeasonSS
};
h_entity.Sqlprms[6] = new SqlParameter("@SeasonFW", SqlDbType.Int)
{
Value = h_entity.SeasonFW
};
h_entity.Sqlprms[7] = new SqlParameter("@TokuisakiCD", SqlDbType.VarChar)
{
Value = h_entity.TokuisakiCD
};
h_entity.Sqlprms[8] = new SqlParameter("@SoukoCD", SqlDbType.VarChar)
{
Value = h_entity.SoukoCD
};
h_entity.Sqlprms[9] = new SqlParameter("@KouritenCD", SqlDbType.VarChar)
{
Value = h_entity.KouritenCD
};
h_entity.Sqlprms[10] = new SqlParameter("@PostalCode1", SqlDbType.VarChar)
{
Value = h_entity.PostalCode1
};
h_entity.Sqlprms[11] = new SqlParameter("@PostalCode2", SqlDbType.VarChar)
{
Value = h_entity.PostalCode2
};
h_entity.Sqlprms[12] = new SqlParameter("@Phoneno1", SqlDbType.VarChar)
{
Value = h_entity.Phoneno1
};
h_entity.Sqlprms[13] = new SqlParameter("@Phoneno2", SqlDbType.VarChar)
{
Value = h_entity.Phoneno2
};
h_entity.Sqlprms[14] = new SqlParameter("@Phoneno3", SqlDbType.VarChar)
{
Value = h_entity.Phoneno3
};
h_entity.Sqlprms[15] = new SqlParameter("@Name", SqlDbType.VarChar)
{
Value = h_entity.Name
};
h_entity.Sqlprms[16] = new SqlParameter("@Address", SqlDbType.VarChar)
{
Value = h_entity.Address
};
h_entity.Sqlprms[17] = new SqlParameter("@ShouhinCD", SqlDbType.VarChar)
{
Value = h_entity.ShouhinCD
};
h_entity.Sqlprms[18] = new SqlParameter("@JANCD", SqlDbType.VarChar)
{
Value = h_entity.JANCD
};
h_entity.Sqlprms[19] = new SqlParameter("@ColorNO", SqlDbType.VarChar)
{
Value = h_entity.ColorNO
};
h_entity.Sqlprms[20] = new SqlParameter("@SizeNO", SqlDbType.VarChar)
{
Value = h_entity.SizeNO
};
h_entity.Sqlprms[21] = new SqlParameter("@ShouhinName", SqlDbType.VarChar)
{
Value = h_entity.ShouhinName
};
h_entity.Sqlprms[22] = new SqlParameter("@Type1", SqlDbType.Int)
{
Value = h_entity.Type1
};
h_entity.Sqlprms[23] = new SqlParameter("@Type2", SqlDbType.Int)
{
Value = h_entity.Type2
};
h_entity.Sqlprms[24] = new SqlParameter("@Operator", SqlDbType.VarChar)
{
Value = h_entity.OperatorCD
};
h_entity.Sqlprms[25] = new SqlParameter("@PC", SqlDbType.VarChar)
{
Value = h_entity.PC
};
h_entity.Sqlprms[26] = new SqlParameter("@Program", SqlDbType.VarChar)
{
Value = h_entity.ProgramID
};
return(ckmdl.SelectDatatable("sp_HikiateHenkouShoukaiBL_GetData", GetConnectionString(), h_entity.Sqlprms));
}
public void DBData_IU(HikiateHenkouShoukaiEntity entity)
{
CKMDL ckmdl = new CKMDL();
ckmdl.UseTran = true;
entity.Sqlprms = new SqlParameter[20];
entity.Sqlprms[0] = new SqlParameter("@ShouhinCD", SqlDbType.VarChar)
{
Value = entity.ShouhinCD
};
entity.Sqlprms[1] = new SqlParameter("@ShouhinName", SqlDbType.VarChar)
{
Value = entity.ShouhinName
};
entity.Sqlprms[2] = new SqlParameter("@ColorNO", SqlDbType.VarChar)
{
Value = entity.ColorNO
};
entity.Sqlprms[3] = new SqlParameter("@SizeNO", SqlDbType.VarChar)
{
Value = entity.SizeNO
};
entity.Sqlprms[4] = new SqlParameter("@JuchuuSuu", SqlDbType.VarChar)
{
Value = entity.JuchuuSuu
};
entity.Sqlprms[5] = new SqlParameter("@ChakuniYoteiSuu", SqlDbType.VarChar)
{
Value = entity.ChakuniYoteiSuu
};
entity.Sqlprms[6] = new SqlParameter("@MiHikiateSuu", SqlDbType.VarChar)
{
Value = entity.MiHikiateSuu
};
entity.Sqlprms[7] = new SqlParameter("@HikiateZumiSuu", SqlDbType.VarChar)
{
Value = entity.HikiateZumiSuu
};
entity.Sqlprms[8] = new SqlParameter("@ChakuniSuu", SqlDbType.VarChar)
{
Value = entity.ChakuniSuu
};
entity.Sqlprms[9] = new SqlParameter("@ShukkaSiziSuu", SqlDbType.VarChar)
{
Value = entity.ShukkaSiziSuu
};
entity.Sqlprms[10] = new SqlParameter("@ShukkaSuu", SqlDbType.VarChar)
{
Value = entity.ShukkaSuu
};
entity.Sqlprms[11] = new SqlParameter("@HikiateSuu", SqlDbType.VarChar)
{
Value = entity.HikiateSuu
};
entity.Sqlprms[12] = new SqlParameter("@JuchuuNO_JuchuuGyouNO", SqlDbType.VarChar)
{
Value = entity.JuchuuNO_JuchuuGyouNO
};
entity.Sqlprms[13] = new SqlParameter("@TokuisakiRyakuName", SqlDbType.VarChar)
{
Value = entity.TokuisakiRyakuName
};
entity.Sqlprms[14] = new SqlParameter("@KouritenRyakuName", SqlDbType.VarChar)
{
Value = entity.KouritenRyakuName
};
entity.Sqlprms[15] = new SqlParameter("@NyuukoDate", SqlDbType.VarChar)
{
Value = entity.NyuukoDate
};
entity.Sqlprms[16] = new SqlParameter("@JuchuuDate", SqlDbType.VarChar)
{
Value = entity.JuchuuDate
};
entity.Sqlprms[17] = new SqlParameter("@KibouNouki", SqlDbType.VarChar)
{
Value = entity.KibouNouki
};
entity.Sqlprms[18] = new SqlParameter("@JANCD", SqlDbType.VarChar)
{
Value = entity.JANCD
};
entity.Sqlprms[19] = new SqlParameter("@SoukoCD", SqlDbType.VarChar)
{
Value = entity.SoukoCD
};
ckmdl.InsertUpdateDeleteData("sp_HikiateHenkoShoukai_DataIU", GetConnectionString(), entity.Sqlprms);
}
private void Display_Data()
{
D_Exclusive_JuchuuNO_Delete();
HikiateHenkouShoukaiEntity entity = new HikiateHenkouShoukaiEntity();
if (rdoAggregation.Checked)
{
entity.Representation = 0;
}
else if (rdoDetails.Checked)
{
entity.Representation = 1;
}
else
{
entity.Representation = 2;
}
entity.BrandCD = txtBrand.Text;
entity.ChakuniYoteiNO = txtChakuniYoteiNO.Text;
entity.KanriNO = txtKanriNO.Text;
entity.YearTerm = txtYearTerm.Text;
entity.SeasonSS = chkSeasonSS.Checked ? 1 : 0;
entity.SeasonFW = chkSeasonFW.Checked ? 1 : 0;
entity.TokuisakiCD = txtTokuisakiCD.Text;
entity.SoukoCD = txtSoukoCD.Text;
entity.KouritenCD = txtKouritenCD.Text;
entity.PostalCode1 = txtPostalCode1.Text;
entity.PostalCode2 = txtPostalCode2.Text;
entity.Phoneno1 = txtPhoneNo1.Text;
entity.Phoneno2 = txtPhoneNo2.Text;
entity.Phoneno3 = txtPhoneNo3.Text;
entity.Name = txtName.Text;
entity.Address = txtAddress.Text;
entity.ShouhinCD = txtShouhinCD.Text;
entity.JANCD = txtJANCD.Text;
entity.ColorNO = txtColorNO.Text;
entity.SizeNO = txtSizeNO.Text;
entity.ShouhinName = txtShouhinName.Text;
entity.Type1 = chkType1.Checked ? 1 : 0;
entity.Type2 = chkType2.Checked ? 1 : 0;
entity.OperatorCD = base_entity.OperatorCD;
entity.PC = base_entity.PC;
entity.ProgramID = base_entity.ProgramID;
dtMain = hbl.Select_DisplayData(entity);
if (rdoAggregation.Checked)
{
gvAggregationDetails.DataSource = dtMain;
gvAggregationDetails.Focus();
if (dtMain.Rows.Count > 0)
{
gvAggregationDetails.CurrentCell = gvAggregationDetails.Rows[0].Cells[3];
gvAggregationDetails.Select();
gvAggregationDetails.Memory_Row_Count = dtMain.Rows.Count;
gvFreeInventoryDetails.Memory_Row_Count = dtMain.Rows.Count;
gvMainDetail.Memory_Row_Count = dtMain.Rows.Count;
}
}
else if (rdoDetails.Checked)
{
foreach (DataRow dr in dtMain.Rows)
{
bool exists = false;
if (F8_dt1.Rows.Count > 0)
{
//重複行はDelete
string ShouhinCD = dr["ShouhinCD"].ToString();
string JuchuuNo = dr["受注番号-行番号"].ToString();
string KanriNO = dr["小売店名"].ToString();
DataRow existDr1 = F8_dt1.Select("([受注番号-行番号] ='" + JuchuuNo + "' OR [受注番号-行番号] IS NULL) AND 小売店名 = '" + KanriNO + "' AND ShouhinCD = '" + ShouhinCD + "'").SingleOrDefault();
if (existDr1 != null)
{
dr["表示順"] = "9";
exists = true;
}
}
if (!string.IsNullOrWhiteSpace(dr["受注番号"].ToString()) && !exists)
{
string JuchuuNO = dr["受注番号"].ToString();
entity.DataKBN = 1;
entity.Number = JuchuuNO;
entity.ProgramID = ProgramID;
entity.PC = PCID;
entity.OperatorCD = OperatorCD;
DataTable dt = new DataTable();
dt = hbl.D_Exclusive_Lock_Check(entity);
if (dt.Rows[0]["MessageID"].ToString().Equals("S004"))
{
string Data1 = string.Empty, Data2 = string.Empty, Data3 = string.Empty;
Data1 = dt.Rows[0]["Program"].ToString();
Data2 = dt.Rows[0]["Operator"].ToString();
Data3 = dt.Rows[0]["PC"].ToString();
D_Exclusive_JuchuuNO_Delete();
bbl.ShowMessage("S004", Data1, Data2, Data3);
return;
}
}
}
DataRow[] select_dr1 = dtMain.Select("表示順 = '9'");
foreach (DataRow dr in select_dr1)
{
dtMain.Rows.Remove(dr);
}
//dtMain.Columns.RemoveAt(20);
//dtMain.Columns.RemoveAt(19);
gvMainDetail.DataSource = dtMain;
gvMainDetail.Columns[19].Visible = false;
gvMainDetail.Columns[20].Visible = false;
gvMainDetail.Columns[21].Visible = false;
gvMainDetail.Focus();
if (dtMain.Rows.Count > 0)
{
gvMainDetail.CurrentCell = gvMainDetail.Rows[0].Cells[11];
gvMainDetail.Select();
}
//gvMainDetail.Columns[gvMainDetail.Columns.Count - 1].Visible = false;
}
else
{
gvFreeInventoryDetails.DataSource = dtMain;
gvFreeInventoryDetails.Focus();
if (dtMain.Rows.Count > 0)
{
gvFreeInventoryDetails.CurrentCell = gvFreeInventoryDetails.Rows[0].Cells[0];
gvFreeInventoryDetails.Select();
gvFreeInventoryDetails.Memory_Row_Count = dtMain.Rows.Count;
gvMainDetail.Memory_Row_Count = dtMain.Rows.Count;
gvAggregationDetails.Memory_Row_Count = dtMain.Rows.Count;
}
}
if (dtTemp != null)
{
dtTemp.Clear();
}
}
