public ActionResult CuttingInstructionIssue(string wono)
{
ssmtbl_CuttingInstructionIssueModel objCutMod = new ssmtbl_CuttingInstructionIssueModel();
objCutMod = objCutData.GetCutInstrIssueByWoNo(wono);
return(View(objCutMod));
}
public ssmtbl_CuttingInstructionIssueModel GetCutInstrIssueByWoNo(string wono)
{
ssmtbl_CuttingInstructionIssueModel objtemp = new ssmtbl_CuttingInstructionIssueModel();
try
{
var connection = gConnection.Connection();
connection.Open();
string sqlstr = "ssmsp_CuttingInstructionIssue";
SqlCommand cmd = new SqlCommand(sqlstr, connection);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@WorkorderNo", wono);
cmd.Parameters.AddWithValue("@Action", "selectCuttingInstructionIssuewithWONo");
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
objtemp.WorkorderNo = (sdr["WorkorderNo"].ToString());
objtemp.CutWeight = (sdr["CutWeight"].ToString());
objtemp.CutDate = Convert.ToDateTime(sdr["CutDate"].ToString());
objtemp.CutFrom = (sdr["CutFrom"].ToString());
objtemp.CutTo = (sdr["CutTo"].ToString());
objtemp.Section = (sdr["Section"].ToString());
objtemp.Colorcode = (sdr["Colorcode"].ToString());
objtemp.CutLength = (sdr["CutLength"].ToString());
objtemp.RMRequiredQty = (sdr["RMRequiredQty"].ToString());
objtemp.PreparedBy = (sdr["PreparedBy"].ToString());
objtemp.ApprovedBy = (sdr["ApprovedBy"].ToString());
objtemp.PlanQty = (sdr["PlanQty"].ToString());
objtemp.ActualQty = (sdr["ActualQty"].ToString());
objtemp.DieNo = (sdr["DieNo"].ToString());
objtemp.Heatcode = (sdr["Heatcode"].ToString());
objtemp.PartName = (sdr["PartName"].ToString());
objtemp.MaterialSpecification = (sdr["MaterialSpecification"].ToString());
}
connection.Close();
}
catch (Exception ex)
{
ErrorHandlerClass.LogError(ex);
}
return(objtemp);
}
