public override void Ashx_Load() { string actionType = ""; string type = ""; string text = ""; CheckRequery.checkNotNull("actionType", "类型不能为空!", out actionType); string strSql = ""; switch (actionType) { case "POI": CheckRequery.check("text", out text); strSql = string.Format("SELECT 经度,纬度,geom,st_asgeojson(geom) geometry from leakage.poi where 名称='{0}'", text); DataSet ContentList = APP.PGSQL_Helper.Query(strSql); Context.Response.Write(EasyUI_Pagination.ExportSuccess(ContentList.Tables[0], ContentList.Tables[0].Rows.Count)); break; case "Road": CheckRequery.check("text", out text); strSql = string.Format("SELECT 道路名称,geom,st_asgeojson(geom) geometry from leakage.dlzxx where 道路名称='{0}'", text); ContentList = APP.PGSQL_Helper.Query(strSql); Context.Response.Write(EasyUI_Pagination.ExportSuccess(ContentList.Tables[0], ContentList.Tables[0].Rows.Count)); break; } }
protected void getHiddenById(string hdId) { string strSql = string.Format(@" select p.cAdminName,d.lhd_xy,d.lhd_uptime,d.lhd_faxiantime,d.lhd_address,d.lhd_miaoshu,d.lhd_hiddenimage from Line_HiddenDanger d left join P_Admin p on d.lhd_upname=p.iAdminID where d.lhd_id={0}", hdId); DataSet ContentList = APP.SQLServer_Helper.Query(strSql); Context.Response.Write(EasyUI_Pagination.ExportSuccess(ContentList.Tables[0], ContentList.Tables[0].Rows.Count)); }
protected void getTaskStatus(string lpId) { string strSql = string.Format(@"select lpa.lpa_typeid,lpa.lpa_xy,lpa.lpa_id,lpa.lpa_jihuaname,lhd.lp_id as lhd_id from Line_Patrol lp left join Line_PatrolArea lpa on lp.lp_fanwei = lpa.lpa_typeid left join (select distinct lp_id,lpa_id,lpa_ids from Line_HiddenDanger group by lp_id,lpa_id,lpa_ids) lhd on lhd.lp_id = lp.lp_id and lhd.lpa_id = lpa.lpa_typeid and lhd.lpa_ids = lpa.lpa_id where 1=1 and lp.lp_shenhe = '已审核' and lp.lp_id={0}", lpId); DataSet ContentList = APP.SQLServer_Helper.Query(strSql); Context.Response.Write(EasyUI_Pagination.ExportSuccess(ContentList.Tables[0], ContentList.Tables[0].Rows.Count)); }
public override void Ashx_Load() { var sql = ""; //变量赋值 CheckRequery.checkNotNull("strSql", "", out sql); string strSql = sql; string ErrInfo = string.Empty; DataSet ContentList = APP.PGSQL_Helper.Query(strSql); Context.Response.Write(EasyUI_Pagination.ExportSuccess(ContentList.Tables[0], ContentList.Tables[0].Rows.Count)); }
public override void Ashx_Load() { string biaoming = ""; CheckRequery.checkNotNull("biaoming", "", out biaoming); //string sql = "select count(0) from leakage.ptjsgx;"; string sql = "select count(0) from " + biaoming; string ErrInfo = string.Empty; DataTable dt = new DataTable(); dt = APP.PGSQL_Helper.SelectDataTable(sql.ToString(), out ErrInfo); if (string.IsNullOrEmpty(ErrInfo)) { Context.Response.Write(EasyUI_Pagination.ExportSuccess(dt)); } else { Context.Response.Write(EasyUI_Pagination.ExportErrMsg(ErrInfo)); } }