private void Query(HttpContext context)
{
string name, year, administratorArea, isDeleted, planTypeId, startTime, endTime, order, sort, oderby;
//===============================================================
//获取查询条件:【用户名,开始时间，结束时间】
name = year = administratorArea = isDeleted = planTypeId = startTime = endTime = order = sort = oderby = "";
//获取前台传来的值
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["planTypeId"])
{
planTypeId = context.Request.QueryString["planTypeId"].ToString().Trim();
}
if (null != context.Request.QueryString["isDeleted"])
{
isDeleted = context.Request.QueryString["isDeleted"].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(" L.name like '%{0}%' and ", name);
}
if (year != "")
{
strWhere.AppendFormat(" T.year = '{0}' and ", year);
}
if (administratorArea != "")
{
strWhere.AppendFormat(" T.administratorArea = '{0}' and ", administratorArea);
}
if (planTypeId != "")
{
strWhere.AppendFormat(" planTypeId = '{0}' and ", planTypeId);
}
if (startTime != "")
{
strWhere.AppendFormat(" create_time >= '{0}' and ", startTime);
}
if (endTime != "")
{
strWhere.AppendFormat(" create_time <= '{0}' and ", endTime);
}
if (isDeleted != "" && isDeleted != "-1")
{
strWhere.AppendFormat(" isDeleted = '{0}' and ", isDeleted);
}
//删除多余的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_levy.GetListByPage(strWhere.ToString(), oderby, (page - 1) * pageRows + 1, page * pageRows);
//插入其他字段，行政区administratorArea、批次类型batchTypeName、创建人createUserName
ds.Tables[0].Columns.Add("administratorAreaName", typeof(System.String));
ds.Tables[0].Columns.Add("batchTypeName", typeof(System.String));
ds.Tables[0].Columns.Add("batchName", typeof(System.String));
ds.Tables[0].Columns.Add("createUserName", typeof(System.String));
foreach (DataRow dr in ds.Tables[0].Rows)
{
int batchTypeId = 0; int administratorAreaId = 0;
int batchId = 0;
int userId = 0;
if (dr["administratorArea"].ToString() != "" && dr["administratorArea"] != null)
{
administratorAreaId = Convert.ToInt32(dr["administratorArea"].ToString());
}
if (dr["batchTypeId"].ToString() != "" && dr["batchTypeId"] != null)
{
batchTypeId = Convert.ToInt32(dr["batchTypeId"].ToString());
}
if (dr["batchId"].ToString() != "" && dr["batchId"] != null)
{
batchId = Convert.ToInt32(dr["batchId"].ToString());
}
//if (dr["landblockId"].ToString() != "" && dr["landblockId"] != null)
//{
// landblockId = Convert.ToInt32(dr["landblockId"].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_BatchType t_batch_type = bll_batch_type.GetModel(batchTypeId);
if (t_batch_type != null)
{
dr["batchTypeName"] = t_batch_type.name;
}
else
{
dr["batchTypeName"] = "";
}
Model.T_Batch t_batch = bll_batch.GetModel(batchId);
if (t_batch != null)
{
dr["batchName"] = t_batch.name;
}
else
{
dr["batchName"] = "";
}
//Model.T_LandBlock t_land_block = bll_land_block.GetModel(landblockId);
//if (t_land_block != null) { dr["landBlockName"] = t_land_block.name; } else { dr["landBlockName"] = ""; }
Model.T_User t_user = bll_user.GetModel(userId);
if (t_user != null)
{
dr["createUserName"] = t_user.name;
}
else
{
dr["createUserName"] = "";
}
}
int count = bll_levy.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_BatchType model = new Model.T_BatchType();
model.name = name;
model.des = des;
int n = bll_batch_type.Add(model);
if (n > 0)
{
message.flag = true;
message.msg = "添加成功";
}
else
{
message.flag = false;
message.msg = "添加失败";
}
}
else
{
T_BatchType model = bll_batch_type.GetModel(Convert.ToInt32(id));
model.name = name;
model.des = des;
bool flag = bll_batch_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_BatchType model = new Model.T_BatchType();
model.name = name;
model.des = des;
int n = bll_batch_type.Add(model);
if (n > 0)
{
message.flag = true;
message.msg = "添加成功";
}
else
{
message.flag = false;
message.msg = "添加失败";
}
}
else
{
T_BatchType model = bll_batch_type.GetModel(Convert.ToInt32(id));
model.name = name;
model.des = des;
bool flag = bll_batch_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);
}
