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