private ShukkaSiziNyuuryokuEntity GetShukkasiziEntity() { SKSZ_Entity = new ShukkaSiziNyuuryokuEntity(); if (cf.DateCheck(txtShippingDateFrom)) //Task no. 147 - tza { SKSZ_Entity.ShukkaYoteiDate_From = txtShippingDateFrom.Text; } if (cf.DateCheck(txtShippingDateTo)) //Task no. 147 - tza { SKSZ_Entity.ShukkaYoteiDate_To = txtShippingDateTo.Text; } SKSZ_Entity.TokuisakiCD = txtTokuisakiCD.Text; SKSZ_Entity.StaffCD = txtStaffCD.Text; SKSZ_Entity.ShouhinName = txtProductName.Text; if (cf.DateCheck(txtSlipDateFrom)) //Task no. 147 - tza { SKSZ_Entity.DenpyouDate_From = txtSlipDateFrom.Text; } if (cf.DateCheck(txtSlipDateTo)) //Task no. 147 - tza { SKSZ_Entity.DenpyouDate_To = txtSlipDateTo.Text; } SKSZ_Entity.ShukkaSiziNO_From = txtShippingNoFrom.Text; SKSZ_Entity.ShukkaSiziNO_To = txtShippingNoTo.Text; SKSZ_Entity.ShouhinCD_From = txtProductFrom.Text; SKSZ_Entity.ShouhinCD_To = txtProductTo.Text; return(SKSZ_Entity); }
private void GridViewBind() { SKSZ_Entity = GetShukkasiziEntity(); SKSZ_BL = new ShukkasiziNyuuryokuBL(); DataTable dt = new DataTable(); if (ErrorCheck(panel1)) //Task no. 147 - tza { dt = SKSZ_BL.ShippingNO_Search(SKSZ_Entity); if (dt.Rows.Count > 0) { if (dt.Columns.Contains("CurrentDay")) { lbl_Date.Text = String.Format("{0:yyyy/MM/dd}", dt.Rows[0]["CurrentDay"]);//ssa txtCurrentDate.Text = String.Format("{0:yyyy/MM/dd}", dt.Rows[0]["CurrentDay"]); } } else { ClearSession(); } dt.Columns.Remove("CurrentDay"); gvShippingNo.DataSource = dt; } }
public DataTable D_Exclusive_Lock_Check(ShukkaSiziNyuuryokuEntity 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); }
public DataTable ShukkasiziNyuuryoku_Data_Select(ShukkaSiziNyuuryokuEntity se, int type) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[5]; //parameters[0] = new SqlParameter("@ShippingDate", SqlDbType.VarChar) { Value = se.ShippingDate }; parameters[0] = new SqlParameter("@ShippingNo", SqlDbType.VarChar) { Value = se.ShippinNo }; parameters[1] = new SqlParameter("@Operator", SqlDbType.VarChar) { Value = se.OperatorCD }; parameters[2] = new SqlParameter("@Program", SqlDbType.VarChar) { Value = se.ProgramID }; parameters[3] = new SqlParameter("@PC", SqlDbType.VarChar) { Value = se.PC }; parameters[4] = new SqlParameter("@Type", SqlDbType.TinyInt) { Value = type }; DataTable dt = ckmdl.SelectDatatable("ShukkasiziNyuuryoku_Data_Select", GetConnectionString(), parameters); return(dt); }
public DataTable ShippingNO_Search(ShukkaSiziNyuuryokuEntity sksze) { CKMDL ckmdl = new CKMDL(); sksze.Sqlprms = new SqlParameter[11]; sksze.Sqlprms[0] = new SqlParameter("@ShukkaYoteiDate_From", SqlDbType.Date) { Value = sksze.ShukkaYoteiDate_From }; sksze.Sqlprms[1] = new SqlParameter("@ShukkaYoteiDate_To", SqlDbType.Date) { Value = sksze.ShukkaYoteiDate_To }; sksze.Sqlprms[2] = new SqlParameter("@TokuisakiCD", SqlDbType.VarChar) { Value = sksze.TokuisakiCD }; sksze.Sqlprms[3] = new SqlParameter("@StaffCD", SqlDbType.VarChar) { Value = sksze.StaffCD }; sksze.Sqlprms[4] = new SqlParameter("@ShouhinName", SqlDbType.VarChar) { Value = sksze.ShouhinName }; sksze.Sqlprms[5] = new SqlParameter("@DenpyouDate_From", SqlDbType.Date) { Value = sksze.DenpyouDate_From }; sksze.Sqlprms[6] = new SqlParameter("@DenpyouDate_To", SqlDbType.Date) { Value = sksze.DenpyouDate_To }; sksze.Sqlprms[7] = new SqlParameter("@ShukkaSiziNO_From", SqlDbType.VarChar) { Value = sksze.ShukkaSiziNO_From }; sksze.Sqlprms[8] = new SqlParameter("@ShukkaSiziNO_To", SqlDbType.VarChar) { Value = sksze.ShukkaSiziNO_To }; sksze.Sqlprms[9] = new SqlParameter("@ShouhinCD_From", SqlDbType.VarChar) { Value = sksze.ShouhinCD_From }; sksze.Sqlprms[10] = new SqlParameter("@ShouhinCD_To", SqlDbType.VarChar) { Value = sksze.ShouhinCD_To }; DataTable dt = ckmdl.SelectDatatable("ShippingNO_Search", GetConnectionString(), sksze.Sqlprms); return(dt); }
public string SKSZ_D_Exclusive_JuchuuNO_Delete(ShukkaSiziNyuuryokuEntity se) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[4]; parameters[0] = new SqlParameter("@DataKBN", SqlDbType.TinyInt) { Value = se.DataKBN }; parameters[1] = new SqlParameter("@OperatorCD", SqlDbType.VarChar) { Value = se.OperatorCD }; parameters[2] = new SqlParameter("@Program", SqlDbType.VarChar) { Value = se.ProgramID }; parameters[3] = new SqlParameter("@PC", SqlDbType.VarChar) { Value = se.PC }; return(ckmdl.InsertUpdateDeleteData("D_Exclusive_Remove_NO", GetConnectionString(), parameters)); }
public DataTable ShukkasiziNyuuryoku_Display(ShukkaSiziNyuuryokuEntity se) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[25]; parameters[0] = new SqlParameter("@ShippingDate", SqlDbType.VarChar) { Value = se.ShippingDate }; parameters[1] = new SqlParameter("@TokuisakiCD", SqlDbType.VarChar) { Value = se.TokuisakiCD }; parameters[2] = new SqlParameter("@JuchuuNO", SqlDbType.VarChar) { Value = se.JuchuuNO }; parameters[3] = new SqlParameter("@SenpouHacchuuNO", SqlDbType.VarChar) { Value = se.SenpyouhachuuNo }; parameters[4] = new SqlParameter("@TokuisakiYuubinNO1", SqlDbType.VarChar) { Value = se.TokuisakiYuubinNO1 }; parameters[5] = new SqlParameter("@TokuisakiYuubinNO2", SqlDbType.VarChar) { Value = se.TokuisakiYuubinNO2 }; parameters[6] = new SqlParameter("@KouritenYuubinNO1", SqlDbType.VarChar) { Value = se.KouritenYuubinNO1 }; parameters[7] = new SqlParameter("@KouritenYuubinNO2", SqlDbType.VarChar) { Value = se.KouritenYuubinNO2 }; parameters[8] = new SqlParameter("@TokuisakiTelNO1_1", SqlDbType.VarChar) { Value = se.TokuisakiTelNO1_1 }; parameters[9] = new SqlParameter("@TokuisakiTelNO1_2", SqlDbType.VarChar) { Value = se.TokuisakiTelNO1_2 }; parameters[10] = new SqlParameter("@TokuisakiTelNO1_3", SqlDbType.VarChar) { Value = se.TokuisakiTelNO1_3 }; parameters[11] = new SqlParameter("@KouritenTelNO1_1", SqlDbType.VarChar) { Value = se.KouritenTelNO1_1 }; parameters[12] = new SqlParameter("@KouritenTelNO1_2", SqlDbType.VarChar) { Value = se.KouritenTelNO1_2 }; parameters[13] = new SqlParameter("@KouritenTelNO1_3", SqlDbType.VarChar) { Value = se.KouritenTelNO1_3 }; parameters[14] = new SqlParameter("@TokuisakiRyakuName", SqlDbType.VarChar) { Value = se.TokuisakiRyakuName }; parameters[15] = new SqlParameter("@KouritenRyakuName", SqlDbType.VarChar) { Value = se.KouritenRyakuName }; parameters[16] = new SqlParameter("@TokuisakiName", SqlDbType.VarChar) { Value = se.TokuisakiName }; parameters[17] = new SqlParameter("@KouritenName", SqlDbType.VarChar) { Value = se.KouritenName }; parameters[18] = new SqlParameter("@TokuisakiJuusho1", SqlDbType.VarChar) { Value = se.TokuisakiJuusho1 }; parameters[19] = new SqlParameter("@TokuisakiJuusho2", SqlDbType.VarChar) { Value = se.TokuisakiJuusho2 }; parameters[20] = new SqlParameter("@KouritenJuusho1", SqlDbType.VarChar) { Value = se.KouritenJuusho1 }; parameters[21] = new SqlParameter("@KouritenJuusho2", SqlDbType.VarChar) { Value = se.KouritenJuusho2 }; parameters[22] = new SqlParameter("@Operator", SqlDbType.VarChar) { Value = se.OperatorCD }; parameters[23] = new SqlParameter("@Program", SqlDbType.VarChar) { Value = se.ProgramID }; parameters[24] = new SqlParameter("@PC", SqlDbType.VarChar) { Value = se.PC }; DataTable dt = ckmdl.SelectDatatable("ShukkasiziNyuuryoku_Display", GetConnectionString(), parameters); return(dt); }