public void AttTrnFill(AttTrn cls) { Ope.Clear(); Ope.AddParams("MFGUNIT", cls.MFGUNIT); Ope.AddParams("DEPT_CODE", cls.DEPT_CODE); Ope.AddParams("ATT_DATE", cls.Att_Date); Ope.AddParams("SHIFT", cls.SHIFT); Ope.AddParams("FLOOR", cls.FlorNo); Ope.FillDataSet(Ope.EnumServer.mServer, DS, TableName, "Api_AttTrnFill", Ope.GetParams()); }
public void TaskList(string pStrUserName, string pStrCCode) { Ope.Clear(); Ope.AddParams("U_Name", pStrUserName); Ope.AddParams("Typ", "PEN"); Ope.AddParams("AlsowithyouAdded", "TRUE"); Ope.AddParams("DetTyp", DetTyp.Det.ToString()); Ope.AddParams("CCode", pStrCCode); Ope.FillDataSet(Ope.EnumServer.mServer, DS, TableName, "Api_TaskListCount", Ope.GetParams()); }
public void SaleOrderView(clsSaleOrder cls) { Ope.Clear(); Ope.AddParams("MfgUnit", cls.MfgUnit); Ope.AddParams("YCode", cls.YCode); Ope.AddParams("StrStsType", cls.ViewStrStsType); Ope.AddParams("FDate", cls.F_DATE); Ope.AddParams("TDate", cls.T_DATE); Ope.FillDataSet(Ope.EnumServer.mServer, DS_VIEW, TableName, "uSP_SaleOrdView", Ope.GetParams()); }
public void AttCmbDisp(AttTrn cls) { DataSet dataSet = new DataSet(); //DynamicParameters parameter = new DynamicParameters(); Ope.Clear(); Ope.AddParams("MfgUnit", cls.MFGUNIT); Ope.AddParams("Dept_Code", cls.DEPT_CODE); Ope.AddParams("Type", cls.TYPE); //Ope.AddParams("@Att_Date", cls.Att_Date ); //Ope.AddParams("@SHIFT", cls.SHIFT ); //Ope.AddParams("@FLOOR", cls.FLOOR ); //var data = _dapperHelper.GetAll<FileTrn>("[dbo].[uSp_DeptMastFill]", parameter, CommandType.StoredProcedure); //var data = _dapperHelper.GetAll<AttTrn>("[dbo].[uSp_DeptMastFill]", parameter, CommandType.StoredProcedure); Ope.FillDataSet(Ope.EnumServer.mServer, DS, TableName, "Api_CmbFill", Ope.GetParams()); }
public void Fill() { Ope.Clear(); //Ope.AddParams("C_Code", C_Code); //Ope.AddParams("Y_Code", Y_Code); Ope.AddParams("Type", _TableName); Ope.AddParams("ChkOrd", _OrdFlg.ToString()); Ope.AddParams("TYP", Typ); Ope.AddParams("GrpCode", GrpCode); Ope.AddParams("ICAT", ICAT); Ope.AddParams("Dept_Code", Dept_Code); Ope.AddParams("MfgUnit", MfgUnit); Ope.AddParams("Prod_Date", Prod_Date); Ope.AddParams("MacNo", MacNo); Ope.AddParams("USER", USER); Ope.FillDataSet(Ope.EnumServer.mServer, DS, _TableName, "SP_Mast_CmbFill", Ope.GetParams()); }