/// <summary>
/// 获取品名
/// </summary>
public JsonResult GetMaterialNo()
{
JsonResult result = new JsonResult();
DataTable data = new BeamLibraryDAL().GetMaterialNo();
int count = data.Rows.Count;
object[] List = new object[count];
int i = 0;
foreach (DataRow row in data.Rows)
{
List[i] = new object[] { (string)row["sMaterialNo"], (string)row["sMaterialNo"] };
i++;
}
result.Data = List;
return(result);
}
/// <summary>
/// 轴库明细统计
/// </summary>
public JsonResult BeamLibraryCountQuery()
{
//json结果
JsonResult result = new JsonResult();
//获取排序
string field = Request.QueryString["sort[field]"];
string sort = Request.QueryString["sort[sort]"];
//json.data
AjaxTablePageData <BeamLibraryCount> pageData = new AjaxTablePageData <BeamLibraryCount>();
//根据当前页和行数，获取数据集
List <BeamLibraryCount> list = new BeamLibraryDAL().GetBeamLibraryCountQuery(field, sort);
pageData.data = list;
//允许get
result.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
result.Data = pageData;
return(result);
}
/// <summary>
/// 轴库明细查询
/// </summary>
public JsonResult BeamLibraryQuery()
{
//json结果
JsonResult result = new JsonResult();
//获取查询
string query = Request.QueryString["query[generalSearch]"];
//获取状态
string sMaterialNo = Request.QueryString["query[sMaterialNo]"];
//获取排序
string field = Request.QueryString["sort[field]"];
string sort = Request.QueryString["sort[sort]"];
//json.data
AjaxTablePageData <BeamLibrary> pageData = new AjaxTablePageData <BeamLibrary>();
//根据当前页和行数，获取数据集
List <BeamLibrary> list = new BeamLibraryDAL().GetBeamLibraryQuery(query, sMaterialNo, field, sort);
pageData.data = list;
//允许get
result.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
result.Data = pageData;
return(result);
}
