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 + ""));
}
