protected override string process(Type domain_type, Newtonsoft.Json.Linq.JObject user_params) { string api = this.Request["api"] as string; if (api == "query") { string 状态 = this.Request["状态"] as string; charming.data.TableDataGateway db = new charming.data.TableDataGateway(); charming.data.Table 层_list = new charming.data.Table(); charming.data.Table 状态_list = new charming.data.Table(); string sql = "select distinct substring(结构号,2,1) + '-' + substring(结构号,3,1) as 层 from v_结构号资料全" + " where 状态=@1 or @1='-1'"; new charming.data.TableDataGateway().Query(层_list, sql, 状态); sql = //"select 结构号,状态 from QC_结构号" //"select A.结构号,A.结构面积,A.状态,B.门牌号 from QC_结构号 A left outer join QC_结构号列表 B on(A.结构号= B.结构号)" //+ " where 状态=@1 or @1='all'"; "select * from v_结构号资料全" + " where 状态=@1 or @1='-1'"; new charming.data.TableDataGateway().Query(状态_list, sql, 状态); 查询返回包 result = new 查询返回包(); result.层_list = 层_list; result.状态_list = 状态_list; return(Serialize(result)); } return(null); }
protected override string process(Type domain_type, Newtonsoft.Json.Linq.JObject user_params) { string api = this.Request["api"] as string; charming.data.TableDataGateway db = new charming.data.TableDataGateway(); if (api == "all") { charming.data.Table t = new charming.data.Table(); string sql = "select * from QC_企业介绍"; db.Query(t, sql); return(Serialize(t)); } if (api == "byID") { string id = this.Request["id"] as string; charming.data.Table t = new charming.data.Table(); string sql = "select * from QC_企业介绍 where object_id=@1"; db.Query(t, sql, id); 企业信息返回包 result = new 企业信息返回包(); result.QC_企业介绍 = t; result.全景地图 = db.ExecuteScalar("select 全景地图 from QC_客户资料 where object_id=@1", t[0].GetDataRow()["客户ID"]) as string; return(Serialize(result)); } if (api == "top-n") { int n = int.Parse(this.Request["n"]); charming.data.Table t = new charming.data.Table(); string sql = "select top " + n.ToString() + " * from QC_企业介绍"; db.Query(t, sql); return(Serialize(t)); } if (api == "query") { string key = this.Request["key"] as string; charming.data.Table t = new charming.data.Table(); string sql = "select * from QC_企业介绍" + " where 主营业务 like @1 or 客户名称 like @1 or 企业简介 like @1"; db.Query(t, sql, "%" + key + "%"); return(Serialize(t)); } return(null); }