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 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 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 DataTable CmbFill(CmbFill cmbFill) { DataTable dt = new DataTable(); Ope.Clear(); Ope.AddParams("Type", cmbFill.Type); Ope.AddParams("ChkOrd", cmbFill.ChkOrd); Ope.AddParams("TYP", cmbFill.Typ); Ope.AddParams("Dept_Code", cmbFill.Dept_Code); Ope.AddParams("MfgUnit", cmbFill.MfgUnit); //Ope.AddParams("U_NAME", cmbFill.U_Name); //Ope.AddParams("AlsowithyouAdded", cmbFill.AlsoWithYouAdded); Ope.FillDataTable(Ope.EnumServer.mServer, dt, "SP_Mast_CmbFill", Ope.GetParams()); return(dt); }
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()); }
public IHttpActionResult AttTrnFill(int mfg, int dept, string date, string shift, string floor) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } AttTrn cls = new AttTrn(); cls.MFGUNIT = mfg; cls.DEPT_CODE = dept; cls.Att_Date = Ope.DTDBDate(date.ToString()); cls.SHIFT = shift; cls.FlorNo = floor; _eTexServices.AttTrnFill(cls); if (_eTexServices.DS == null) { return(NotFound()); } return(Ok(_eTexServices.DS)); }
public IHttpActionResult View(int mfg = 0, int ycode = 0, string status = "", string fdate = "", string tdate = "") { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } clsSaleOrder cls = new clsSaleOrder(); cls.MfgUnit = mfg; cls.YCode = ycode; cls.ViewStrStsType = status; cls.F_DATE = Ope.DTDBDate(fdate); cls.T_DATE = Ope.DTDBDate(tdate); mSaleOrd.SaleOrderView(cls); if (mSaleOrd.DS_VIEW == null) { return(NotFound()); } return(Ok(mSaleOrd.DS_VIEW)); }
public int FindNewSrNo(string pIntMfgUnit, string pStrDeptCode, string pStrDate, string pStrFlorNo, string pStrShift) { return(Ope.FindNewId(Ope.EnumServer.mServer, TableName, "Max(SRNO)", "MfgUnit = " + pIntMfgUnit + " And Dept_Code = '" + pStrDeptCode + "' And Att_Date = '" + Ope.SqlDate(pStrDate.ToString()) + "' And FlorNo = '" + pStrFlorNo + "' And Shift = '" + pStrShift + "'")); }
public int FindNewMsgLogId() { return(Ope.FindNewId(Ope.EnumServer.mServer, "MessageLog", "MAX(LogID)", "")); }
public int GetNewOrdNo(int mfg, int ycode) { return(Ope.FindNewId(Ope.EnumServer.mServer, TableName, "MAX(OrdNo)", " MfgUnit=" + mfg + " And YCode=" + ycode + "")); }