protected void Page_Load(object sender, EventArgs e)
{
//获取BlockModule和BlockType的中文名
if (BlockModule == 0)
{
BlockModuleName = "系统";
}
else if (BlockModule == 1)
{
BlockModuleName = "用户";
}
if (BlockType == 0)
{
BlockModuleName = "白名单";
}
else if (BlockType == 1)
{
BlockModuleName = "黑名单";
}
//检查登录
ManageHelper.CheckAdminLogin();
//管理权限
// ManageHelper.CheckAdminPower("system_adminipblockmanage");
if (PageRequest.GetString("act") == "SaveData")
{
Save();
}
}
private void SendTest()
{
var ret = ManageHelper.MailSend(PageRequest.GetString("EmailTest"), Sys.Kernel.Software.Name + " 的测试邮件。", "这是一封来之 " + Sys.Kernel.Software.ChineseName + " 重要的测试邮件，发送时间：" + DateTime.Now.ToString() + "。");
Response.Write(ret == "ok" ? "yes" : Utils.RemoveHtmlContent(ret));
Response.End();
}
private void updatePwd()
{
var result = new Account().AccountUpdate(Account.GetLoginUserID(), Utils.MD5(PageRequest.GetString("pwd")));
Response.Write(result > 0 ? "yes" : "no");
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
var methodName = PageRequest.GetString("method");
var type = this.GetType();
var method = type.GetMethod(methodName);
if (method == null) throw new Exception("method is null");
method.Invoke(this, null);
}
private void Add()
{
ManageHelper.CheckAdminPower("system_adminroleadd");
ModelRole.RoleFlag = PageRequest.GetString("RoleFlag");
ModelRole.RoleName = PageRequest.GetString("RoleName");
ModelRole.Note = PageRequest.GetString("Note");
BllSysRole.Add(ModelRole);
Response.Write("yes");
Response.End();
}
/// <summary>
/// 查询
/// </summary>
public void SearchData()
{
//查询条件
var key = Utils.SqlStringFormat(PageRequest.GetString("key"), 2);
var userType = PageRequest.GetString("userType");
//分页
var pageIndex = PageRequest.GetInt("pageIndex", 1) + 1;
var pageSize = PageRequest.GetInt("pageSize", 1);
//字段排序
var sortField = PageRequest.GetString("sortField");
var sortOrder = PageRequest.GetString("sortOrder");
var order = "";
if (String.IsNullOrEmpty(sortField) == false)
{
if (sortOrder != "desc")
{
sortOrder = "asc";
}
order = " u." + sortField + " " + sortOrder;
}
else
{
order += " u.createtime desc";
}
var strWhere = "1=1";
if (!string.IsNullOrEmpty(userType))
{
strWhere += " and u.RoleId=" + userType;
}
if (!string.IsNullOrEmpty(key))
{
strWhere += " and charIndex('" + key + "',u.UserName) > 0";
}
if (pageSize == 1)
{
pageSize = 100;
}
var dt = new Sys.BLL.UserInfo().GetListForMoreTable(pageSize, pageIndex, strWhere, order);
var dataAll = MyDBUtils.DataTable2ArrayList(dt);
var result = new Hashtable();
result["data"] = dataAll;
var total = new Sys.BLL.Common().GetCount("UserInfo u", strWhere);
result["total"] = total;
//JSON
var json = PluSoft.Utils.JSON.Encode(result);
Response.Write(json);
}
/// <summary>
/// 查询具体的信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public void GetView()
{
var tableName = PageRequest.GetString("tableName");
var bll = new Common();
var dt = bll.DatabaseTable(tableName).Tables[0];
//var data = MyDBUtils.DataTable2ArrayList(dt);
//var user = data.Count > 0 ? (Hashtable)data[0] : null;
var json = PluSoft.Utils.JSON.Encode(dt);
Response.Write(json);
}
/// <summary>
/// 查询
/// </summary>
///
public void SearchData()
{
//查询条件
var key = Utils.SqlStringFormat(PageRequest.GetString("key"), 2);
var begtime = Utils.SqlStringFormat(PageRequest.GetString("begtime"), 2);
//分页
var pageIndex = PageRequest.GetInt("pageIndex", 1);
var pageSize = PageRequest.GetInt("pageSize", 1);
//字段排序
var sortField = PageRequest.GetString("sortField");
var sortOrder = PageRequest.GetString("sortOrder");
var order = "";
if (String.IsNullOrEmpty(sortField) == false)
{
if (sortOrder != "desc")
{
sortOrder = "asc";
}
order = " " + sortField + " " + sortOrder;
}
else
{
order += " createtime desc";
}
var strWhere = "1=1";
if (key != "")
{
strWhere += " and charIndex('" + key + "',NewsTitle) > 0";
}
if (begtime.Length > 0)
{
strWhere += " and DATEDIFF(day,'" + DateTime.Parse(begtime) + "',createtime)=0";
}
var dt = BllNews.GetTable(pageSize, pageIndex, strWhere, order);
var dataAll = MyDBUtils.DataTable2ArrayList(dt);
var result = new Hashtable();
result["data"] = dataAll;
var total = new Common().GetCount("News", strWhere);
result["total"] = total;
var json = PluSoft.Utils.JSON.Encode(dataAll);
Response.Write(json);
}
/// <summary>
/// 查询
/// </summary>
public void SearchData()
{
//查询条件
var key = Utils.SqlStringFormat(PageRequest.GetString("key"), 2);
//分页
var pageIndex = PageRequest.GetInt("pageIndex", 1);
var pageSize = PageRequest.GetInt("pageSize", 1);
//字段排序
var sortField = PageRequest.GetString("sortField");
var sortOrder = PageRequest.GetString("sortOrder");
var order = "";
if (String.IsNullOrEmpty(sortField) == false)
{
if (sortOrder != "desc")
{
sortOrder = "asc";
}
order = " " + sortField + " " + sortOrder;
}
else
{
order += " createtime desc";
}
var strWhere = "";
if (key != "")
{
strWhere += "charIndex('" + key + "',FlagName) > 0";
}
if (pageSize == 1)
{
pageSize = 1000;
}
var dt = new Sys.BLL.AdminFlag().GetTable(-1, -1, strWhere, order);
var dataAll = MyDBUtils.DataTable2ArrayList(dt);
var result = new Hashtable();
result["data"] = dataAll;
//var total = new Sys.BLL.Common().GetCount("Sys_Flag", strWhere);
//result["total"] = total;
//JSON
var json = PluSoft.Utils.JSON.Encode(dataAll);
Response.Write(json);
//var tempstring = "[{\"FlagId\": \"1\",\"FlagName\": \"项目范围规划\",\"Duration\": 8,\"Start\": \"2007-01-01T00:00:00\",\"Finish\": \"2007-01-10T00:00:00\",\"PercentComplete\": 0,\"Summary\": 1,\"Critical\": 0,\"Milestone\": 0,\"PredecessorLink\": [],\"ParentId\": -1},{\"FlagId\": \"2\",\"FlagName\": \"确定项目范围\",\"Duration\": 1,\"Start\": \"2007-01-01T00:00:00\",\"Finish\": \"2007-01-01T23:23:59\",\"PercentComplete\": 30,\"Summary\": 0,\"Critical\": 0,\"Milestone\": 0,\"PredecessorLink\": [],\"ParentId\": \"1\"}]";
//Response.Write(tempstring);
}
/// <summary>
/// 查询
/// </summary>
public void SearchDatat()
{
//查询条件
var key = Utils.SqlStringFormat(PageRequest.GetString("key"), 2);
//分页
var pageIndex = PageRequest.GetInt("pageIndex", 1);
var pageSize = PageRequest.GetInt("pageSize", 1);
//字段排序
var sortField = PageRequest.GetString("sortField");
var sortOrder = PageRequest.GetString("sortOrder");
var order = "";
if (String.IsNullOrEmpty(sortField) == false)
{
if (sortOrder != "desc")
{
sortOrder = "asc";
}
order = " " + sortField + " " + sortOrder;
}
else
{
order += " OrderID";
}
const string strWhere = "IsNav=1";
var dt = new AdminFlag().GetTable(-1, -1, strWhere, order);
var tempDt = dt.Clone();
foreach (DataRow model in dt.Rows)
{
if (ManageHelper.CheckAdminHavePower(model["Flag"].ToString()))
{
tempDt.Rows.Add(model.ItemArray);
}
}
var dataAll = MyDBUtils.DataTable2ArrayList(tempDt);
var result = new Hashtable();
result["data"] = dataAll;
var json = PluSoft.Utils.JSON.Encode(dataAll);
Response.Write(json);
}
/// <summary>
/// 订单分配查询，
/// </summary>
///
public void SearchDataDistrbution()
{
Loginadmin = BllAdmin.GetModel(Account.GetLoginUserID());
if (Loginadmin == null)
{
return;
}
//查询条件
var key = Utils.SqlStringFormat(PageRequest.GetString("key"), 2);
//分页
var pageIndex = PageRequest.GetInt("pageIndex", 1);
var pageSize = PageRequest.GetInt("pageSize", 1);
//字段排序
var sortField = PageRequest.GetString("sortField");
var sortOrder = PageRequest.GetString("sortOrder");
var order = "";
if (String.IsNullOrEmpty(sortField) == false)
{
if (sortOrder != "desc")
{
sortOrder = "asc";
}
order = " " + sortField + " " + sortOrder;
}
else
{
order += " createtime desc";
}
var strWhere = "1=1";
if (key != "")
{
strWhere += " and charIndex('" + key + "',UserName) > 0";
}
// strWhere += " and charIndex('" + Loginadmin.UserId + "',parentUserIDs) > 0 or UserId=" + Loginadmin.UserId + "";
strWhere += " and RoleIDs='89'";
var dt = new Admin().GetTable(-1, -1, strWhere, order);
var dataAll = MyDBUtils.DataTable2ArrayList(dt);
var result = new Hashtable();
result["data"] = dataAll;
var json = PluSoft.Utils.JSON.Encode(dataAll);
Response.Write(json);
}
/// <summary>
/// 更新信息
/// </summary>
public void SaveData()
{
var json = Request["data"];
var rows = (ArrayList)PluSoft.Utils.JSON.Decode(json);
foreach (Hashtable row in rows)
{
var id = row["ID"] != null ? row["ID"].ToString() : "";
//根据记录状态，进行不同的增加、删除、修改操作
var state = row["_state"] != null ? row["_state"].ToString() : "";
if (state == "added" || id == "") //新增：id为空，或_state为added
{
model.Abstract = row["Abstract"] == null ? "" : row["Abstract"].ToString();
model.Content = PageRequest.GetString("Content");
model.CreateIp = PageRequest.GetIP();
model.CreateTime = DateTime.Now;
model.NewsTitle = row["NewsTitle"] == null ? "" : row["NewsTitle"].ToString();
model.Publisher = Admin.GetRealName();
model.Source = row["Source"] == null ? "" : row["Source"].ToString();
model.TotalClick = 0;
model.TypeId = Utils.StrToInt(row["TypeId"], 0);
model.UpdateIp = model.CreateIp;
model.UpdateTime = model.CreateTime;
BllNews.Add(model);
}
else if (state == "modified" || state == "") //更新：_state为空或modified
{
model = BllNews.GetModel(Utils.StrToInt(row["ID"], 0));
if (model != null)
{
#region 基础字段
model.Abstract = row["Abstract"] == null ? "" : row["Abstract"].ToString();
model.Content = PageRequest.GetString("Content");
model.NewsTitle = row["NewsTitle"] == null ? "" : row["NewsTitle"].ToString();
model.Publisher = row["Publisher"] == null ? "" : row["Publisher"].ToString();
model.Source = row["Source"] == null ? "" : row["Source"].ToString();
model.TypeId = Utils.StrToInt(row["TypeId"], 0);
model.UpdateIp = PageRequest.GetIP();
model.UpdateTime = DateTime.Now;
#endregion
BllNews.Update(model);
}
}
}
}
private void EditSave()
{
ManageHelper.CheckAdminPower("system_adminroleedit");
Edit();
if (ModelRole != null)
{
ModelRole.RoleFlag = PageRequest.GetString("RoleFlag");
ModelRole.RoleName = PageRequest.GetString("RoleName");
ModelRole.Note = PageRequest.GetString("Note");
BllSysRole.Update(ModelRole);
Response.Write("yes");
Response.End();
}
}
public void SearchData()
{
//查询条件
int BlockType = PageRequest.GetInt("BlockType", 0);//限制方式 0白名单 1黑名单
//分页
var pageIndex = PageRequest.GetInt("pageIndex", 1) + 1;
var pageSize = PageRequest.GetInt("pageSize", 1);
//字段排序
var sortField = PageRequest.GetString("sortField");
var sortOrder = PageRequest.GetString("sortOrder");
var order = "";
if (String.IsNullOrEmpty(sortField) == false)
{
if (sortOrder != "desc")
{
sortOrder = "asc";
}
order = " " + sortField + " " + sortOrder;
}
else
{
order += " createtime desc";
}
//业务层：数据库操作
var strWhere = "1=1";
strWhere += " and BlockType=" + BlockType;
var dt = BllIpBlock.GetTable(pageSize, pageIndex, strWhere, order);
var dataAll = MyDBUtils.DataTable2ArrayList(dt);
var result = new Hashtable();
result["data"] = dataAll;
var total = new Common().GetCount("SysIpBlock", strWhere);
result["total"] = total;
//JSON
var json = PluSoft.Utils.JSON.Encode(result);
Response.Write(json);
}
protected void Page_Load(object sender, EventArgs e)
{
var methodName = PageRequest.GetString("method");
Loginadmin = BllAdmin.GetModel(Account.GetLoginUserID());
if (Loginadmin == null)
{
return;
}
var type = this.GetType();
var method = type.GetMethod(methodName);
if (method == null)
{
throw new Exception("method is null");
}
method.Invoke(this, null);
}
/// <summary>
/// 查询
/// </summary>
public void SearchData()
{
//查询条件
var key = Utils.SqlStringFormat(PageRequest.GetString("key"), 2);
//分页
var pageIndex = PageRequest.GetInt("pageIndex", 1);
var pageSize = PageRequest.GetInt("pageSize", 1);
//字段排序
var sortField = PageRequest.GetString("sortField");
var sortOrder = PageRequest.GetString("sortOrder");
var order = "";
if (String.IsNullOrEmpty(sortField) == false)
{
if (sortOrder != "desc") sortOrder = "asc";
order = " " + sortField + " " + sortOrder;
}
else
{
order += " createtime desc";
}
var strWhere = "";
if (key != "")
{
strWhere += "charIndex('" + key + "',FlagName) > 0";
}
if (pageSize == 1)
{
pageSize = 1000;
}
var dt = new Sys.BLL.NewsType().GetTable(-1, -1, strWhere, order);
var dataAll = MyDBUtils.DataTable2ArrayList(dt);
var result = new Hashtable();
result["data"] = dataAll;
//var total = new Sys.BLL.Common().GetCount("Sys_Flag", strWhere);
//result["total"] = total;
//JSON
var json = PluSoft.Utils.JSON.Encode(dataAll);
Response.Write(json);
}
private void Save()
{
var model = BllAdmin.GetModel(PageRequest.GetInt("UserId", 0));
if (model != null)
{
model.PlusFlag = PageRequest.GetString("RoleFlag");//获取新的权限
model.UserFlag = model.RoleFlags + "," + model.PlusFlag;
model.UserFlag = model.UserFlag.Replace(",,", ",");
BllAdmin.UpdateForPlusSysRoleFlag(model);
Response.Write("yes");
}
else
{
Response.Write("");
}
Response.End();
}
public string CurPageFlag = "system_adminipblockconfig"; //当前模块权限
protected void Page_Load(object sender, EventArgs e)
{
ManageHelper.CheckAdminLogin();
ManageHelper.CheckAdminPower(CurPageFlag);
var bll = new Sys.BLL.SysConfig();
if (ManageHelper.PageAct() == "save")
{
ManageHelper.CheckAdminPower("system_memberipblockconfigupdate");//修改权限
var model = bll.GetModel("WebConfig", "AdminIpBlockType");
model.Value = PageRequest.GetString("IpBlockType");
bll.Update(model);
//添加日志
ManageHelper.AddLog(CurPageFlag, (BlockModule == 0 ? "后台" : "用户") + "访问限制选项修改为：“" + Sys.BLL.SysConfig.GetNameByCache("IpBlockType", PageRequest.GetString("IpBlockType")) + "”");
Response.Write("yes");
Response.End();
}
}
/// <summary>
/// 查询
/// </summary>
public void SearchData()
{
//查询条件
var key = Utils.SqlStringFormat(PageRequest.GetString("key"), 2);
//分页
var pageIndex = PageRequest.GetInt("pageIndex", 1);
var pageSize = PageRequest.GetInt("pageSize", 1);
//字段排序
var sortField = PageRequest.GetString("sortField");
var sortOrder = PageRequest.GetString("sortOrder");
var order = "";
if (String.IsNullOrEmpty(sortField) == false)
{
if (sortOrder != "desc")
{
sortOrder = "asc";
}
order = " " + sortField + " " + sortOrder;
}
else
{
order += " ModelId desc";
}
var strWhere = "";
if (pageSize == 1)
{
pageSize = 10000;
}
var dt = new Sys.BLL.EquipmentModel().GetList(pageSize, pageIndex, strWhere, order);
var json = Midea.Common.JsonHelper.ObjectToJson(dt);
Response.Write(json);
Response.End();
}
/// <summary>
/// 查询
/// </summary>
public void SearchData()
{
//查询条件
var orderStatus = PageRequest.GetString("orderStatus");
var projectName = PageRequest.GetString("projectName");
var cmbDate = PageRequest.GetString("cmbDate");
//分页
var pageIndex = PageRequest.GetInt("pageIndex", 1) + 1;
var pageSize = PageRequest.GetInt("pageSize", 1);
//字段排序
var sortField = PageRequest.GetString("sortField");
var sortOrder = PageRequest.GetString("sortOrder");
var order = "";
if (String.IsNullOrEmpty(sortField) == false)
{
if (sortOrder != "desc")
{
sortOrder = "asc";
}
order = " u." + sortField + " " + sortOrder;
}
else
{
order += " CreateDate desc";
}
var strWhere = "1=1";
if (!string.IsNullOrEmpty(orderStatus))
{
if (orderStatus.Equals("0"))
{
strWhere += " and OrderStatus is null";
}
else
{
strWhere += " and OrderStatus=" + orderStatus;
}
}
if (!string.IsNullOrEmpty(projectName))
{
strWhere += string.Format(" and ProjectName like '%{0}%' ", DataSecurity.FilterBadChar(projectName));
}
if (!string.IsNullOrEmpty(cmbDate))
{
//1day,3day,1week,1month,halfyear,oneyear
if (cmbDate.Equals("1day"))
{
strWhere += " and CreateDate>=DATEADD(DAY,-1,GETDATE())";
}
else if (cmbDate.Equals("3day"))
{
strWhere += " and CreateDate>=DATEADD(DAY,-3,GETDATE())";
}
else if (cmbDate.Equals("1week"))
{
strWhere += " and CreateDate>=DATEADD(DAY,-7,GETDATE())";
}
else if (cmbDate.Equals("1month"))
{
strWhere += " and CreateDate>=DATEADD(DAY,-30,GETDATE())";
}
else if (cmbDate.Equals("halfyear"))
{
strWhere += " and CreateDate>=DATEADD(DAY,-180,GETDATE())";
}
else if (cmbDate.Equals("oneyear"))
{
strWhere += " and CreateDate>=DATEADD(DAY,-365,GETDATE())";
}
}
if (pageSize == 1)
{
pageSize = 100;
}
var dt = new Sys.BLL.Orders().GetListForMoreTable(pageSize, pageIndex, strWhere, order);
var dataAll = MyDBUtils.DataTable2ArrayList(dt);
var result = new Hashtable();
result["data"] = dataAll;
var total = new Sys.BLL.Common().GetCount("Orders o", strWhere);
result["total"] = total;
//JSON
var json = PluSoft.Utils.JSON.Encode(result);
Response.Write(json);
}
/// <summary>
/// 页面act请求参数值
/// </summary>
/// <returns></returns>
public static string PageAct()
{
return(PageRequest.GetString("act").ToLower().Trim());
}
/// <summary>
/// 页面errmsg请求参数值
/// </summary>
/// <returns></returns>
public static string PageErrMsg()
{
return(PageRequest.GetString("errmsg").Trim());
}
/// <summary>
/// 页面sucmsg请求参数值
/// </summary>
/// <returns></returns>
public static string PageSucMsg()
{
return(PageRequest.GetString("sucmsg").Trim());
}
/// <summary>
/// 检查登录
/// </summary>
private void CheckLogin()
{
var msg = "yes";
var userName = PageRequest.GetString("UserName");
var passWord = PageRequest.GetString("PassWord");
var validatecode = PageRequest.GetString("validatecode");
//验证码检测
try
{
if (validatecode.ToLower() != Session["ValidateCode"].ToString().ToLower())
{
msg = "验证码错误，请返回检查";
Response.Write(msg);
Response.End();
}
}
catch
{
msg = "yes";
}
//帐户登陆
var bllAccount = new Account();
var userId = bllAccount.CheckLogin(userName, Utils.MD5(passWord));
switch (userId)
{
case -2:
msg = "帐户不存在！";
break;
case -1:
msg = "密码不正确！";
break;
}
if (userId < 0)
{
Response.Write(msg);
Response.End();
}
//管理账户登录
var bllAdmin = new Admin();
var modelAdmin = bllAdmin.GetModel(userId);
if (modelAdmin == null)
{
msg = "该账户无权登陆系统后台！";
Response.Write(msg);
Response.End();
}
else if (modelAdmin.State == 0)
{
msg = "该账户禁止登陆系统后台！";
Response.Write(msg);
Response.End();
}
//成功响应
//Cookie保存-帐户
//518400年 43200月 1440天
Cookie.WriteUserCookie(userId, Utils.MD5(passWord), 518400);
//添加日志
ManageHelper.AddLog("managelogin", "登陆成功");
//Cookie保存-帐户
Sys.BLL.Admin.SetUsername(modelAdmin.Username);
//Cookie保存-姓名
Sys.BLL.Admin.SetRealName(modelAdmin.RealName);
Response.Write(msg);
Response.End();
}
