public async Task <MethodReturnResult <DataSet> > GetDataAsync(DataAcquisitionTransGetParameter p) { return(await Task.Run <MethodReturnResult <DataSet> >(() => { return base.Channel.GetData(ref p); })); }
public async Task <ActionResult> PagingQuery(string where, string orderBy, int?currentPageNo, int?currentPageSize) { MethodReturnResult result = new MethodReturnResult(); DataAcquisitionTransGetParameter p = new DataAcquisitionTransGetParameter(); try { int pageNo = currentPageNo ?? 0; int pageSize = currentPageSize ?? 20; if (Request["PageNo"] != null) { pageNo = Convert.ToInt32(Request["PageNo"]); } if (Request["PageSize"] != null) { pageSize = Convert.ToInt32(Request["PageSize"]); } //初始化参数 //p.StartDate = GetValueDataByString(where, "StartDate", "=", ";"); //开始日期 //p.EndDate = GetValueDataByString(where, "EndDate", "=", ";"); //结束日期 p.ItemCode = GetValueDataByString(where, "ItemCode", "=", ";"); //项目代码 p.LocationName = GetValueDataByString(where, "LocationName", "=", ";"); //车间 p.LineCode = GetValueDataByString(where, "LineCode", "=", ";"); //线别 p.EquipmentCode = GetValueDataByString(where, "EquipmentCode", "=", ";"); //设备代码 p.PageSize = pageSize; p.PageNo = pageNo + 1; await Task.Run(() => { using (DataAcquisitionTransServiceClient client = new DataAcquisitionTransServiceClient()) { DataTable dt = new DataTable(); //采集结果集 PagingConfig cfg = new PagingConfig() { PageNo = pageNo, PageSize = pageSize, Where = where ?? string.Empty, OrderBy = orderBy ?? string.Empty }; MethodReturnResult <DataSet> rst = client.GetData(ref p); if (rst.Code > 0) //产生错误 { result.Code = rst.Code; result.Message = rst.Message; result.Detail = rst.Detail; //return result; } else { cfg.Records = p.Records; //总记录数 //根据报表格式及数据清单组合数据列表 result = CreateTableList(rst, ref dt); if (result.Code > 0) //产生错误 { //return Json(result); } } ViewBag.PagingConfig = cfg; ViewBag.ListData = dt; } }); return(PartialView("_ListPartial")); } catch (Exception e) { result.Code = 1002; result.Message = e.Message; result.Detail = e.ToString(); } return(Json(result)); }
public ActionResult Query(DataAcquisitionTransQueryViewModel model) { MethodReturnResult result = new MethodReturnResult(); DataAcquisitionTransGetParameter p = new DataAcquisitionTransGetParameter(); try { #region 取得数据 DataTable dt = new DataTable(); //采集结果集 PagingConfig cfg = new PagingConfig() { OrderBy = "", Where = "" }; using (DataAcquisitionTransServiceClient client = new DataAcquisitionTransServiceClient()) { //初始化参数 p.EDCTime = model.EDCTime; //采集时间 p.ItemCode = model.ItemCode; //项目代码 p.LocationName = model.LocationName; //车间 p.LineCode = model.LineCode; //线别 p.EquipmentCode = model.EquipmentCode; //设备代码 p.PageSize = model.PageSize; p.PageNo = model.PageNo; MethodReturnResult <DataSet> rst = client.GetData(ref p); if (rst.Code > 0) //产生错误 { result.Code = rst.Code; result.Message = rst.Message; result.Detail = rst.Detail; return(Json(result)); } else { ViewBag.FieldData = rst.Data.Tables[0]; //采集字段数据 cfg.Records = p.Records; //总记录数 //根据报表格式及数据清单组合数据列表 result = CreateTableList(rst, ref dt); if (result.Code > 0) //产生错误 { return(Json(result)); } } } #endregion //回传参数 //创建Where条件 cfg.Where = "?ItemCode=" + model.ItemCode + ";" + "EDCTime=" + model.EDCTime + ";" + "LocationName=" + model.LocationName + ";" + "LineCode=" + model.LineCode + ";" + "EquipmentCode=" + model.EquipmentCode; ViewBag.PagingConfig = cfg; ViewBag.ListData = dt; if (Request.IsAjaxRequest()) { return(PartialView("_ListPartial", model)); } else { return(View(model)); } } catch (Exception e) { result.Code = 1002; result.Message = e.Message; result.Detail = e.ToString(); } return(Json(result)); }
/// <summary> /// 通过存储过程取得采集数据事务结果列表 /// </summary> /// <param name="p">参数。</param> /// <returns>方法执行结果。</returns> public MethodReturnResult <DataSet> GetData(ref DataAcquisitionTransGetParameter p) { MethodReturnResult <DataSet> result = new MethodReturnResult <DataSet>(); try { DataSet dsResult = new DataSet(); DataTable dt = new DataTable(); using (DbConnection con = this._db.CreateConnection()) { int iReturn; string strErrorMessage = string.Empty; DbCommand cmd = con.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_EDC_DataAcquisitionTrans_list"; this._db.AddInParameter(cmd, "EDCTime", DbType.DateTime, p.EDCTime); //采集时间 this._db.AddInParameter(cmd, "ItemCode", DbType.String, string.IsNullOrEmpty(p.ItemCode) ? "%" : p.ItemCode); //项目代码 this._db.AddInParameter(cmd, "LocationName", DbType.String, string.IsNullOrEmpty(p.LocationName) ? "" : p.LocationName); //车间 this._db.AddInParameter(cmd, "LineCode", DbType.String, string.IsNullOrEmpty(p.LineCode) ? "" : p.LineCode); //线别 this._db.AddInParameter(cmd, "EquipmentCode", DbType.String, string.IsNullOrEmpty(p.EquipmentCode) ? "" : p.EquipmentCode); //设备代码 this._db.AddInParameter(cmd, "@pageSize", DbType.Int32, p.PageSize); //单页数据大小 this._db.AddInParameter(cmd, "@pageNo", DbType.Int32, p.PageNo); //页号 this._db.AddOutParameter(cmd, "@Records", DbType.Int32, int.MaxValue); //数据总记录数 //设置返回错误信息 cmd.Parameters.Add(new SqlParameter("@ErrorMsg", SqlDbType.NVarChar, 512)); cmd.Parameters["@ErrorMsg"].Direction = ParameterDirection.Output; //设置返回值 SqlParameter parReturn = new SqlParameter("@return", SqlDbType.Int); parReturn.Direction = ParameterDirection.ReturnValue; cmd.Parameters.Add(parReturn); //执行存储过程 dsResult = this._db.ExecuteDataSet(cmd); //取得返回值 iReturn = (int)cmd.Parameters["@return"].Value; if (iReturn == -1) //调用失败返回错误信息 { strErrorMessage = cmd.Parameters["@ErrorMsg"].Value.ToString(); result.Code = 1000; result.Message = strErrorMessage; result.Detail = strErrorMessage; return(result); } //返回总记录数 p.Records = Convert.ToInt32(cmd.Parameters["@Records"].Value); } result.Data = dsResult; } catch (Exception ex) { result.Code = 1000; result.Message = ex.Message; result.Detail = ex.ToString(); } return(result); }
public MethodReturnResult <DataSet> GetData(ref DataAcquisitionTransGetParameter p) { return(base.Channel.GetData(ref p)); }