public List <Stp_BarTrendChart_SearchData3> GetExecStpBarTrendChart3SearchData(string StartCreatedDate, string EndCreatedDate, string GroupID, string CategoryID, string MaterialID)
{
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
List <Stp_BarTrendChart_SearchData3> listStp_BarTrendChart_SearchData = new List <Stp_BarTrendChart_SearchData3>();
string Exceq = "EXEC [dbo].[Stp_BarTrendChart_SearchData] '" + StartCreatedDate + "','" + EndCreatedDate + "','" + GroupID + "'" + ",'" + CategoryID + "'" + ",'" + MaterialID + "'" + ",'" + "3" + "'";
var JsonString = STFunction.QryToJson(Exceq, "");
listStp_BarTrendChart_SearchData = JsonConvert.DeserializeObject <List <Stp_BarTrendChart_SearchData3> >(JsonString);
return(listStp_BarTrendChart_SearchData);
}
public List <V_Withdrawal_Status> GetV_Withdrawal_Status_SearchData(string sStepID, string sStartDate, string sEndDate)
{
PTTGSP_DWSContext db = new PTTGSP_DWSContext();
List <V_Withdrawal_Status> listv_withdrawal_status = new List <V_Withdrawal_Status>();
string Exceq = "EXEC [dbo].[Stp_Withdrawal_Status_SearchData] '" + sStartDate + "','" + sEndDate + "','" + sStepID + "'";
var JsonString = STFunction.QryToJson(Exceq, "");
listv_withdrawal_status = JsonConvert.DeserializeObject <List <V_Withdrawal_Status> >(JsonString);
return(listv_withdrawal_status);
}