public DataTable IdouNyuuryoku_Display(IdouNyuuryokuEntity obj) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[11]; parameters[0] = new SqlParameter("@BrandCD", SqlDbType.VarChar) { Value = obj.BrandCD }; parameters[1] = new SqlParameter("@ShouhinCD", SqlDbType.VarChar) { Value = obj.ShouhinCD }; parameters[2] = new SqlParameter("@ShouhinName", SqlDbType.VarChar) { Value = obj.ShouhinName }; parameters[3] = new SqlParameter("@JANCD", SqlDbType.VarChar) { Value = obj.JANCD }; parameters[4] = new SqlParameter("@YearTerm", SqlDbType.VarChar) { Value = obj.YearTerm }; parameters[5] = new SqlParameter("@SeasonSS", SqlDbType.VarChar) { Value = obj.SeasonSS }; parameters[6] = new SqlParameter("@SeasonFW", SqlDbType.VarChar) { Value = obj.SeasonFW }; parameters[7] = new SqlParameter("@ColorNo", SqlDbType.VarChar) { Value = obj.ColorNO }; parameters[8] = new SqlParameter("@SizeNo", SqlDbType.VarChar) { Value = obj.SizeNO }; parameters[9] = new SqlParameter("@ChangeDate", SqlDbType.VarChar) { Value = obj.ChangeDate }; parameters[10] = new SqlParameter("@SoukoCD", SqlDbType.VarChar) { Value = obj.SoukoCD }; DataTable dt = ckmdl.SelectDatatable("IdouNyuuryoku_Display", GetConnectionString(), parameters); return(dt); }
public DataTable IdouNyuuryo_Search(IdouNyuuryokuEntity obj) { CKMDL ckmdl = new CKMDL(); var parameters = new SqlParameter[10]; parameters[0] = new SqlParameter("@Date1", SqlDbType.VarChar) { Value = obj.Date1 }; parameters[1] = new SqlParameter("@Date2", SqlDbType.VarChar) { Value = obj.Date2 }; parameters[2] = new SqlParameter("@ShukkoSoukoCD", SqlDbType.VarChar) { Value = obj.ShukkoSoukoCD }; parameters[3] = new SqlParameter("@NyuukoSoukoCD", SqlDbType.VarChar) { Value = obj.NyuukoSoukoCD }; parameters[4] = new SqlParameter("@ShouhinName", SqlDbType.VarChar) { Value = obj.ShouhinName }; parameters[5] = new SqlParameter("@IdouNO1", SqlDbType.VarChar) { Value = obj.IdouNO1 }; parameters[6] = new SqlParameter("@IdouNO2", SqlDbType.VarChar) { Value = obj.IdouNO2 }; parameters[7] = new SqlParameter("@StaffCD", SqlDbType.VarChar) { Value = obj.StaffCD }; parameters[8] = new SqlParameter("@ShouhinCD1", SqlDbType.VarChar) { Value = obj.ShouhinCD1 }; parameters[9] = new SqlParameter("@ShouhinCD2", SqlDbType.VarChar) { Value = obj.ShouhinCD2 }; DataTable dt = ckmdl.SelectDatatable("IdouNyuuryo_Search", GetConnectionString(), parameters); return(dt); }
private void DataGridviewBind() { IdouNyuuryokuEntity obj = new IdouNyuuryokuEntity(); if (cf.DateCheck(txtDate1)) //Task no. 147 - tza { obj.Date1 = txtDate1.Text; } if (cf.DateCheck(txtDate2)) //Task no. 147 - tza { obj.Date2 = txtDate2.Text; } obj.ShukkoSoukoCD = txtShukkosouko.Text; obj.NyuukoSoukoCD = txtNyukosouko.Text; obj.ShouhinName = txtShouhinName.Text; obj.IdouNO1 = txtNo11.Text; obj.IdouNO2 = txtNo12.Text; obj.StaffCD = txtStaffCD.Text; obj.ShouhinCD1 = txtShouhin1.Text; obj.ShouhinCD2 = txtShouhin2.Text; if (ErrorCheck(panel1)) //Task no. 147 - tza { IdouNyuuryokuBL objMethod = new IdouNyuuryokuBL(); DataTable dt = objMethod.IdouNyuuryo_Search(obj); if (dt.Columns.Contains("CurrentDate")) { if (dt.Rows.Count > 0) { lbl_Date.Text = String.Format("{0:yyyy/MM/dd}", dt.Rows[0]["CurrentDate"]); txtCurrentDate.Text = String.Format("{0:yyyy/MM/dd}", dt.Rows[0]["CurrentDate"]); } else { ClearSession(); } } gv_Idou.DataSource = dt; } }
private void F10_Gridview_Bind() { gv_1.ActionType = "F10"; if (ErrorCheck(PanelDetail)) { IdouNyuuryokuEntity obj = new IdouNyuuryokuEntity(); obj.BrandCD = txtBrandCD.Text; obj.ShouhinCD = txtShouhinCD.Text; obj.JANCD = txtJANCD.Text; obj.ShouhinName = txtShouhinName.Text; obj.YearTerm = txtYearTerm.Text; obj.SeasonSS = chk_SS.Checked ? "1" : "0"; obj.SeasonFW = chk_FW.Checked ? "1" : "0"; obj.ColorNO = txtColorNo.Text; obj.SizeNO = txtSizeNo.Text; if (string.IsNullOrEmpty(obj.BrandCD) && string.IsNullOrEmpty(obj.ShouhinCD) && string.IsNullOrEmpty(obj.JANCD) && string.IsNullOrEmpty(obj.ShouhinName) && string.IsNullOrEmpty(obj.YearTerm) && obj.SeasonSS == "0" && obj.SeasonFW == "0" && string.IsNullOrEmpty(obj.SizeNO) && string.IsNullOrEmpty(obj.ColorNO)) { base_bl.ShowMessage("E111"); txtBrandCD.Focus(); return; } obj.ChangeDate = txtIdouDate.Text; if (txtIdoukubun.Text == "1") { obj.SoukoCD = txtNyukosouko.Text; } else { obj.SoukoCD = txtShukkosouko.Text; } DataTable dt = Idou_BL.IdouNyuuryoku_Display(obj); if (dt.Rows.Count > 0) { if (F8_dt1.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { //重複行はDelete string ShouhinCD = dr["ShouhinCD"].ToString(); DataRow existDr1 = F8_dt1.Select("ShouhinCD ='" + ShouhinCD + "'").SingleOrDefault(); if (existDr1 != null) { dr["IdouGyouNO"] = "99"; //未使用項目のため } } } DataRow[] select_dr1 = dt.Select("IdouGyouNO = '99'"); foreach (DataRow dr in select_dr1) { dt.Rows.Remove(dr); } gv_1.DataSource = dt; gv_1.Focus(); DataTable dt_temp = dt.Copy(); gv1_to_dt1 = dt_temp; if (F8_dt1.Rows.Count == 0) { F8_dt1 = gv1_to_dt1.Clone(); } gv_1.Select(); if (dt.Rows.Count > 0) { gv_1.CurrentCell = gv_1.Rows[0].Cells["colKanriNO"]; } } else { //F8_dt1.Rows.Clear(); //gv_1.DataSource = F8_dt1; gv_1.DataSource = dt; Focus_Clear(); } } gv_1.ActionType = string.Empty; }