protected void Page_Load(object sender, EventArgs e) { string pkid = Request.QueryString["PKID"]; BLL = new XmxxBLL(WorkUser); if (!this.IsPostBack) { this.db_PKID.Text = pkid; DataTable dt = BLL.GetXmxx(pkid); if (dt.Rows.Count > 0) { List <IDataItem> list = dt.Rows[0].ToDataItem(); this.SetControlValue(list); } } }
public string SetLxxmGIS(HttpContext context) { XmxxBLL BLL = new XmxxBLL(WorkUser); string PKID = context.Request.Form["PKID"]; string x = context.Request.Form["x"]; string y = context.Request.Form["y"]; StringBuilder str = new StringBuilder(); if (string.IsNullOrEmpty(x) || string.IsNullOrEmpty(y)) { str.Append("{\"isSuccess\":false,\"Msg\":\"经纬度坐标不合法!\"}"); return(str.ToString()); } DataTable dt = BLL.GetXmxx(PKID); if (dt.Rows.Count > 0) { dt.Rows[0]["jd"] = x; dt.Rows[0]["wd"] = y; dt.Rows[0]["isSgbz"] = 1; if (BLL.SaveXmxx(dt)) { str.Append("{\"isSuccess\":true,\"Msg\":\"标注成功!\"}"); } else { str.Append("{\"isSuccess\":false,\"Msg\":\"标注失败!\"}"); } } else { str.Append("{\"isSuccess\":false,\"Msg\":\"没有记录!\"}"); } return(str.ToString()); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; int allRecordCount = 0; string json = ""; string sortname = context.Request.Params["sortname"]; string sortorder = context.Request.Params["sortorder"]; int page = Convert.ToInt32(context.Request.Params["page"]) - 1; // 系统的索引从0开始,所以此处需要减1 int pagesize = Convert.ToInt32(context.Request.Params["pagesize"]); string fromWhere = context.Request.QueryString["fromwhere"]; string rowid = context.Request.QueryString["rowid"]; object sessionAppUser = context.Session[ConfigManager.GetSignInAppUserSessionName()]; AppUser workUser = (AppUser)sessionAppUser; xmxxBLL = new XmxxBLL(workUser); //排序 string orderby = @" " + sortname + " " + sortorder + " "; //通过检索翻译 生成查询条件 FilterTranslator ft = ContextExtension.GetGridData(context); //分页 DataTable dt = new DataTable(); switch (fromWhere) { case "xmLocation": dt = xmxxBLL.GetXmxx(ft, pagesize, page, orderby, out allRecordCount); break; } ft.Parms.Clear(); string result = JSONHelper.DataTableToJson(dt); //result = Regex.Replace(result, @"[/n/r]", ""); //去掉字符串里所有换行符 //result = result.TrimEnd((char[])"\n\r".ToCharArray()); //去掉换行符 json = @"{""Rows"":[" + result + @"],""Total"":""" + allRecordCount + @"""}"; context.Response.Write(json); context.Response.End(); }
public string GetXmxx(HttpContext context) { XmxxBLL BLL = new XmxxBLL(WorkUser); string ssdq = context.Request.Params["ssdq"]; string xmdjrq = context.Request.Params["xmdjrq"]; string xmmc = context.Request.Params["xmmc"]; StringBuilder str = new StringBuilder(); try { str.Append("["); DataTable dt = BLL.GetXmxx(ssdq, xmdjrq, xmmc); foreach (DataRow row in dt.Rows) { str.Append("{"); str.AppendFormat("\"title\":\"{0}\",\"point\":\"{1}|{2}\",\"xmmc\":\"{3}\",\"jsdw\":\"{4}\",\"sgdw\":\"{5}\",\"jldw\":\"{6}\",\"kcdw\":\"{7}\",\"sjdw\":\"{8}\",\"kgrq\":\"{9}\",\"jsgm\":\"{10}\",\"xmztz\":\"{11}万元\",\"prjNum\":\"{12}\",\"isSgbz\":{13},\"PKID\":\"{14}\"", "工程项目概要信息", row["jd"], row["wd"], row["PrjName"].ToString().Replace("\"", ""), row["BuildCorpName"] , row["SgzcbCorpNames"] == DBNull.Value ? "" : row["SgzcbCorpNames"].ToString2().Trim(';') , row["JLCorpNames"] == DBNull.Value ? "" : row["JLCorpNames"].ToString2().Trim(';') , row["EconCorpNames"] == DBNull.Value ? "" : row["EconCorpNames"].ToString2().Trim(';') , row["DesignCorpNames"] == DBNull.Value ? "" : row["DesignCorpNames"].ToString2().Trim(';') , row["BDate"] == DBNull.Value ? "" : row["BDate"].ToDateTime().ToString("yyyy-MM-dd") , row["PrjSize"], row["AllInvest"] == DBNull.Value ? "0" : row["AllInvest"].ToString2() , row["PrjNum"], row["isSgbz"].ToInt32(0), row["PKID"]); str.Append("},"); } return(str.ToString().TrimEnd(',') + "]"); } catch (Exception ex) { str.Append(ex.Message); } return(str.ToString()); }