/// <summary>
/// 删除所有日志
/// </summary>
/// <returns></returns>
public ActionResult DeleteLogDate()
{
Models.ReturnJson returnJson = new Models.ReturnJson();
returnJson.Message = "信息错误";
returnJson.Status = false;
#region SQL操作方法 删除所有日志
SqlParameter[] sqlDeleteRoleDetailData =
{
new SqlParameter("Type", SqlDbType.NChar)
{
Value = "DeleteLogDate"
}
};
int DelectCount = Models.StaticData.myDal.UpdateData("LogManage", sqlDeleteRoleDetailData);
#endregion SQL操作方法 删除所有日志
if (DelectCount > 0)
{
returnJson.Message = "删除成功";
returnJson.Status = true;
}
else
{
returnJson.Message = "删除失败";
returnJson.Status = false;
}
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
public ActionResult UpdateUser(string Name, string Password, string toPassword)
{
Models.ReturnJson returnJson = new Models.ReturnJson();
returnJson.Message = "信息错误";
returnJson.Status = false;
if (Name == null || Password == null || toPassword == null)
{
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
//把密码加密一遍
Password = Common.Tools_MD5.GetMd5(Password);
toPassword = Common.Tools_MD5.GetMd5(toPassword);
#region SQL操作方法
SqlParameter[] sql =
{
new SqlParameter("@Type", SqlDbType.NChar)
{
Value = "UpdateUser"
},
new SqlParameter("@UserName", SqlDbType.NChar)
{
Value = Name
},
new SqlParameter("@Password", SqlDbType.NChar)
{
Value = Password
},
new SqlParameter("@toPassword", SqlDbType.NChar)
{
Value = toPassword
},
new SqlParameter("@UserID", SqlDbType.NChar)
{
Value = Session["UserID"]
}
};
int count = Models.StaticData.myDal.UpdateData("AdminManage", sql);
#endregion SQL操作方法
if (count > 0)
{
Session.Clear();
returnJson.Message = "修改成功，请您重新登录";
returnJson.Status = true;
}
else
{
returnJson.Message = "修改失败，请您重新尝试";
returnJson.Status = false;
}
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="TestID">测试ID</param>
/// <param name="TestName">测试名称</param>
/// <param name="TestBool">测试布尔</param>
/// <param name="Remark">备注</param>
/// <returns></returns>
public ActionResult UpdateData(string TestID, string TestName, string TestBool, string Remark)
{
Models.ReturnJson returnJson = new Models.ReturnJson();
returnJson.Message = "信息错误";
returnJson.Status = false;
if (TestID == null || TestName == null || TestBool == null || Remark == null)
{
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
if (TestID == "" || TestName == "" || TestBool == "" || Remark == "")
{
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
#region SQL操作方法
SqlParameter[] sql =
{
new SqlParameter("Type", SqlDbType.NChar)
{
Value = "UpdateData"
},
new SqlParameter("@TestID", SqlDbType.NChar)
{
Value = TestID
},
new SqlParameter("@TestName", SqlDbType.NChar)
{
Value = TestName
},
new SqlParameter("@TestBool", SqlDbType.NChar)
{
Value = TestBool
},
new SqlParameter("@Remark", SqlDbType.NChar)
{
Value = Remark
},
};
int count = Models.StaticData.myDal.UpdateData("BTestManage", sql);
#endregion SQL操作方法
if (count > 0)
{
returnJson.Message = "修改成功";
returnJson.Status = true;
}
else
{
returnJson.Message = "修改失败";
returnJson.Status = false;
}
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
/// <summary>
/// 删除数据
/// </summary>
/// <param name="IDS">ID集合</param>
/// <returns></returns>
public ActionResult DeleteData(string IDS)
{
Models.ReturnJson returnJson = new Models.ReturnJson();
returnJson.Message = "信息错误";
returnJson.Status = false;
if (IDS == null)
{
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
if (IDS == "")
{
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
int DelectCount = 0;//统计删除的数量
string[] IDs = IDS.Split(',');
foreach (var id in IDs)
{
#region SQL操作方法
SqlParameter[] sql =
{
new SqlParameter("@Type", SqlDbType.NChar)
{
Value = "DeleteData"
},
new SqlParameter("@TestID", SqlDbType.NChar)
{
Value = id
},
};
DelectCount += Models.StaticData.myDal.UpdateData("BTestManage", sql);
#endregion SQL操作方法
}
if (DelectCount > 0)
{
returnJson.Message = "删除成功";
returnJson.Status = true;
}
else
{
returnJson.Message = "删除失败";
returnJson.Status = false;
}
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
/// <summary>
/// 修改角色数据
/// </summary>
/// <param name="RoleID">角色ID</param>
/// <param name="RoleName">角色名称</param>
/// <returns></returns>
public ActionResult UpdateRoleData(string RoleID, string RoleName)
{
Models.ReturnJson returnJson = new Models.ReturnJson();
returnJson.Message = "信息错误";
returnJson.Status = false;
if (RoleName == null)
{
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
if (RoleName == "")
{
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
#region SQL操作方法
SqlParameter[] sql =
{
new SqlParameter("Type", SqlDbType.NChar)
{
Value = "UpdateRoleData"
},
new SqlParameter("@RoleID", SqlDbType.Int)
{
Value = RoleID
},
new SqlParameter("@RoleName", SqlDbType.NChar)
{
Value = RoleName
},
};
int count = Models.StaticData.myDal.UpdateData("RoleManage", sql);
#endregion SQL操作方法
if (count > 0)
{
returnJson.Message = "修改成功";
returnJson.Status = true;
}
else
{
returnJson.Message = "修改失败";
returnJson.Status = false;
}
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
/// <summary>
/// 新增数据
/// </summary>
/// <param name="ExamplerName">示例名称</param>
/// <param name="Remark">备注</param>
/// <returns></returns>
public ActionResult InsertData(string ExamplerName, string Remark)
{
Models.ReturnJson returnJson = new Models.ReturnJson();
returnJson.Message = "信息错误";
returnJson.Status = false;
if (ExamplerName == null || Remark == null)
{
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
if (ExamplerName == "" || Remark == "")
{
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
#region SQL操作方法
SqlParameter[] sql =
{
new SqlParameter("Type", SqlDbType.NChar)
{
Value = "InsertData"
},
new SqlParameter("@ExamplerName", SqlDbType.NChar)
{
Value = ExamplerName
},
new SqlParameter("@Remark", SqlDbType.NChar)
{
Value = Remark
},
};
int count = Models.StaticData.myDal.UpdateData("BExamplerManage", sql);
#endregion SQL操作方法
if (count > 0)
{
returnJson.Message = "新增成功";
returnJson.Status = true;
}
else
{
returnJson.Message = "新增失败";
returnJson.Status = false;
}
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
public ActionResult ExitUser()
{
Models.ReturnJson returnJson = new Models.ReturnJson();
returnJson.Message = "信息错误";
returnJson.Status = false;
try
{
Session.Clear();
returnJson.Message = "成功退出，请等待";
returnJson.Status = true;
}
catch
{
returnJson.Message = "退出失败，请重试";
returnJson.Status = true;
}
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
/// <summary>
/// 更新角色明细数据
/// </summary>
/// <param name="RoleID">角色ID</param>
/// <param name="Behavior">修改的内容</param>
/// <returns></returns>
public ActionResult UpdateRoleDetailData(string RoleID, Dictionary <string, bool> Behavior)
{
Models.ReturnJson returnJson = new Models.ReturnJson();
returnJson.Message = "信息错误";
returnJson.Status = false;
int updateCount = 0;//统计更新的数量
#region SQL操作方法 删除角色明细数据
SqlParameter[] sqlDeleteRoleDetailData =
{
new SqlParameter("Type", SqlDbType.NChar)
{
Value = "DeleteRoleDetailData"
},
new SqlParameter("@RoleID", SqlDbType.Int)
{
Value = RoleID
},
};
Models.StaticData.myDal.UpdateData("RoleManage", sqlDeleteRoleDetailData);
#endregion SQL操作方法 删除角色明细数据
#region SQL操作方法 新增角色明细数据
Dictionary <int, string> behaviors = new Dictionary <int, string>();
foreach (var behavior in Behavior)
{
string[] keys = behavior.Key.Replace("-zf-", "^").Split('^');
string behavio = keys[0];
int menuID = Convert.ToInt32(keys[1]);
bool value = behavior.Value;
if (value)
{
try { behaviors[menuID] += "," + behavio; }
catch { behaviors.Add(menuID, behavio); }
}
}
foreach (var behavior in behaviors)
{
SqlParameter[] sqlInsertRoleDetailData =
{
new SqlParameter("Type", SqlDbType.NChar)
{
Value = "InsertRoleDetailData"
},
new SqlParameter("@RoleID", SqlDbType.Int)
{
Value = RoleID
},
new SqlParameter("@MenuID", SqlDbType.Int)
{
Value = behavior.Key
},
new SqlParameter("@Behavior", SqlDbType.NChar)
{
Value = behavior.Value
},
};
updateCount = Models.StaticData.myDal.UpdateData("RoleManage", sqlInsertRoleDetailData);
}
#endregion SQL操作方法 新增角色明细数据
if (updateCount > 0)
{
returnJson.Message = "角色权限调整成功";
returnJson.Status = true;
}
else
{
returnJson.Message = "角色权限调整失败";
returnJson.Status = false;
}
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
/// <summary>
/// 登录验证
/// </summary>
/// <param name="rememberMe">是否记住用户</param>
/// <param name="accounts">用户账号</param>
/// <param name="password">用户密码</param>
/// <param name="timestamp">时间戳</param>
/// <param name="captcha">验证码</param>
/// <returns></returns>
public ActionResult Login(string rememberMe, string accounts, string password, string timestamp, string captcha)
{
Models.ReturnJson returnJson = new Models.ReturnJson();
returnJson.Message = "信息错误";
returnJson.Status = false;
if (Session["ValidateCode"] != null)//防止页面的打开方式是不正确
{
if (rememberMe != null && accounts != null && password != null && captcha != null && timestamp != null)
{
if (rememberMe != "" && accounts != "" && password != "" && captcha != "" && timestamp != "")
{
TimeSpan timeSpan = Common.Tools_Date.DateDiff2(DateTime.Now, Common.Tools_Date.GetTime(timestamp));
if (timeSpan.TotalSeconds < 120)//在打开网页的两分钟内必须完成登录
{
string validateCode = Session["ValidateCode"].ToString();
if (validateCode.ToLower() == captcha.ToLower())
{
#region SQL查询方法
SqlParameter[] sql =
{
new SqlParameter("@Type", SqlDbType.NChar)
{
Value = "InquireLogin"
},
new SqlParameter("@Accounts", SqlDbType.NChar)
{
Value = accounts
},
};
DataTable dtUser = Models.StaticData.myDal.QueryDataTable("AdminManage", sql);
#endregion SQL查询方法
if (dtUser.Rows.Count > 0)
{
string passwords = password;
//将密码进行Base64解密
passwords = Common.Tools_Base64.DecodeBase64(passwords);
//将密码进行MD5加密
passwords = Common.Tools_MD5.GetMd5(passwords);
if (dtUser.Rows[0]["Password"].ToString() == passwords)
{
returnJson.Message = "登录成功，马上跳转";
returnJson.Status = true;
#region 重要的数据存储到Session中
string remember = "checked";//记住密码
try
{
if (!Convert.ToBoolean(rememberMe))
{
accounts = "";
password = "";
remember = "";
}
}
catch { }
Session["UserID"] = dtUser.Rows[0]["UserID"].ToString();
Session["RoleID"] = dtUser.Rows[0]["RoleID"].ToString();
Session["Single"] = dtUser.Rows[0]["Single"].ToString();
Session["UserName"] = dtUser.Rows[0]["UserName"].ToString();
Session["Accounts"] = accounts;
Session["Password"] = password;
Session["Remember"] = remember;
#endregion 重要的数据存储到Session中
#region 点对点登录(生成)
Models.Authorization.PointToPointLogin_G(this);
#endregion 点对点登录(生成)
}
else
{
returnJson.Message = "您输入的密码错误";
}
}
else
{
returnJson.Message = "您输入的账号错误";
}
}
else
{
returnJson.Message = "您输入的验证码错误";
}
}
else
{
returnJson.Message = "请您刷新界面后操作";
}
}
}
}
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
/// <summary>
/// 修改用户数据
/// </summary>
/// <param name="Accounts">用户账号</param>
/// <param name="UserName">用户名称</param>
/// <param name="Password">用户密码</param>
/// <param name="UserID">用户ID</param>
/// <param name="RoleID">用户角色ID</param>
/// <param name="Single">单点登录</param>
/// <returns></returns>
public ActionResult UpdateUserData(string Accounts, string UserName, string Password, string UserID, string RoleID, string Single)
{
Models.ReturnJson returnJson = new Models.ReturnJson();
returnJson.Message = "信息错误";
returnJson.Status = false;
if (Accounts == null || UserName == null || RoleID == null || Single == null)
{
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
if (Accounts == "" || UserName == "" || RoleID == "" || Single == "")
{
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
//数据转换
int single = 0; if (Convert.ToBoolean(Single))
{
single = 1;
}
//把密码加密一遍
if (Password != "" && Password != null)
{
Password = Common.Tools_MD5.GetMd5(Password);
}
#region SQL查询方法
SqlParameter[] sqlUser =
{
new SqlParameter("Type", SqlDbType.NChar)
{
Value = "InsertUser"
},
new SqlParameter("@Accounts", SqlDbType.NChar)
{
Value = Accounts
},
};
DataTable dtUser = Models.StaticData.myDal.QueryDataTable("UserManage", sqlUser);
#endregion SQL查询方法
//防止修改成，除了本身的其它同样账号的用户
if (dtUser.Rows.Count > 0)
{
string str = dtUser.Rows[0]["UserID"].ToString();
if (dtUser.Rows[0]["UserID"].ToString() != UserID)
{
returnJson.Message = "存在同样账号的用户";
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
}
#region SQL操作方法
SqlParameter[] sql =
{
new SqlParameter("Type", SqlDbType.NChar)
{
Value = "UpdateUserData"
},
new SqlParameter("@UserID", SqlDbType.Int)
{
Value = UserID
},
new SqlParameter("@RoleID", SqlDbType.Int)
{
Value = RoleID
},
new SqlParameter("@UserName", SqlDbType.NChar)
{
Value = UserName
},
new SqlParameter("@Accounts", SqlDbType.NChar)
{
Value = Accounts
},
new SqlParameter("@Password", SqlDbType.NChar)
{
Value = Password
},
new SqlParameter("@Single", SqlDbType.Int)
{
Value = single
},
};
int count = Models.StaticData.myDal.UpdateData("UserManage", sql);
#endregion SQL操作方法
if (count > 0)
{
returnJson.Message = "修改成功";
returnJson.Status = true;
}
else
{
returnJson.Message = "修改失败";
returnJson.Status = false;
}
return(Json(returnJson, JsonRequestBehavior.DenyGet));
}
