public MFG_WO_MTL_List GetUnPlanedMaterial_Detail(MFG_WO_MTL_List equinfo, MFG_WO_MTL_List result)
{
DataTable dt = new DataTable();
string ReturnValue = string.Empty;
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ELCO_ConnectionString"].ToString()))
{
SqlCommand cmd = new SqlCommand();
conn.Open();
cmd.Connection = conn;
string str1 = "select a.ID,a.WorkOrderNumber,a.WorkOrderVersion,a.ItemNumber,b.MesPlanQty from MFG_WO_MTL_List a left join MFG_WO_List b on a.WorkOrderNumber=b.ErpWorkOrderNumber and a.WorkOrderVersion=b.MesWorkOrderVersion";
if (equinfo.WorkOrderNumber != "")
{
str1 += " WHERE a.WorkOrderNumber = " + equinfo.WorkOrderNumber + " and a.WorkOrderVersion='" + equinfo.WorkOrderVersion + "'";
}
cmd.CommandType = CommandType.Text;
cmd.CommandText = str1;
SqlDataAdapter Datapter = new SqlDataAdapter(cmd);
Datapter.Fill(dt);
if (dt != null && dt.Rows.Count > 0)
{
result.ID = dt.Rows[0]["ID"].ToString();
result.WorkOrderNumber = dt.Rows[0]["WorkOrderNumber"].ToString();
result.WorkOrderVersion = dt.Rows[0]["WorkOrderVersion"].ToString();
result.ItemNumber = dt.Rows[0]["ItemNumber"].ToString();
result.MesPlanQty = dt.Rows[0]["MesPlanQty"].ToString();
}
}
return(result);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
Action = RequstString("Action");
if (Action.Length == 0)
{
Action = "";
}
if (Action == "GetUnPlanedMaterial_Detail")
{
MFG_WO_MTL_List mtlinfo = new MFG_WO_MTL_List();
mtlinfo.WorkOrderNumber = RequstString("WorkOrderNumber");
mtlinfo.WorkOrderVersion = RequstString("WorkOrderVersion");
MFG_WO_MTL_List result = new MFG_WO_MTL_List();
result = GetUnPlanedMaterial_Detail(mtlinfo, result);
context.Response.Write(jsc.Serialize(result));
}
else if (Action == "UnPlanedMaterialPrintInfo")
{
context.Response.Write(GetUnPlanedMaterialPrintInfo());
}
else if (Action == "UnPlanedMaterialListInfo")
{
context.Response.Write(GetUnPlanedMaterialInfo());
}
}
