private void F11() { moe = GetSearchInfo(); RadioCheck(); dtMain = mskbl.M_ShiireKakeritsu_Select(moe); if (dtMain.Rows.Count > 0) { for (int i = 0; i < dtMain.Rows.Count; i++) { var Brand = dtMain.Rows[i]["BrandCD"].ToString(); var Sports = dtMain.Rows[i]["SportsCD"].ToString(); var Segment = dtMain.Rows[i]["SegmentCD"].ToString(); var LastYearTerm = dtMain.Rows[i]["LastYearTerm"].ToString(); var LastSeason = dtMain.Rows[i]["LastSeason"].ToString(); if (String.IsNullOrEmpty(Brand) || String.IsNullOrEmpty(Sports) || String.IsNullOrEmpty(Segment) || String.IsNullOrEmpty(LastYearTerm) || String.IsNullOrEmpty(LastSeason)) { string date = dtMain.Rows[i][11].ToString(); DateTime dtime = Convert.ToDateTime(date); txtRevisionDate.Text = dtime.ToShortDateString(); txtRate1.Text = dtMain.Rows[i][12].ToString(); } } dgv_ShiireKakeritsu.DataSource = dtMain; } else { mskbl.ShowMessage("E128"); dgv_ShiireKakeritsu.DataSource = null; scSupplierCD.SetFocus(1); } }
private void BindGrid() { string searchCondition = string.Empty; if (!string.IsNullOrWhiteSpace(scBrandCD1.TxtCode.Text)) { searchCondition = "BrandCD = '" + scBrandCD1.TxtCode.Text + "'"; } if (!string.IsNullOrWhiteSpace(scSportsCD1.TxtCode.Text)) { searchCondition = "SportsCD='" + scSportsCD1.TxtCode.Text + "'"; } if (!string.IsNullOrWhiteSpace(scSegmentCD1.TxtCode.Text)) { searchCondition = "SegmentCD= '" + scSegmentCD1.TxtCode.Text + "'"; } if (!string.IsNullOrWhiteSpace(cbo_Year1.Text)) { searchCondition = "LastYearTerm='" + cbo_Year1.Text + "'"; } if (!string.IsNullOrWhiteSpace(cbo_Season1.Text)) { searchCondition = "LastSeason= '" + cbo_Season1.Text + "'"; } if (!string.IsNullOrWhiteSpace(txtDate.Text)) { searchCondition = "ChangeDate= '" + txtDate.Text; } moe = GetSearchInfo(); dtMain = mskbl.M_ShiireKakeritsu_Select(moe); dvMain = new DataView(dtMain); dgv_ShiireKakeritsu.DataSource = dvMain; }
public MasterTouroku_ShiireKakeritsu() { InitializeComponent(); mskbl = new MasterTouroku_ShiireKakeritsu_BL(); moe = new M_OrderRate_Entity(); mve = new M_Vendor_Entity(); mbe = new M_Brand_Entity(); dvMain = new DataView(); }
public DataTable MasterTouroku_ShiireKakeritsu_Select(M_OrderRate_Entity moe) { string sp = "M_ShiireKakeritsu_Select"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@VendorCD", new ValuePair { value1 = System.Data.SqlDbType.VarChar, value2 = moe.VendorCD } }, { "@StoreCD", new ValuePair { value1 = System.Data.SqlDbType.VarChar, value2 = moe.StoreCD } } }; return(SelectData(dic, sp)); }
public DataTable M_Shiirekakeritsu(M_OrderRate_Entity moe, string xml, L_Log_Entity log_data) { string sp = "M_OrderRate_Update"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@xml", new ValuePair { value1 = SqlDbType.VarChar, value2 = xml } }, { "@VendorCD", new ValuePair { value1 = System.Data.SqlDbType.VarChar, value2 = moe.VendorCD } }, { "@StoreCD", new ValuePair { value1 = System.Data.SqlDbType.VarChar, value2 = moe.StoreCD } }, { "@ChangeDate", new ValuePair { value1 = System.Data.SqlDbType.VarChar, value2 = moe.ChangeDate } }, { "@Rate", new ValuePair { value1 = System.Data.SqlDbType.VarChar, value2 = moe.Rate } }, { "@Operator", new ValuePair { value1 = SqlDbType.VarChar, value2 = moe.Operator } }, //ses { "@Program", new ValuePair { value1 = SqlDbType.VarChar, value2 = moe.ProgramID } }, { "@PC", new ValuePair { value1 = SqlDbType.VarChar, value2 = moe.PC } }, { "@OperateMode", new ValuePair { value1 = SqlDbType.VarChar, value2 = moe.ProcessMode } }, { "@KeyItem", new ValuePair { value1 = SqlDbType.VarChar, value2 = moe.Key } } }; return(SelectData(dic, sp)); }
private M_OrderRate_Entity GetSearchInfo() { moe = new M_OrderRate_Entity() { VendorCD = scSupplierCD.TxtCode.Text, StoreCD = cbo_Store.SelectedValue.ToString(), BrandCD = scBrandCD1.TxtCode.Text, BrandName = scBrandCD1.LabelText, SportsCD = scSportsCD1.TxtCode.Text, SegmentCD = scSegmentCD1.TxtCode.Text, LastYearTerm = cbo_Year1.SelectedText, LastSeason = cbo_Season1.SelectedText, ChangeDate = txtDate.Text, Rate = txtRate.Text, ProcessMode = ModeText, ProgramID = InProgramID, InsertOperator = InOperatorCD, Key = scSupplierCD.Code, PC = InPcID }; return(moe); }
public DataTable M_OrderRate_Update(M_OrderRate_Entity moe, string Xml, L_Log_Entity log_data) { return(mskdl.M_Shiirekakeritsu(moe, Xml, log_data)); }
public DataTable M_ShiireKakeritsu_Select(M_OrderRate_Entity moe) { return(mskdl.MasterTouroku_ShiireKakeritsu_Select(moe)); }