public TempoRegiMasterNyuuryoku() { mnrk_bl = new TempoRegiMasterNyuuryoku_BL(); sbgd_e = new M_StoreBottunDetails_Entity(); dtSelect = new DataTable(); InitializeComponent(); }
public bool Button_Details_Insert_Update(M_StoreBottunDetails_Entity msbd) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>() { { "@GroupXML", new ValuePair { value1 = SqlDbType.VarChar, value2 = msbd.GroupXML } }, { "@GroupDetailXML", new ValuePair { value1 = SqlDbType.VarChar, value2 = msbd.GroupDetailXML } }, { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = msbd.StoreCD } }, { "@Operator", new ValuePair { value1 = SqlDbType.VarChar, value2 = msbd.Operator } }, { "@Program", new ValuePair { value1 = SqlDbType.VarChar, value2 = msbd.ProgramID } }, { "@PC", new ValuePair { value1 = SqlDbType.VarChar, value2 = msbd.PC } } }; UseTransaction = true; return(InsertUpdateDeleteData(dic, "Button_Details_Insert_Update")); }
private void CheckData_M_StoreButtonDetailes(string GroupNO = "") { M_StoreBottunDetails_Entity msb = new M_StoreBottunDetails_Entity(); msb.StoreCD = mStoreCD; msb.ProgramKBN = "1"; msb.GroupNO = GroupNO; StoreButtonDetails_BL sbl = new StoreButtonDetails_BL(); dtBottunDetails = sbl.M_StoreButtonDetails_SelectAll(msb); DispFromButtonDetailsTable(); }
private M_StoreBottunDetails_Entity GetGroupDetailsData() { sbgd_e = new M_StoreBottunDetails_Entity() { StoreCD = StoreCD, // MasterKBN = RdoJanCD.Checked ? "1" : "2", dtGroup = dtTemp1, dtGpDetails = dtTemp2, Operator = InOperatorCD, ProgramID = InProgramID, PC = InPcID, // Key = txtButtomNameUp.Text }; return(sbgd_e); }
public DataTable M_StoreButtonDetails_SelectAll(M_StoreBottunDetails_Entity mse) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>() { { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.StoreCD } }, { "@ProgramKBN", new ValuePair { value1 = SqlDbType.TinyInt, value2 = mse.ProgramKBN } }, { "@GroupNO", new ValuePair { value1 = SqlDbType.TinyInt, value2 = mse.GroupNO } } }; return(SelectData(dic, "M_StoreButtonDetails_SelectAll")); }
private void Save() { if (mnrk_bl.ShowMessage("Q101") == DialogResult.Yes) { sbgd_e = GetGroupDetailsData(); if (mnrk_bl.Button_Details_Insert_Update(sbgd_e))//更新 { GridViewDataBind(); SaveClear(); bbl.ShowMessage("I101"); } else { bbl.ShowMessage("S001"); } } }
public DataTable M_StoreButtonDetails_SelectAll(M_StoreBottunDetails_Entity mse) { return(storedl.M_StoreButtonDetails_SelectAll(mse)); }
public bool Button_Details_Insert_Update(M_StoreBottunDetails_Entity mre) { mre.GroupXML = DataTableToXml(mre.dtGroup); mre.GroupDetailXML = DataTableToXml(mre.dtGpDetails); return(msbd_dl.Button_Details_Insert_Update(mre)); }