public ActionResult GetPageList(Pagination pagination, string queryJson) { pagination.p_kid = "Id"; pagination.p_fields = "znetwneight/1000 znetwneight,zcount, ca.Numbers,ca.createdate,ca.GetData,ca.ProductType,ca.SupplyName,ca.PlateNumber,ca.Dress,ca.Remark,ca.transporttype,ca.takegoodsname,ca.PassRemark,ca.IsFirst,ca.IsTrajectory,ca.WeighingNum,ca.DataBaseNum,ca.OutDate,ca.StayTime,ca.Status,ca.OrderNum,ca.OutDatabaseTime"; pagination.p_tablename = "WL_OPERTICKETMANAGER ca left join (SELECT SUM(netwneight) znetwneight,COUNT(BASEID) zcount, BASEID FROM WL_CALCULATE WHERE ISDELETE='1' GROUP BY BASEID) calculate on calculate.BASEID=ca.id "; pagination.conditionJson = "1=1 and Isdelete='1' "; var watch = CommonHelper.TimerStart(); var data = operticketmanagerbll.GetPageList(pagination, queryJson); var JsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(Content(JsonData.ToJson())); }
public ActionResult GetPageList(Pagination pagination, string queryJson) { pagination.p_kid = "Id"; pagination.p_fields = "Numbers,createdate,GetData,ProductType,SupplyName,isdelete,PlateNumber,Dress,Remark,transporttype,takegoodsname,PassRemark,IsFirst,IsTrajectory,WeighingNum,DataBaseNum,OutDate,StayTime,Status,deletecontent"; pagination.p_tablename = "WL_OPERTICKETMANAGER"; pagination.conditionJson = "1=1 "; var watch = CommonHelper.TimerStart(); var data = operticketmanagerbll.GetPageList(pagination, queryJson); var JsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(Content(JsonData.ToJson())); }
public ActionResult GetPageList(Pagination pagination, string queryJson) { pagination.p_kid = "Id"; pagination.p_fields = "Numbers,createdate,GetData,ProductType,SupplyName,PlateNumber,Dress,Remark,transporttype,takegoodsname,outdate,outcu,getstamptime,ORDERNUMR,drivername,drivertel"; pagination.p_tablename = "WL_OPERTICKETMANAGER"; pagination.conditionJson = "1=1 and Isdelete='1' "; var watch = CommonHelper.TimerStart(); var data = operticketmanagerbll.GetPageList(pagination, queryJson); var JsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(Content(JsonData.ToJson())); }
public object GetUserInformationList(string json) { try { //string res = //json.Value<string>("json");//[FromBody]JObject dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(json); string userId = dy.userid; string username = dy.data.username; //姓名 string jobnumber = dy.data.jobnumber; //手机号 //获取用户基本信息 OperatorProvider.AppUserId = userId; //设置当前用户 Operator curUser = OperatorProvider.Provider.Current(); if (null == curUser) { curUser = GetOperator(dy.userid); if (curUser == null) { return(new { code = -1, count = 0, info = "当前用户不存在,请核对用户信息!" }); } } Pagination pagination = new Pagination(); pagination.p_kid = "id"; pagination.p_fields = @" d.username,d.vid,d.gpsid,d.gpsname,d.intime,d.outtime,d.state,'' as phone,'' as comname "; pagination.p_tablename = "bis_persongps d"; pagination.conditionJson = " state=0 "; //pagination.sidx = pagination.sidx + " " + pagination.sord + ",id"; if (!string.IsNullOrEmpty(username)) { //姓名 pagination.conditionJson += " and username like '%" + username.Trim() + "%'"; } if (!string.IsNullOrEmpty(dy.data.starttime)) {// pagination.conditionJson += " and username like '" + jobnumber.Trim() + "%'"; } //获取页数和条数 int page = Convert.ToInt32(dy.data.pagenum), rows = Convert.ToInt32(dy.data.pagesize); pagination.page = page; //页数 pagination.rows = rows; //行数 pagination.sidx = "createdate"; //排序字段 pagination.sord = "desc"; //排序方式 DataTable data = operticketmanagerbll.GetPageList(pagination, null); if (data.Rows.Count > 0) { foreach (DataRow Rows in data.Rows) { string pid = Rows[2].ToString(); string sql = string.Format("select d.dirver,d.phone,CONCAT(CONCAT(d.visitdept,'/'),d.carno) as purpose from bis_usercar d where d.id='{0}' ", pid); string sql1 = string.Format("select d.dirver,d.phone,CONCAT(CONCAT(d.visitdept,'/'),d.carno) as purpose from bis_visitcar d where d.id='{0}' ", pid); string sql2 = string.Format("select Phone,TheCompany,d.dirver from bis_hazardouscar d where d.id='{0}' ", pid); DataTable dt = operticketmanagerbll.GetDataTable(sql); DataTable dt1 = operticketmanagerbll.GetDataTable(sql1); DataTable dt2 = operticketmanagerbll.GetDataTable(sql2); if (dt.Rows.Count > 0) {//拜访(无车) if (Rows[1].ToString() == dt.Rows[0][0].ToString()) { Rows["phone"] = dt.Rows[0][1].ToString(); } Rows["comname"] = dt.Rows[0][2].ToString(); } else if (dt1.Rows.Count > 0) {//拜访(有车) if (Rows[1].ToString() == dt1.Rows[0][0].ToString()) { Rows["phone"] = dt1.Rows[0][1].ToString(); } Rows["comname"] = dt1.Rows[0][2].ToString(); } else if (dt2.Rows.Count > 0) {//拜访(危化品) if (Rows[1].ToString() == dt2.Rows[0][2].ToString()) { Rows["phone"] = dt2.Rows[0][0].ToString(); } Rows["comname"] = dt2.Rows[0][1].ToString(); } dt.Dispose(); dt1.Dispose(); dt2.Dispose(); } } return(new { code = 0, info = "获取数据成功", count = pagination.records, data = data.ToJson() }); } catch (Exception ex) { return(new { code = -1, count = 0, info = ex.Message }); } }