/// <summary> /// 退出系统 /// </summary> /// <param name="context"></param> public void Logout(HttpContext context) { //修改登录状态 if (context.Session["user_id"] != null) { Model.T_User t_user = bll_user.GetModel(Convert.ToInt32(context.Session["user_id"])); t_user.isOnline = 0; bll_user.Update(t_user); } context.Session["user_name"] = ""; context.Session["user_id"] = ""; //清空session //context.Session.Clear(); message.flag = true; message.msg = "成功退出系统!"; message.msg = context.Session["user_id"].ToString(); context.Response.Write(JsonHelper.Object2Json <Message>(message)); }
private void Query(HttpContext context) { string name, year, administratorArea, isDeleted, isSubmited, batchTypeId, planTypeId, startTime, endTime, order, sort, oderby; //=============================================================== //获取查询条件:【用户名,开始时间,结束时间】 name = year = administratorArea = isDeleted = isSubmited = batchTypeId = planTypeId = 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["isDeleted"]) { isDeleted = context.Request.QueryString["isDeleted"].ToString().Trim(); } if (null != context.Request.QueryString["isSubmited"]) { isSubmited = context.Request.QueryString["isSubmited"].ToString().Trim(); } if (null != context.Request.QueryString["planTypeId"]) { planTypeId = context.Request.QueryString["planTypeId"].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 (isSubmited != "") { strWhere.AppendFormat(" isSubmited = '{0}' and ", isSubmited); } if (year != "" && year != "0") { strWhere.AppendFormat(" year = '{0}' and ", year); } if (administratorArea != "") { strWhere.AppendFormat(" administratorArea = '{0}' and ", administratorArea); } if (planTypeId != "" && planTypeId != "0") { strWhere.AppendFormat(" planTypeId = '{0}' and ", planTypeId); } if (isDeleted != "" && isDeleted != "-1") { strWhere.AppendFormat(" isDeleted = '{0}' and ", isDeleted); } if (batchTypeId != "") //获取该批次应该获取哪几种类型的计划 { string planTypeIds = ""; if (batchTypeId == "1" || batchTypeId == "2") { planTypeIds = "1,2,3,4"; } else if (batchTypeId == "3") { //独立选址批次 planTypeIds = "5"; // } else if (batchTypeId == "4") {//增减挂钩批次 planTypeIds = "6"; } if (batchTypeId != "") { strWhere.AppendFormat(" planTypeId in ({0}) and ", planTypeIds); } } if (startTime != "") { strWhere.AppendFormat(" create_time >= '{0}' and ", startTime); } if (endTime != "") { strWhere.AppendFormat(" create_time <= '{0}' and ", endTime); } //删除多余的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_plan.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("planTypeName", typeof(System.String)); ds.Tables[0].Columns.Add("createUserName", typeof(System.String)); ds.Tables[0].Columns.Add("isUsed", typeof(System.String)); foreach (DataRow dr in ds.Tables[0].Rows) { int administratorAreaId = 0; int planTypeId1 = 0; int userId = 0; if (utils.BusinessHelper.IsPlanHasUsed(Convert.ToInt32(dr["id"]))) { dr["isUsed"] = true; } else { dr["isUsed"] = false; } if (dr["administratorArea"].ToString() != "" && dr["administratorArea"] != null) { administratorAreaId = Convert.ToInt32(dr["administratorArea"].ToString()); } if (dr["planTypeId"].ToString() != "" && dr["planTypeId"] != null) { planTypeId1 = Convert.ToInt32(dr["planTypeId"].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_PlanType t_plan_type = bll_plan_type.GetModel(planTypeId1); if (t_plan_type != null) { dr["planTypeName"] = t_plan_type.name; } else { dr["planTypeName"] = ""; } Model.T_User t_user = bll_user.GetModel(userId); if (t_user != null) { dr["createUserName"] = t_user.name; } else { dr["createUserName"] = ""; } } int count = bll_plan.GetRecordCount(strWhere.ToString()); //获取条数 string strJson = JsonHelper.Dataset2Json(ds, count); //DataSet数据转化为Json数据 context.Response.Write(strJson); //返回给前台页面 }
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, id_role, name, birthday, telephone, address, create_time, remarks, password; id = id_role = name = birthday = telephone = address = create_time = remarks = password = ""; //获取前台传来的值 if (null != context.Request.QueryString["id"]) { id = context.Request.QueryString["id"].ToString().Trim(); } if (null != context.Request.QueryString["id_role"]) { id_role = context.Request.QueryString["id_role"].ToString().Trim(); } if (null != context.Request.QueryString["name"]) { name = context.Request.QueryString["name"].ToString().Trim(); } if (null != context.Request.QueryString["birthday"]) { birthday = context.Request.QueryString["birthday"].ToString().Trim(); } if (null != context.Request.QueryString["telephone"]) { telephone = context.Request.QueryString["telephone"].ToString().Trim(); } if (null != context.Request.QueryString["address"]) { address = context.Request.QueryString["address"].ToString().Trim(); } if (null != context.Request.QueryString["password"]) { password = context.Request.QueryString["password"].ToString().Trim(); } if (null != context.Request.QueryString["create_time"]) { create_time = context.Request.QueryString["create_time"].ToString().Trim(); } if (null != context.Request.QueryString["remarks"]) { remarks = context.Request.QueryString["remarks"].ToString().Trim(); } //获取角色信息 T_Role t_role = new T_Role(); if (id_role != "") { t_role = bll_role.GetModel(Convert.ToInt32(id_role)); } Model.T_User t_user = new Model.T_User(); if (method == "add") { //检查用户名是否已经存在 DataSet ds = bll_user.GetList(" name='" + name + "'"); if (ds.Tables[0].Rows.Count > 0) { message.flag = false; message.msg = "用户名已经存在"; } else { t_user.name = name; t_user.password = Util.GetMD5(password); if (birthday != "") { t_user.birthday = Convert.ToDateTime(birthday); } t_user.telephone = telephone; t_user.address = address; t_user.create_time = DateTime.Now; t_user.remarks = remarks; int n = bll_user.Add(t_user); //插入用户角色信息 Model.T_User_Role t_user_role = new T_User_Role(); if (id_role != "") { t_user_role.id_role = Convert.ToInt32(id_role); } t_user_role.id_user = n; bll_user_role.Add(t_user_role); if (n > 0) { message.flag = true; message.msg = "添加成功"; } else { message.flag = false; message.msg = "添加失败"; } } } else { t_user = bll_user.GetModel(Convert.ToInt32(id)); //检查用户名是否已经存在 DataSet ds = bll_user.GetList(" name='" + name + "' and id != " + id); if (ds.Tables[0].Rows.Count > 0) { message.flag = false; message.msg = "用户名已经存在"; } else { t_user.name = name; t_user.password = Util.GetMD5(password); if (birthday != "") { t_user.birthday = Convert.ToDateTime(birthday); } t_user.telephone = telephone; t_user.address = address; t_user.create_time = DateTime.Now; t_user.remarks = remarks; bool flag = bll_user.Update(t_user); //删除旧的在插入新的 bll_user_role.DeleteByWhere(" id_user = "******"") { t_user_role.id_role = Convert.ToInt32(id_role); } t_user_role.id_user = Convert.ToInt32(id); bll_user_role.Add(t_user_role); 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 Query(HttpContext context) { string name, year, administratorArea, startTime, endTime, order, sort, oderby; //=============================================================== //获取查询条件:【用户名,开始时间,结束时间】 name = year = administratorArea = 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["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 (startTime != "") { strWhere.AppendFormat(" create_time >= '{0}' and ", startTime); } if (endTime != "") { strWhere.AppendFormat(" create_time <= '{0}' and ", endTime); } //删除多余的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_verif.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("createUserName", typeof(System.String)); foreach (DataRow dr in ds.Tables[0].Rows) { int administratorAreaId = 0; int userId = 0; if (dr["administratorArea"].ToString() != "" && dr["administratorArea"] != null) { administratorAreaId = Convert.ToInt32(dr["administratorArea"].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_User t_user = bll_user.GetModel(userId); if (t_user != null) { dr["createUserName"] = t_user.name; } else { dr["createUserName"] = ""; } } int count = bll_verif.GetRecordCount(strWhere.ToString()); //获取条数 string strJson = JsonHelper.Dataset2Json(ds, count); //DataSet数据转化为Json数据 context.Response.Write(strJson); //返回给前台页面 }