public ULPlan GetULPlanByPlanNo(string ulplanNo)
{
ULPlan ulPlan = null;
try
{
ProcParam param = new ProcParam(6)
{
ProcedureName = "UPLOAD_PLAN.GET_UL_PLAN"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strFindAll", DBNull.Value);
param.AddParamInput(2, "strPLAN_NO", ulplanNo);
param.AddParamInput(3, "strTYPE", DBNull.Value);
param.AddParamInput(4, "strPDT_FROM", DBNull.Value);
param.AddParamInput(5, "strPDT_TO", DBNull.Value);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
//this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1;
while (OraDataReader.Instance.OraReader.Read())
{
ulPlan = new ULPlan();
ulPlan.PLAN_NO = OraDataReader.Instance.GetString("PLAN_NO");
ulPlan.PROD_TYPE = OraDataReader.Instance.GetString("PROD_TYPE");
ulPlan.REC_STAT = (OraDataReader.Instance.GetString("REC_STAT").ToUpper() == "Y");
ulPlan.PLAN_DATE = OraDataReader.Instance.GetDateTime("PLAN_DATE");
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
ulPlan = null;
throw ex;
}
return(ulPlan);
}
public List <ULPlan> GetULPlanList(string type, string findValue, DateTime?formDate, DateTime?toDate)
{
List <ULPlan> lstULPlan = null;
ULPlan ULPlan;
try
{
ProcParam param = new ProcParam(6)
{
ProcedureName = "UPLOAD_PLAN.GET_UL_PLAN"
};
param.AddParamRefCursor(0, "io_cursor");
param.AddParamInput(1, "strFindAll", findValue);
param.AddParamInput(2, "strPLAN_NO", DBNull.Value);
param.AddParamInput(3, "strTYPE", type);
if (formDate.HasValue)
{
param.AddParamInput(4, "strPDT_FROM", formDate.Value);
}
else
{
param.AddParamInput(4, "strPDT_FROM", DBNull.Value);
}
if (toDate.HasValue)
{
param.AddParamInput(5, "strPDT_TO", toDate.Value);
}
else
{
param.AddParamInput(5, "strPDT_TO", DBNull.Value);
}
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(param);
////this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
lstULPlan = new List <ULPlan>();
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 1000;
while (OraDataReader.Instance.OraReader.Read())
{
ULPlan = new ULPlan();
ULPlan.PLAN_NO = OraDataReader.Instance.GetString("PLAN_NO");
ULPlan.PROD_TYPE = OraDataReader.Instance.GetString("PROD_TYPE");
ULPlan.REC_STAT = (OraDataReader.Instance.GetString("REC_STAT").ToUpper() == "Y");
ULPlan.PLAN_DATE = OraDataReader.Instance.GetDateTime("PLAN_DATE");
ULPlan.PLAN_STAT = OraDataReader.Instance.GetString("PLAN_STAT");
lstULPlan.Add(ULPlan);
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
}
catch (Exception ex)
{
lstULPlan = null;
throw ex;
}
return(lstULPlan);
}
