%@ WebHandler Language="C#" Class="QualityData_SubLineDataQuery" %>
using System;
using System.Web;
public class QualityData_SubLineDataQuery : IHttpHandler {
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string type = HttpContext.Current.Request["type"];
string responseText = "";
switch (type)
{
//工位号查询查询
case "OpnameSelect":
responseText = OpnameSelect();
break;
//物料数据查询
case "dataMateralSelect":
responseText = dataMateralSelect();
break;
//查询物料条码批次
case "BarcodeBatchMaterialsSelect":
responseText = MaterialBatchSelect();
break;
}
context.Response.Write(responseText);
}
///
///物料条码批次查询 2014-11-25
///
///
private string MaterialBatchSelect()
{
System.Data.DataTable dt = null;
string dtStartTime = HttpContext.Current.Request["startdate"];
string dtEndTime = HttpContext.Current.Request["enddate"];
MES_SPC.QualityData_MaterialSelect.GetMaterial_SublineBarcodeBatchMaterials(dtStartTime, dtEndTime, out dt);
string text = JsonHelper.DataTableToJson(dt);
return text;
}
///
///工位查询
///
///
private string OpnameSelect()
{
System.Data.DataTable dt = null;
MES_SPC.CraftMana_step.OpnameSelect(out dt);
string text = JsonHelper.DataTableToJson(dt);
return text;
}
///
/// 分线物料数据查询
///
///
private string dataMateralSelect()
{
System.Data.DataTable dt = null;
string startdate = HttpContext.Current.Request["startdate"];
string enddate = HttpContext.Current.Request["enddate"];
bool checkbox_opname = Convert.ToBoolean(HttpContext.Current.Request["checkbox_opname"]);
string opName = HttpContext.Current.Request["opName"];
bool checkbox_MaterialsBatchBarcode = Convert.ToBoolean(HttpContext.Current.Request["checkbox_BarcodeBatchMaterials"]);
string comboBox_MaterialsBatchBarcode = HttpContext.Current.Request["comboBox_BarcodeBatchMaterials"];
MES_SPC.QualityData_MaterialSelect.SubLineSelect_material(startdate, enddate,checkbox_opname,
opName, checkbox_MaterialsBatchBarcode, comboBox_MaterialsBatchBarcode,out dt);
string text = JsonHelper.CreateJsonParameters(dt, true, 0);//这句话是将json数据对象化,并且返回数据总条数
return text;
}
public bool IsReusable {
get {
return false;
}
}
}