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));
}
