public List <RMPlanningModel> GetAllRMPlanning() { List <RMPlanningModel> objRMList = new List <RMPlanningModel>(); try { string sqlstr = "ssmsp_Get_AllRMByGradeOfMaterial"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { RMPlanningModel objtemp = new RMPlanningModel(); objtemp.GradeOfMaterial = sdr["GradeOfMaterial"].ToString(); objtemp.HeatCode = sdr["HeatCode"].ToString(); objtemp.Section = sdr["Section"].ToString(); var qty = (sdr["Quntity"].ToString()); objtemp.Qty = qty == "" ? "0" : qty; var Unit = sdr["RMUnit"].ToString(); objtemp.Unit = Unit == "" ? "NA" : Unit; objRMList.Add(objtemp); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objRMList); }
public List <RMPlanningModel> GetAllRMPlanning(string gradeOfMaterial, string wono, string section, string heatcode) { List <RMPlanningModel> objRMAllocateList = new List <RMPlanningModel>(); try { var gof = gradeOfMaterial.Trim(); string sqlstr = "ssmsp_Get_AllWorkorder"; var connection = gConnection.Connection(); connection.Open(); SqlCommand cmd = new SqlCommand(sqlstr, connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", "GetWoDataByGofHtSec"); cmd.Parameters.AddWithValue("@GradeOfMaterial", gof); cmd.Parameters.AddWithValue("@section", section); cmd.Parameters.AddWithValue("@heatcode", heatcode); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { RMPlanningModel objtemp = new RMPlanningModel(); objtemp.WorkorderNo = wono; objtemp.GradeOfMaterial = sdr["GradeOfMaterial"].ToString(); objtemp.HeatCode = sdr["HeatCode"].ToString(); objtemp.Section = sdr["Section"].ToString(); var qty = (sdr["Quntity"].ToString()); objtemp.Qty = qty == "" ? "0" : qty; var Unit = sdr["RMUnit"].ToString(); objtemp.Unit = Unit == "" ? "NA" : Unit; objRMAllocateList.Add(objtemp); } connection.Close(); } catch (Exception ex) { ErrorHandlerClass.LogError(ex); } return(objRMAllocateList); }