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