/// <summary>
/// 新增数据
/// </summary>
/// <param name="RoleObj"></param>
/// <returns></returns>
public bool Add(tblUser RoleObj)
{
//RoleObj.UserID = System.Guid.NewGuid();
//获取当前登录用户的ID(Cookies)
string strUserID = HttpContext.Current.User.Identity.Name;
if (strUserID == string.Empty || strUserID == null)
{
return false;
}
System.Guid guidUserID = new Guid(strUserID);
RoleObj.SendEmail = true;
RoleObj.LastModifiedByID = guidUserID;
RoleObj.CreatedByID = guidUserID;
RoleObj.OwnerID = guidUserID;
RoleObj.CreatedDate = Convert.ToDateTime(System.DateTime.Now);
RoleObj.LastModifiedDate = Convert.ToDateTime(System.DateTime.Now);
RoleObj.SystemModstamp = Convert.ToDateTime(System.DateTime.Now);
RoleObj.IsDeleted = false;
RoleObj.Avatar = this.GetImageIo();
int counts = 0;
//插入数据
try
{
MWDatabaseEntities MWDB = new MWDatabaseEntities();
MWDB.tblUser.AddObject(RoleObj);
counts = MWDB.SaveChanges();
if (counts > 0)
{
string userHostAddress = HttpContext.Current.Request.UserHostAddress;
DbLoggerBLL.SysLogger.Info("Increase user successfully! User id: '"
+ RoleObj.UserID + "'. User host address: '" + userHostAddress + "'. ");
return true;
}
}
catch (Exception ex)
{
string userHostAddress = HttpContext.Current.Request.UserHostAddress;
DbLoggerBLL.SysLogger.Error("Increase user failed! User id: '"
+ RoleObj.UserID + "'. User host address: '" + userHostAddress + "'. Exception info:" + ex.Message);
return false;
}
return false;
}
/// <summary>
/// 更新数据
/// </summary>
/// <param name="RoleObj"></param>
/// <returns></returns>
public bool Update(tblUser UserNew)
{
tblUser UserOld;
int counts = 0;//影响行数标记
using (MWDatabaseEntities MWDB =new MWDatabaseEntities())
{
try
{
UserOld = MWDB.tblUser.FirstOrDefault(t => t.UserID == UserNew.UserID);
//更新数据字段
UserOld.UserName = UserNew.UserName;
UserOld.LoginName = UserNew.LoginName;
UserOld.LoginPwd = UserNew.LoginPwd;
UserOld.UserCode = UserNew.UserCode;
UserOld.State = UserNew.State;
UserOld.Email = UserNew.Email;
UserOld.Desc = UserNew.Desc;
UserOld.Avatar = UserNew.Avatar;
//获取当前登录用户的ID(Cookies)
string strUserID = HttpContext.Current.User.Identity.Name;
if (string.IsNullOrEmpty(strUserID))
{
FormsAuthentication.RedirectToLoginPage();
return false;
}
UserOld.LastModifiedByID = new Guid(strUserID);
DateTime dates = System.DateTime.Now;
UserOld.LastModifiedDate = dates;
UserOld.SystemModstamp = dates;
ObjectStateEntry ose = MWDB.ObjectStateManager.GetObjectStateEntry(UserOld);
IEnumerable<string> list = ose.GetModifiedProperties();
string logBody = string.Empty;
foreach (string pr in list)
{
string strs = pr;//更新实体的属性名
string strNew = ose.CurrentValues[strs].ToString();
string strOld = ose.OriginalValues[strs].ToString();
if (strNew != strOld)
{
strNew = string.IsNullOrEmpty(strNew) ? "null" : strNew;//如果字符串为空，则将null赋给字符串
strOld = string.IsNullOrEmpty(strOld) ? "null" : strOld;
switch (strs)
{
case "LastModifiedByID":
//系统字段不进行发送
break;
case "LastModifiedDate":
//系统字段不进行发送
break;
case "SystemModstamp":
//系统字段不进行发送
break;
default:
logBody += ", " + strs + ": '" + strOld + "'" + " had been changed '" + strNew + "'";
break;
}
}
}
counts = MWDB.SaveChanges();
if (counts > 0)
{
string userHostAddress = HttpContext.Current.Request.UserHostAddress;
DbLoggerBLL.SysLogger.Info("Update user info failed! User update log: '"
+ logBody + "'. User host address: '" + userHostAddress + "' .");
return true;
}
}
catch (Exception ex)
{
string userHostAddress = HttpContext.Current.Request.UserHostAddress;
DbLoggerBLL.SysLogger.Error("Update user info failed! User id: '"
+ UserNew.UserID + "'. User host address: '" + userHostAddress + "' . Exception info:" + ex.Message);
return false;
}
}
return false;
}
/// <summary>
/// 用于向 tblUser EntitySet 添加新对象的方法，已弃用。请考虑改用关联的 ObjectSet<T> 属性的 .Add 方法。
/// </summary>
public void AddTotblUser(tblUser tblUser)
{
base.AddObject("tblUser", tblUser);
}
/// <summary>
/// GridView的InsertCommand事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void GridUser_InsertCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
GridEditableItem edittedItem = e.Item.OwnerTableView.GetInsertItem();
//获取控件
RadTextBox textUserName = edittedItem.FindControl("textUserName") as RadTextBox;
RadTextBox textLoginName = edittedItem.FindControl("textLoginName") as RadTextBox;
RadTextBox textUserCode = edittedItem.FindControl("textUserCode") as RadTextBox;
RadTextBox textEmail = edittedItem.FindControl("textEmail") as RadTextBox;
RadTextBox textDesc = edittedItem.FindControl("textDesc") as RadTextBox;
RadTextBox textLoginPwd = edittedItem.FindControl("textLoginPwd") as RadTextBox;
RadComboBox ComBoxState = edittedItem.FindControl("ComBoxState") as RadComboBox;
RadComboBox ComBoxRole = edittedItem.FindControl("ComBoxRole") as RadComboBox;
System.Guid gTemp = System.Guid.NewGuid();
UserBLL UserBLLs = new UserBLL();
if (UserBLLs.ExistsLogName(textLoginName.Text))
{
//The user already exists
//该用户已存在
RadWindowManager1.RadAlert("The user already exists!", 300, 100, "Info", "");
return;
}
//实例化Entity实体
tblUser UserObj = new tblUser();
UserObj.UserName = textUserName.Text;
UserObj.LoginName = textLoginName.Text;
UserObj.LoginPwd = textLoginPwd.Text;
UserObj.UserCode = textUserCode.Text;
UserObj.State = Convert.ToBoolean(ComBoxState.SelectedItem.Value);
UserObj.Email = textEmail.Text;
UserObj.Desc = textDesc.Text;
UserObj.UserID = gTemp;
UserBLLs.Add(UserObj);
//创建目录文件夹
Directory.CreateDirectory(Request.PhysicalApplicationPath + "FileUpLoad/" + gTemp);
//*************************************************给用户配置角色
RoleUserBLL Role_UserBLLs = new RoleUserBLL();
if (ComBoxRole.SelectedItem.Value != string.Empty)
{
tblRole_User tblRole_UserObj = new tblRole_User();
System.Guid gUserID = gTemp;
System.Guid gRoleID = new Guid(ComBoxRole.SelectedItem.Value);
tblRole_UserObj.UserID = gUserID;
tblRole_UserObj.RoleID = gRoleID;
Role_UserBLLs.Add(tblRole_UserObj);
}
//*************************************************给用户配置角色
this.GridViewData();
}
/// <summary>
/// 创建新的 tblUser 对象。
/// </summary>
/// <param name="userID">UserID 属性的初始值。</param>
public static tblUser CreatetblUser(global::System.Guid userID)
{
tblUser tblUser = new tblUser();
tblUser.UserID = userID;
return tblUser;
}