private void Query(HttpContext context)
{
string batchTypeId, name, year, administratorArea, isSubmited, isDeleted, typeId, startTime, endTime, order, sort, oderby;
//===============================================================
//获取查询条件:【用户名,开始时间，结束时间】
batchTypeId = name = year = administratorArea = isDeleted = typeId = isSubmited = startTime = endTime = order = sort = oderby = "";
//获取前台传来的值
if (null != context.Request.QueryString["batchTypeId"])
{
batchTypeId = context.Request.QueryString["batchTypeId"].ToString().Trim();
}
if (null != context.Request.QueryString["name"])
{
name = context.Request.QueryString["name"].ToString().Trim();
}
if (null != context.Request.QueryString["year"])
{
year = context.Request.QueryString["year"].ToString().Trim();
}
if (null != context.Request.QueryString["administratorArea"])
{
administratorArea = context.Request.QueryString["administratorArea"].ToString().Trim();
}
if (null != context.Request.QueryString["isSubmited"])
{
isSubmited = context.Request.QueryString["isSubmited"].ToString().Trim();
}
if (null != context.Request.QueryString["isDeleted"])
{
isDeleted = context.Request.QueryString["isDeleted"].ToString().Trim();
}
if (null != context.Request.QueryString["typeId"])
{
typeId = context.Request.QueryString["typeId"].ToString().Trim();
}
if (null != context.Request.QueryString["startTime"])
{
startTime = context.Request.QueryString["startTime"].ToString().Trim();
}
if (null != context.Request.QueryString["endTime"])
{
endTime = context.Request.QueryString["endTime"].ToString().Trim();
}
//================================================================
//获取分页和排序信息：页大小，页码，排序方式，排序字段
int pageRows, page;
pageRows = 10;
page = 1;
if (null != context.Request.QueryString["rows"])
{
pageRows = int.Parse(context.Request.QueryString["rows"].ToString().Trim());
}
if (null != context.Request.QueryString["page"])
{
page = int.Parse(context.Request.QueryString["page"].ToString().Trim());
}
if (null != context.Request.QueryString["sort"])
{
order = context.Request.QueryString["sort"].ToString().Trim();
}
if (null != context.Request.QueryString["order"])
{
sort = context.Request.QueryString["order"].ToString().Trim();
}
//===================================================================
//组合查询语句：条件+排序
StringBuilder strWhere = new StringBuilder();
strWhere.Append(" 1=1 and");
if (name != "")
{
strWhere.AppendFormat(" name like '%{0}%' and ", name);
}
if (year != "")
{
strWhere.AppendFormat(" year = '{0}' and ", year);
}
if (administratorArea != "")
{
strWhere.AppendFormat(" administratorArea = '{0}' and ", administratorArea);
}
if (isSubmited != "")
{
strWhere.AppendFormat(" isSubmited = '{0}' and ", isSubmited);
}
if (isDeleted != "" && isDeleted != "-1")
{
strWhere.AppendFormat(" isDeleted = '{0}' and ", isDeleted);
}
if (typeId != "")
{
strWhere.AppendFormat(" typeId = '{0}' and ", typeId);
}
if (startTime != "")
{
strWhere.AppendFormat(" create_time >= '{0}' and ", startTime);
}
if (endTime != "")
{
strWhere.AppendFormat(" create_time <= '{0}' and ", endTime);
}
if (batchTypeId != "")
{ //获取该批次应该获取哪几种类型的计划
string dsTypeIds = "";
if (batchTypeId == "1" || batchTypeId == "2" || batchTypeId == "3") //可以添加土地复垦、异地购买
{
dsTypeIds = "1,2";
}
else if (batchTypeId == "4") //只能添加增减挂钩拆旧
{ //增减挂钩批次
dsTypeIds = "3";
}
if (batchTypeId != "")
{
strWhere.AppendFormat(" typeId in ({0}) and ", dsTypeIds);
}
}
//删除多余的and
int startindex = strWhere.ToString().LastIndexOf("and");//获取最后一个and的位置
if (startindex >= 0)
{
strWhere.Remove(startindex, 3);//删除多余的and关键字
}
if (sort != "" && order != "")
{
//strWhere.AppendFormat(" order by {0} {1}", sort, order);//添加排序
oderby = order + " " + sort;
}
//调用分页的GetList方法
DataSet ds = bll_demand_supply_balance.GetListByPage(strWhere.ToString(), oderby, (page - 1) * pageRows + 1, page * pageRows);
//插入其他字段，行政区administratorArea、计划类型planTypeName、创建人createUserName
ds.Tables[0].Columns.Add("administratorAreaName", typeof(System.String));
ds.Tables[0].Columns.Add("typeName", typeof(System.String));
ds.Tables[0].Columns.Add("createUserName", typeof(System.String));
ds.Tables[0].Columns.Add("usedAgriArea", typeof(System.String));
ds.Tables[0].Columns.Add("remainAgriArea", typeof(System.String));
ds.Tables[0].Columns.Add("usedArabArea", typeof(System.String));
ds.Tables[0].Columns.Add("remainArabArea", typeof(System.String));
ds.Tables[0].Columns.Add("isUsed", typeof(System.String));
foreach (DataRow dr in ds.Tables[0].Rows)
{
int administratorAreaId = 0;
int demandSupplyBalanceTypeId = 0;
decimal usedAgriArea = 0;
decimal usedArabArea = 0;
int userId = 0;
if (utils.BusinessHelper.IsBalanceHasUsed(Convert.ToInt32(dr["id"])))
{
dr["isUsed"] = true;
}
else
{
dr["isUsed"] = false;
}
List <Model.T_Batch_Demand_Supply_Balance> list_batch_balance = bll_batch_balance.GetModelList(" dsBalanceId = " + dr["id"].ToString());
if (list_batch_balance.Count > 0)
{
foreach (Model.T_Batch_Demand_Supply_Balance t_batch_balance in list_batch_balance)
{
usedAgriArea += (decimal)t_batch_balance.agriArea;
usedArabArea += (decimal)t_batch_balance.arabArea;
}
dr["usedAgriArea"] = usedAgriArea;
dr["remainAgriArea"] = Convert.ToDecimal(dr["agriArea"]) - usedAgriArea;
dr["usedArabArea"] = usedArabArea;
dr["remainArabArea"] = Convert.ToDecimal(dr["arabArea"]) - usedArabArea;
}
else
{
dr["usedAgriArea"] = 0;
dr["remainAgriArea"] = Convert.ToDecimal(dr["agriArea"]);
dr["usedArabArea"] = 0;
dr["remainArabArea"] = Convert.ToDecimal(dr["arabArea"]);
}
if (dr["administratorArea"].ToString() != "" && dr["administratorArea"] != null)
{
administratorAreaId = Convert.ToInt32(dr["administratorArea"].ToString());
}
if (dr["typeId"].ToString() != "" && dr["typeId"] != null)
{
demandSupplyBalanceTypeId = Convert.ToInt32(dr["typeId"].ToString());
}
if (dr["userId"].ToString() != "" && dr["userId"] != null)
{
userId = Convert.ToInt32(dr["userId"].ToString());
}
Model.T_AdministratorArea t_administrator_area = bll_administrator_area.GetModel(administratorAreaId);
if (t_administrator_area != null)
{
dr["administratorAreaName"] = t_administrator_area.name;
}
else
{
dr["administratorAreaName"] = "";
}
Model.T_DemandSupplyBalanceType t_demand_supply_balance_type = bll_demand_supplay_balance_type.GetModel(demandSupplyBalanceTypeId);
if (t_demand_supply_balance_type != null)
{
dr["typeName"] = t_demand_supply_balance_type.name;
}
else
{
dr["typeName"] = "";
}
Model.T_User t_user = bll_user.GetModel(userId);
if (t_user != null)
{
dr["createUserName"] = t_user.name;
}
else
{
dr["createUserName"] = "";
}
}
int count = bll_demand_supply_balance.GetRecordCount(strWhere.ToString()); //获取条数
string strJson = JsonHelper.Dataset2Json(ds, count); //DataSet数据转化为Json数据
context.Response.Write(strJson); //返回给前台页面
}
private void AddOrModify(HttpContext context)
{
//===============================================================
//获取字段:【用户name】
string id, name, des;
id = name = des = "";
if (null != context.Request.QueryString["id"])
{
id = context.Request.QueryString["id"].ToString().Trim();
}
if (null != context.Request.QueryString["name"])
{
name = context.Request.QueryString["name"].ToString().Trim();
}
if (null != context.Request.QueryString["des"])
{
des = context.Request.QueryString["des"].ToString().Trim();
}
if (id == "")
{
Model.T_DemandSupplyBalanceType model = new Model.T_DemandSupplyBalanceType();
model.name = name;
model.des = des;
int n = bll_demand_supply_balance_type.Add(model);
if (n > 0)
{
message.flag = true;
message.msg = "添加成功";
}
else
{
message.flag = false;
message.msg = "添加失败";
}
}
else
{
T_DemandSupplyBalanceType model = bll_demand_supply_balance_type.GetModel(Convert.ToInt32(id));
model.name = name;
model.des = des;
bool flag = bll_demand_supply_balance_type.Update(model);
if (flag)
{
message.flag = true;
message.msg = "修改成功";
}
else
{
message.flag = false;
message.msg = "修改失败";
}
}
String jsonString = JsonHelper.Object2Json <Message>(message);
context.Response.Write(jsonString);
}
private void AddOrModify(HttpContext context)
{
//===============================================================
//获取字段:【用户name】
string id, name, des;
id = name = des = "";
if (null != context.Request.QueryString["id"])
{
id = context.Request.QueryString["id"].ToString().Trim();
}
if (null != context.Request.QueryString["name"])
{
name = context.Request.QueryString["name"].ToString().Trim();
}
if (null != context.Request.QueryString["des"])
{
des = context.Request.QueryString["des"].ToString().Trim();
}
if (id == "")
{
Model.T_DemandSupplyBalanceType model = new Model.T_DemandSupplyBalanceType();
model.name = name;
model.des = des;
int n = bll_demand_supply_balance_type.Add(model);
if (n > 0)
{
message.flag = true;
message.msg = "添加成功";
}
else
{
message.flag = false;
message.msg = "添加失败";
}
}
else
{
T_DemandSupplyBalanceType model = bll_demand_supply_balance_type.GetModel(Convert.ToInt32(id));
model.name = name;
model.des = des;
bool flag = bll_demand_supply_balance_type.Update(model);
if (flag)
{
message.flag = true;
message.msg = "修改成功";
}
else
{
message.flag = false;
message.msg = "修改失败";
}
}
String jsonString = JsonHelper.Object2Json<Message>(message);
context.Response.Write(jsonString);
}
