public ActionResult GetZLDeviceData(string id) { string page = Request["page"].Trim(); string rows = Request["rows"].Trim(); FieldModel where = T_BASE_COMPANY_ZL.ISDEL == "0"; if (!string.IsNullOrEmpty(id)) { id = id.Trim(); where &= T_BASE_COMPANY_ZL.COMPANYID == id; } else { where &= T_BASE_COMPANY_ZL.COMPANYID == "0"; } SqlModel sql = SqlModel.SelectAll(T_BASE_COMPANY_ZL.NAME.As("PKNAME") ) .From(DB.T_BASE_COMPANY_ZL) .LeftJoin(DB.T_BASE_COMPANY_PK).On(T_BASE_COMPANY_ZL.PKID == T_BASE_COMPANY_PK.ID) //.LeftJoin(DB.BASDIC.As("ISHB")).On(T_BASE_COMPANY_CONTACT.ISHB == "ISHB".Field("CODE") & "ISHB".Field("TYPECODE") == "TrueOrFalse") .Where(where) .OrderByDesc(T_BASE_COMPANY_ZL.CREATETIME); PagedDataTable dtResult = sql.ExecToPagedTable(Convert.ToInt32(page), Convert.ToInt32(rows), new OrderByModel() { OrderType = OrderType.Desc, FieldModel = T_BASE_COMPANY_ZL.CREATETIME }); return(Content(JsonConvert.SerializeObject(new { total = dtResult.TotalCount, rows = dtResult.Data }), "application/json", Encoding.UTF8)); }
/// <summary> /// 支持用DataTable /// </summary> /// <param name="sqlModel"></param> /// <param name="data"></param> /// <param name="dtData"></param> /// <returns></returns> public JsonResult PagedJson(SqlModel sqlModel, RequestData data, DataTable dtData) { int page = this.GetPage(data); int rows = this.GetRows(data); OrderByModel om = this.GetOrderBy(data, sqlModel); PagedDataTable pdt = sqlModel.ExecToPagedTable(page, rows, om, dtData); dynamic result = pdt.ToDynamic(); return(Json(result)); }
public ActionResult GetData(string CompanyName, string AREA, string HYLB, string GZCD, string isVOCs) { string page = Request["page"].Trim(); string rows = Request["rows"].Trim(); FieldModel where = T_BASE_COMPANY.ISDEL == "0"; if (!string.IsNullOrEmpty(CompanyName)) { CompanyName = HttpUtility.UrlDecode(CompanyName.Trim()).Trim(); where &= T_BASE_COMPANY.NAME.Like(CompanyName); } if (!string.IsNullOrEmpty(AREA) && AREA != "all") { AREA = AREA.Trim(); where &= T_BASE_COMPANY.AREA == AREA; } if (!string.IsNullOrEmpty(HYLB)) { HYLB = HYLB.Trim(); where &= T_BASE_COMPANY.BASTYPE == HYLB; } if (!string.IsNullOrEmpty(GZCD)) { GZCD = GZCD.Trim(); where &= T_BASE_COMPANY.GZCD == GZCD; } if (!string.IsNullOrEmpty(isVOCs)) { isVOCs = isVOCs.Trim(); where &= T_BASE_COMPANY.ISVOCS == isVOCs; } SqlModel sql = SqlModel.Select(T_BASE_COMPANY.ID, T_BASE_COMPANY.ID.As("ID2"), T_BASE_COMPANY.NAME, T_SYS_AREA.AREA_TEXT.As("NAREA"), T_BASE_COMPANY.ADDRESS, T_BASE_COMPANY.BASTYPE, "BASTYPE".Field("TITLE").As("NBASTYPE"), "GZCD".Field("TITLE").As("NGZCD"), T_BASE_COMPANY.LEGALOR ) .From(DB.T_BASE_COMPANY) .LeftJoin(DB.T_SYS_AREA).On(T_BASE_COMPANY.AREA == T_SYS_AREA.AREA_CODE) .LeftJoin(DB.BASDIC.As("BASTYPE")).On(T_BASE_COMPANY.BASTYPE == "BASTYPE".Field("CODE") & "BASTYPE".Field("TYPECODE") == "IndustryType") .LeftJoin(DB.BASDIC.As("GZCD")).On(T_BASE_COMPANY.GZCD == "GZCD".Field("CODE") & "GZCD".Field("TYPECODE") == "CompanyGZCD") .Where(where) .OrderByDesc(T_BASE_COMPANY.CREATETIME); PagedDataTable dtResult = sql.ExecToPagedTable(Convert.ToInt32(page), Convert.ToInt32(rows), new OrderByModel() { OrderType = OrderType.Desc, FieldModel = T_BASE_COMPANY.CREATETIME }); return(Content(JsonConvert.SerializeObject(new { total = dtResult.TotalCount, rows = dtResult.Data }), "application/json", Encoding.UTF8)); }
public ActionResult GetPKInfoData(string id, string PKType) { string page = Request["page"].Trim(); string rows = Request["rows"].Trim(); FieldModel where = T_BASE_COMPANY_PK.ISDEL == "0"; if (!string.IsNullOrEmpty(id)) { id = id.Trim(); where &= T_BASE_COMPANY_PK.COMPANYID == id; } else { where &= T_BASE_COMPANY_PK.COMPANYID == "0"; } if (!string.IsNullOrEmpty(PKType)) { id = id.Trim(); where &= T_BASE_COMPANY_PK.TYPE == PKType; } SqlModel sql = SqlModel.SelectAll("GASTYPE".Field("TITLE").As("NGASTYPE"), "WAY".Field("TITLE").As("NWAY"), "REGULAR".Field("TITLE").As("NREGULAR") ) .From(DB.T_BASE_COMPANY_PK) .LeftJoin(DB.BASDIC.As("GASTYPE")).On(T_BASE_COMPANY_PK.TYPE == "GASTYPE".Field("CODE") & "GASTYPE".Field("TYPECODE") == "CompanyPKGasType") .LeftJoin(DB.BASDIC.As("WAY")).On(T_BASE_COMPANY_PK.WAY == "WAY".Field("CODE") & "WAY".Field("TYPECODE") == "CompanyPKWay") .LeftJoin(DB.BASDIC.As("REGULAR")).On(T_BASE_COMPANY_PK.REGULAR == "REGULAR".Field("CODE") & "REGULAR".Field("TYPECODE") == "CompanyPKPFGL") .Where(where) .OrderByDesc(T_BASE_COMPANY_PK.CREATETIME); PagedDataTable dtResult = sql.ExecToPagedTable(Convert.ToInt32(page), Convert.ToInt32(rows), new OrderByModel() { OrderType = OrderType.Desc, FieldModel = T_BASE_COMPANY_PK.CREATETIME }); return(Content(JsonConvert.SerializeObject(new { total = dtResult.TotalCount, rows = dtResult.Data }), "application/json", Encoding.UTF8)); }