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()); } }