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 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());
}