/// <summary>
/// 登陆验证
/// </summary>
/// <param name="LoginName">用户名</param>
/// <param name="LoginPassWord">密码</param>
/// <param name="userkey">用户登陆标识</param>
/// <returns>true/false</returns>
public bool CheckLogin(string LoginName, string LoginPassWord, string userkey)
{
bool bBool = false;
QueryParam qp = new QueryParam();
qp.Where = string.Format(" Where U_StatUs=0 and U_LoginName='{0}' and U_Password='******'", Common.inSQL(LoginName), Common.md5(LoginPassWord, 32));
int iInt = 0;
ArrayList lst = BusinessFacade.sys_UserList(qp, out iInt);
if (iInt > 0)
{
bBool = true;
sys_UserTable sUT = (sys_UserTable)lst[0];
string[] U_ExtendFieldArray = (sUT.U_ExtendField + "").Split(',');
if (U_ExtendFieldArray.Length == 3)
{
Common.MenuStyle = Convert.ToInt32(U_ExtendFieldArray[0]);
Common.PageSize = Convert.ToInt32(U_ExtendFieldArray[1]);
Common.TableSink = U_ExtendFieldArray[2];
}
checkOnline(sUT.U_LoginName.ToLower(), LoginPassWord, Common.GetSessionID, userkey);
Signin(sUT);
}
return(bBool);
}
protected void Button3_Click(object sender, EventArgs e)
{
//保存待分组用户
int count1 = ListBox1.Items.Count;
for (int i = 0; i < count1; i++)
{
sys_UserTable ut = BusinessFacade.sys_UserDisp(int.Parse(ListBox1.Items[i].Value));
ut.U_SGroupID = 0;
ut.DB_Option_Action_ = "Update";
int rInt = BusinessFacade.sys_UserInsertUpdate(ut);
}
//保存右边分组用户
int count2 = ListBox2.Items.Count;
for (int j = 0; j < count2; j++)
{
sys_UserTable ut = BusinessFacade.sys_UserDisp(int.Parse(ListBox2.Items[j].Value));
ut.U_SGroupID = int.Parse(DropDownList1.SelectedValue);
ut.DB_Option_Action_ = "Update";
int rInt = BusinessFacade.sys_UserInsertUpdate(ut);
}
Response.Write("<script language='javascript'>alert('设置成功!');</script>");
}
private void OnStart()
{
sys_UserTable ut = BusinessFacade.sys_UserDisp(Common.Get_UserID);
U_LoginName_Txt.Text = ut.U_LoginName;
string[] U_ExtendFieldArray = (ut.U_ExtendField + "").Split(',');
if (U_ExtendFieldArray.Length == 3)
{
ListItem li = MenuSink.Items.FindByValue(U_ExtendFieldArray[0]);
if (li != null)
{
li.Selected = true;
}
ListItem li1 = PageSize.Items.FindByValue(U_ExtendFieldArray[1]);
if (li1 != null)
{
li1.Selected = true;
}
ListItem li2 = TableSink.Items.FindByValue(U_ExtendFieldArray[2]);
if (li2 != null)
{
li2.Selected = true;
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string DispTxt = "";
if (Common.Get_UserID != 0)
{
sys_UserTable ut = BusinessFacade.sys_UserDisp(Common.Get_UserID);
string Old_U_Password_Value = (string)Common.sink(Old_U_Password.UniqueID, MethodType.Post, 20, 0, DataType.Str);
string New_U_Password_Value = (string)Common.sink(New_U_Password.UniqueID, MethodType.Post, 20, 0, DataType.Str);
string ReNew_U_Password_Value = (string)Common.sink(ReNew_U_Password.UniqueID, MethodType.Post, 20, 0, DataType.Str);
int MenuSink_Value = (int)Common.sink(MenuSink.UniqueID, MethodType.Post, 255, 1, DataType.Int);
int PageSize_Value = (int)Common.sink(PageSize.UniqueID, MethodType.Post, 255, 1, DataType.Int);
string TableSink_Value = (string)Common.sink(TableSink.UniqueID, MethodType.Post, 255, 1, DataType.Str);
bool ChangPwdBool = false;
if (Old_U_Password_Value != "" && New_U_Password_Value != "" && ReNew_U_Password_Value != "")
{
if (New_U_Password_Value != ReNew_U_Password_Value)
{
DispTxt = "二次输入的密码不相同，请重新输入!";
}
else if (Common.md5(Old_U_Password_Value, 32) != ut.U_Password)
{
DispTxt = "原密码输入错误，请重新输入!";
}
else
{
ut.U_Password = Common.md5(New_U_Password_Value, 32);
ChangPwdBool = true;
}
}
ut.U_ExtendField = MenuSink_Value + "," + PageSize_Value + "," + TableSink_Value;
if (DispTxt != "")
{
Common.MessBox(DispTxt);
}
else
{
string titleMessage = string.Format("({0})个人资料设定成功!", ut.U_LoginName);
ut.DB_Option_Action_ = "Update";
BusinessFacade.sys_UserInsertUpdate(ut);
UserData.MoveUserCache(Common.Get_UserID);
if (ChangPwdBool)
{
titleMessage = "密码修改成功," + titleMessage;
FrameWorkLogin.UserOut();
}
Common.MenuStyle = MenuSink_Value;
Common.PageSize = PageSize_Value;
Common.TableSink = TableSink_Value;
EventMessage.EventWriteDB(1, titleMessage);
ClientScriptManager cs = Page.ClientScript;
cs.RegisterStartupScript(typeof(string), "TabJs", "<script language='javascript'>window.returnVal='" + titleMessage + "';window.parent.hidePopWin(true);</script>");
}
}
}
/// <summary>
/// 根据用户ID获取用户资料(从缓存中获取)
/// </summary>
/// <param name="UserID">用户ID</param>
/// <returns></returns>
public static sys_UserTable Get_sys_UserTable(int UserID)
{
string CacheKey = string.Format("{0}-UserInfo-{1}", Common.Get_WebCacheName, UserID);
if (FrameWorkCache.Instance()[CacheKey] != null)
{
return((sys_UserTable)FrameWorkCache.Instance()[CacheKey]);
}
else
{
sys_UserTable sUT = BusinessFacade.sys_UserDisp(UserID);
FrameWorkCache.Instance().Insert(CacheKey, sUT);
return(sUT);
}
}
/// <summary>
/// 用户登陆
/// </summary>
/// <param name="sUT">用户实体类</param>
private void Signin(sys_UserTable sUT)
{
System.Web.Security.FormsAuthenticationTicket tk = new FormsAuthenticationTicket(1,
sUT.UserID.ToString(),
DateTime.Now,
DateTime.Now.AddDays(1),
true,
"",
System.Web.Security.FormsAuthentication.FormsCookiePath
);
string key = System.Web.Security.FormsAuthentication.Encrypt(tk); //得到加密后的身份验证票字串
HttpCookie ck = new HttpCookie(System.Web.Security.FormsAuthentication.FormsCookieName, key);
//ck.Domain = System.Web.Security.FormsAuthentication.CookieDomain; // 这句话在部署网站后有用，此为关系到同一个域名下面的多个站点是否能共享Cookie
HttpContext.Current.Response.Cookies.Add(ck);
}
/// <summary>
/// 登陆验证
/// </summary>
/// <param name="LoginName">用户名</param>
/// <param name="LoginPassWord">密码</param>
/// <param name="userkey">用户登陆标识</param>
/// <returns>true/false</returns>
public bool CheckLogin(string LoginName, string LoginPassWord, string userkey)
{
bool bBool = false;
QueryParam qp = new QueryParam();
qp.Where = string.Format(" Where U_StatUs=0 and U_LoginName='{0}'", Common.inSQL(LoginName));
int iInt = 0;
ArrayList lst = BusinessFacade.sys_UserList(qp, out iInt);
if (iInt > 0)
{
bBool = true;
sys_UserTable sUT = (sys_UserTable)lst[0];
//判断登陆接口
if (!string.IsNullOrEmpty(sUT.U_LoginType))
{
IAuthentication auth = (IAuthentication)Activator.CreateInstance(sUT.U_LoginType.Split(',')[0], sUT.U_LoginType.Split(',')[1]).Unwrap();
if (!auth.checkLogin(LoginName, LoginPassWord))
{
return(false);
}
}
else //如为系统认证,检测系统密码
{
if (sUT.U_Password != Common.md5(LoginPassWord, 32))
{
return(false);
}
}
string[] U_ExtendFieldArray = (sUT.U_ExtendField + "").Split(',');
if (U_ExtendFieldArray.Length == 3)
{
Common.MenuStyle = Convert.ToInt32(U_ExtendFieldArray[0]);
Common.PageSize = Convert.ToInt32(U_ExtendFieldArray[1]);
Common.TableSink = U_ExtendFieldArray[2];
}
checkOnline(sUT.U_LoginName.ToLower(), LoginPassWord, Common.GetSessionID, userkey);
Signin(sUT);
}
return(bBool);
}
/// <summary>
/// 初始化
/// </summary>
private void OnStart()
{
sys_UserTable ut = BusinessFacade.sys_UserDisp(UserID);
OnStartData(ut);
if (CMD == "List")
{
DispTr.Visible = true;
HeadMenuButtonItem bi1 = new HeadMenuButtonItem();
bi1.ButtonPopedom = PopedomType.Edit;
bi1.ButtonName = "用户";
bi1.ButtonUrl = string.Format("?CMD=Edit&UserID={0}", UserID);
HeadMenuWebControls1.ButtonList.Add(bi1);
Hidden_Input();
PostButton.Visible = false;
}
else if (CMD == "New")
{
SetUserGroup();
Hidden_Disp();
}
else if (CMD == "Edit")
{
CheckUserNewEditDelete();
Hidden_Disp();
HeadMenuButtonItem bi5 = new HeadMenuButtonItem();
bi5.ButtonIcon = "back.gif";
bi5.ButtonPopedom = PopedomType.List;
bi5.ButtonName = "返回";
bi5.ButtonUrl = string.Format("?CMD=List&UserID={0}", UserID);
HeadMenuWebControls1.ButtonList.Add(bi5);
HeadMenuButtonItem bi2 = new HeadMenuButtonItem();
bi2.ButtonPopedom = PopedomType.Delete;
bi2.ButtonName = "用户";
bi2.ButtonUrlType = UrlType.JavaScript;
bi2.ButtonUrl = string.Format("DelData('?CMD=Delete&UserID={0}')", UserID);
HeadMenuWebControls1.ButtonList.Add(bi2);
U_LoginName.Visible = false;
U_LoginName_Value.Visible = true;
}
else if (CMD == "Delete")
{
CheckUserNewEditDelete();
//Admin帐号不能被删除
if ((ut.UserID != 1))
{
if (ut.U_Type == 0 && UserData.GetUserDate.U_Type == 1)
{
EventMessage.MessageBox(1, "操作无效", "普通用户无法删除超级用户资料!", Icon_Type.Error, Common.GetHomeBaseUrl("default.aspx"));
}
//ut.DB_Option_Action_ = "Delete";
//BusinessFacade.sys_UserInsertUpdate(ut);
//设置用户删除标识
BusinessFacade.Update_Table_Fileds("sys_User", "U_Status=2", string.Format("UserID={0}", UserID));
ArrayList lst = BusinessFacade.sys_UserRolesDisp(UserID);
foreach (sys_UserRolesTable var in lst)
{
var.DB_Option_Action_ = "Delete";
BusinessFacade.sys_UserRolesInsertUpdate(var);
}
if (ut.U_PhotoUrl != "")
{
FileUpLoadCommon.DeleteFile(string.Format("{0}{1}{2}", Common.UpLoadDir, "UserPhoto/", ut.U_PhotoUrl));
FileUpLoadCommon.DeleteFile(string.Format("{0}{1}s_{2}", Common.UpLoadDir, "UserPhoto/", ut.U_PhotoUrl));
}
//从缓存中移除用户
UserData.MoveUserCache(UserID);
//从在线列表中移除
FrameWorkOnline.Instance().OnlineRemove(ut.U_LoginName.ToLower());
}
EventMessage.MessageBox(1, "操作成功", string.Format("{1}ID({0})成功!", UserID, "删除用户"), Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx"));
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string U_Password_Txt = (string)Common.sink(U_Password.UniqueID, MethodType.Post, 32, 1, DataType.Str);
int U_Type_Txt = (int)Common.sink(U_Type.UniqueID, MethodType.Post, 20, 1, DataType.Int);
int U_Status_Txt = (int)Common.sink(U_Status.UniqueID, MethodType.Post, 20, 1, DataType.Int);
string U_UserNO_Txt = (string)Common.sink(U_UserNO.UniqueID, MethodType.Post, 20, 0, DataType.Str);
string U_CName_Txt = (string)Common.sink(U_CName.UniqueID, MethodType.Post, 20, 0, DataType.Str);
string U_EName_Txt = (string)Common.sink(U_EName.UniqueID, MethodType.Post, 50, 0, DataType.Str);
int U_GroupID_Txt = (int)Common.sink(U_GroupID.UniqueID, MethodType.Post, 50, 0, DataType.Int);
int U_Sex_Txt = (int)Common.sink(U_Sex.UniqueID, MethodType.Post, 50, 1, DataType.Int);
DateTime?U_BirthDay_Txt = (DateTime?)Common.sink(U_BirthDay.UniqueID, MethodType.Post, 50, 0, DataType.Dat);
int U_Title_Txt = (int)Common.sink("U_Title", MethodType.Post, 50, 0, DataType.Int);
string U_IDCard_Txt = (string)Common.sink(U_IDCard.UniqueID, MethodType.Post, 30, 0, DataType.Str);
string U_HomeTel_Txt = (string)Common.sink(U_HomeTel.UniqueID, MethodType.Post, 20, 0, DataType.Str);
string U_MobileNo_Txt = (string)Common.sink(U_MobileNo.UniqueID, MethodType.Post, 15, 0, DataType.Str);
string U_CompanyMail_Txt = (string)Common.sink(U_CompanyMail.UniqueID, MethodType.Post, 100, 0, DataType.Email);
string U_Email_Txt = (string)Common.sink(U_Email.UniqueID, MethodType.Post, 100, 0, DataType.Email);
string U_Extension_Txt = (string)Common.sink(U_Extension.UniqueID, MethodType.Post, 10, 0, DataType.Str);
DateTime?U_WorkStartDate_Txt = (DateTime?)Common.sink(U_WorkStartDate.UniqueID, MethodType.Post, 50, 0, DataType.Dat);
string U_Remark_Txt = (string)Common.sink(U_Remark.UniqueID, MethodType.Post, 2000, 0, DataType.Str);
PopedomType pt = PopedomType.New;
string All_Title_Txt = "增加";
sys_UserTable ut = BusinessFacade.sys_UserDisp(UserID);
if (CMD == "New")
{
string U_LoginName_Txt = (string)Common.sink(U_LoginName.UniqueID, MethodType.Post, 20, 1, DataType.Str);
ut.U_Password = Common.md5(U_Password_Txt, 32);
ut.U_LoginName = U_LoginName_Txt;
ut.U_LastDateTime = DateTime.Now;
ut.U_LastIP = Common.GetIPAddress();
ut.U_DateTime = DateTime.Now;
ut.DB_Option_Action_ = "Insert";
}
else if (CMD == "Edit")
{
//只有 超级管理员 和 管理员 才能修改密码
if (BusinessFacade.sys_UserCheckManager())
{
//超级管理员不能被修改密码
if (ut.UserID != 1)
{
if (U_Password_Txt != ut.U_Password)
{
ut.U_Password = Common.md5(U_Password_Txt, 32);
}
}
}
pt = PopedomType.Edit;
All_Title_Txt = "修改";
ut.DB_Option_Action_ = "Update";
if (ut.U_Type == 0 && UserData.GetUserDate.U_Type == 1)
{
EventMessage.MessageBox(1, "操作无效", "普通用户无效修改超级用户资料!", Icon_Type.Error, Common.GetHomeBaseUrl("default.aspx"));
}
}
else
{
EventMessage.MessageBox(2, "CMD值无效", "无效操作命令!", Icon_Type.Error, Common.GetHomeBaseUrl("default.aspx"));
}
ut.U_BirthDay = U_BirthDay_Txt;
ut.U_CName = U_CName_Txt;
ut.U_CompanyMail = U_CompanyMail_Txt;
ut.U_Email = U_Email_Txt;
ut.U_EName = U_EName_Txt;
ut.U_Extension = U_Extension_Txt;
ut.U_GroupID = U_GroupID_Txt;
ut.U_HomeTel = U_HomeTel_Txt;
ut.U_IDCard = U_IDCard_Txt;
ut.U_MobileNo = U_MobileNo_Txt;
ut.U_Remark = U_Remark_Txt;
ut.U_Sex = U_Sex_Txt;
//超级管理员不能被修改状态
if (ut.UserID != 1)
{
//必需是超级用户和管理员才能修改禁止登陆
if (BusinessFacade.sys_UserCheckManager())
{
ut.U_Status = U_Status_Txt;
}
}
ut.U_Title = U_Title_Txt;
//限制admin帐号只能为超级用户
if (ut.UserID == 1)
{
ut.U_Type = 0;
}
else
{
//只有超级管理员才能增加超级管理员和管理员
if (UserData.GetUserDate.U_Type == 0)
{
ut.U_Type = U_Type_Txt;
}
}
ut.U_UserNO = U_UserNO_Txt;
ut.U_WorkStartDate = U_WorkStartDate_Txt;
string GetU_PhotoName = UpPhoto();
if (GetU_PhotoName != "")
{
FileUpLoadCommon.DeleteFile(string.Format("{0}{1}{2}", Common.UpLoadDir, "UserPhoto/", ut.U_PhotoUrl));
FileUpLoadCommon.DeleteFile(string.Format("{0}{1}s_{2}", Common.UpLoadDir, "UserPhoto/", ut.U_PhotoUrl));
ut.U_PhotoUrl = GetU_PhotoName;
}
if (BusinessFacade.sys_UserTableCheckPK(ut, pt))
{
EventMessage.MessageBox(1, "操作失败", string.Format("存在相同的值({0})!", ut.U_LoginName), Icon_Type.Alert, Common.GetHomeBaseUrl("default.aspx"));
}
int rInt = BusinessFacade.sys_UserInsertUpdate(ut);
//只有 超级管理员 和 管理员 才能修改角色资料
if (BusinessFacade.sys_UserCheckManager())
{
//超级管理员不能被修改密码
if (ut.UserID != 1)
{
if (ut.DB_Option_Action_ == "Insert")
{
SaveRoles(rInt);
}
else
{
SaveRoles(UserID);
}
}
}
UserData.MoveUserCache(UserID);
EventMessage.MessageBox(1, "操作成功", string.Format("{1}ID({0})成功!", ut.U_LoginName, All_Title_Txt), Icon_Type.OK, Common.GetHomeBaseUrl("default.aspx"));
}
/// <summary>
/// 初始化数据
/// </summary>
/// <param name="ut"></param>
private void OnStartData(sys_UserTable ut)
{
#region "显示数据"
U_LoginName_Value.Text = ut.U_LoginName;
U_Password_Value.Text = "******";
U_Type_Value.Text = BusinessFacade.sys_UserType(ut.U_Type);
U_Status_Value.Text = ut.U_Status == 0 ? "正常" : "禁止";
U_UserNO_Value.Text = ut.U_UserNO;
U_CName_Value.Text = ut.U_CName;
U_EName_Value.Text = ut.U_EName;
U_GroupID_Value.Text = BusinessFacade.sys_GroupDisp(ut.U_GroupID).G_CName;
U_Sex_Value.Text = ut.U_Sex == 0 ? "女" : "男";
U_BirthDay_Value.Text = Common.ConvertDate(ut.U_BirthDay);
U_Title_Value.Text = BusinessFacade.sys_FieldValueDisp(ut.U_Title).V_Text;
U_IDCard_Value.Text = ut.U_IDCard;
U_HomeTel_Value.Text = ut.U_HomeTel;
U_MobileNo_Value.Text = ut.U_MobileNo;
U_CompanyMail_Value.Text = ut.U_CompanyMail;
U_Email_Value.Text = ut.U_Email;
U_Extension_Value.Text = ut.U_Extension;
U_WorkStartDate_Value.Text = Common.ConvertDate(ut.U_WorkStartDate);
U_Remark_Value.Text = ut.U_Remark;
if ((ut.U_PhotoUrl + "").Trim() != "")
{
U_PhotoUrl_Value.ImageUrl = Common.BuildDownFileUrl("UserPhoto/s_" + ut.U_PhotoUrl);
MaxImgUrl = Common.BuildDownFileUrl("UserPhoto/" + ut.U_PhotoUrl);
}
else
{
U_PhotoUrl_Value.Visible = false;
}
U_LastIP_Value.Text = Common.GetIPLookUrl(ut.U_LastIP);
U_LastDateTime_Value.Text = ut.U_LastDateTime.ToString();
#endregion
#region "输入数据"
U_LoginName.Text = ut.U_LoginName;
U_Password.Attributes["value"] = ut.U_Password;
ListItem li = U_Type.Items.FindByValue(ut.U_Type.ToString());
if (li != null)
{
li.Selected = true;
}
ListItem li1 = U_Status.Items.FindByValue(ut.U_Status.ToString());
if (li1 != null)
{
li1.Selected = true;
}
U_UserNO.Text = ut.U_UserNO;
U_CName.Text = ut.U_CName;
U_EName.Text = ut.U_EName;
U_GroupID.Value = ut.U_GroupID.ToString();
U_GroupID_Txt.Value = BusinessFacade.sys_GroupDisp(ut.U_GroupID).G_CName;
ListItem li2 = U_Sex.Items.FindByValue(ut.U_Sex.ToString());
if (li2 != null)
{
li2.Selected = true;
}
U_BirthDay.Text = Common.ConvertDate(ut.U_BirthDay);
FieldWebControls1.Field_Value = ut.U_Title.ToString();
U_IDCard.Text = ut.U_IDCard;
U_HomeTel.Text = ut.U_HomeTel;
U_MobileNo.Text = ut.U_MobileNo;
U_CompanyMail.Text = ut.U_CompanyMail;
U_Email.Text = ut.U_Email;
U_Extension.Text = ut.U_Extension;
U_WorkStartDate.Text = Common.ConvertDate(ut.U_WorkStartDate);
U_Remark.Text = ut.U_Remark;
//if ((ut.U_PhotoUrl + "").Trim() != "")
//{
// U_PhotoUrl_Value.ImageUrl = Common.BuildDownFileUrl("UserPhoto/s_" + ut.U_PhotoUrl);
//}
//else
// U_PhotoUrl_Value.Visible = false;
#endregion
}
/// <summary>
/// 将记录集转为sys_UserTable实体类
/// </summary>
/// <param name="dr">记录集</param>
/// <returns>sys_UserTable</returns>
protected object Populatesys_User(IDataReader dr)
{
sys_UserTable nc = new sys_UserTable();
if (!Convert.IsDBNull(dr["UserID"]))
{
nc.UserID = Convert.ToInt32(dr["UserID"]); // 用户ID号
}
if (!Convert.IsDBNull(dr["U_LoginName"]))
{
nc.U_LoginName = Convert.ToString(dr["U_LoginName"]).Trim(); // 登陆名
}
if (!Convert.IsDBNull(dr["U_Password"]))
{
nc.U_Password = Convert.ToString(dr["U_Password"]).Trim(); // 密码md5加密字符
}
if (!Convert.IsDBNull(dr["U_CName"]))
{
nc.U_CName = Convert.ToString(dr["U_CName"]).Trim(); // 中文姓名
}
if (!Convert.IsDBNull(dr["U_EName"]))
{
nc.U_EName = Convert.ToString(dr["U_EName"]).Trim(); // 英文名
}
if (!Convert.IsDBNull(dr["U_GroupID"]))
{
nc.U_GroupID = Convert.ToInt32(dr["U_GroupID"]); // 部门ID号与sys_Group表中GroupID关联
}
if (!Convert.IsDBNull(dr["U_Email"]))
{
nc.U_Email = Convert.ToString(dr["U_Email"]).Trim(); // 电子邮件
}
if (!Convert.IsDBNull(dr["U_Type"]))
{
nc.U_Type = Convert.ToInt32(dr["U_Type"]); // 用户类型0:超级用户1:普通用户
}
if (!Convert.IsDBNull(dr["U_Status"]))
{
nc.U_Status = Convert.ToInt32(dr["U_Status"]); // 当前状态0:正常 1:禁止
}
if (!Convert.IsDBNull(dr["U_Licence"]))
{
nc.U_Licence = Convert.ToString(dr["U_Licence"]).Trim(); // 用户序列号
}
if (!Convert.IsDBNull(dr["U_Mac"]))
{
nc.U_Mac = Convert.ToString(dr["U_Mac"]).Trim(); // 锁定机器硬件地址
}
if (!Convert.IsDBNull(dr["U_Remark"]))
{
nc.U_Remark = Convert.ToString(dr["U_Remark"]).Trim(); // 备注说明
}
if (!Convert.IsDBNull(dr["U_IDCard"]))
{
nc.U_IDCard = Convert.ToString(dr["U_IDCard"]).Trim(); // 身份证号码
}
if (!Convert.IsDBNull(dr["U_Sex"]))
{
nc.U_Sex = Convert.ToInt32(dr["U_Sex"]); // 性别1:男0:女
}
if (!Convert.IsDBNull(dr["U_BirthDay"]))
{
nc.U_BirthDay = Convert.ToDateTime(dr["U_BirthDay"]); // 出生日期
}
if (!Convert.IsDBNull(dr["U_MobileNo"]))
{
nc.U_MobileNo = Convert.ToString(dr["U_MobileNo"]).Trim(); // 手机号
}
if (!Convert.IsDBNull(dr["U_UserNO"]))
{
nc.U_UserNO = Convert.ToString(dr["U_UserNO"]).Trim(); // 员工编号
}
if (!Convert.IsDBNull(dr["U_WorkStartDate"]))
{
nc.U_WorkStartDate = Convert.ToDateTime(dr["U_WorkStartDate"]); // 到职日期
}
if (!Convert.IsDBNull(dr["U_WorkEndDate"]))
{
nc.U_WorkEndDate = Convert.ToDateTime(dr["U_WorkEndDate"]); // 离职日期
}
if (!Convert.IsDBNull(dr["U_CompanyMail"]))
{
nc.U_CompanyMail = Convert.ToString(dr["U_CompanyMail"]).Trim(); // 公司邮件地址
}
if (!Convert.IsDBNull(dr["U_Title"]))
{
nc.U_Title = Convert.ToInt32(dr["U_Title"]); // 职称与应用字段关联
}
if (!Convert.IsDBNull(dr["U_Extension"]))
{
nc.U_Extension = Convert.ToString(dr["U_Extension"]).Trim(); // 分机号
}
if (!Convert.IsDBNull(dr["U_HomeTel"]))
{
nc.U_HomeTel = Convert.ToString(dr["U_HomeTel"]).Trim(); // 家中电话
}
if (!Convert.IsDBNull(dr["U_PhotoUrl"]))
{
nc.U_PhotoUrl = Convert.ToString(dr["U_PhotoUrl"]).Trim(); // 用户照片网址
}
if (!Convert.IsDBNull(dr["U_DateTime"]))
{
nc.U_DateTime = Convert.ToDateTime(dr["U_DateTime"]); // 操作时间
}
if (!Convert.IsDBNull(dr["U_LastIP"]))
{
nc.U_LastIP = Convert.ToString(dr["U_LastIP"]).Trim(); // 最后访问IP
}
if (!Convert.IsDBNull(dr["U_LastDateTime"]))
{
nc.U_LastDateTime = Convert.ToDateTime(dr["U_LastDateTime"]); // 最后访问时间
}
if (!Convert.IsDBNull(dr["U_ExtendField"]))
{
nc.U_ExtendField = Convert.ToString(dr["U_ExtendField"]).Trim(); // 扩展字段
}
if (!Convert.IsDBNull(dr["U_LoginType"]))
{
nc.U_LoginType = Convert.ToString(dr["U_LoginType"]).Trim(); // 登入类型(为空系统认证,其它值为其它认证)
}
if (!Convert.IsDBNull(dr["U_SGroupID"]))
{
nc.U_SGroupID = Convert.ToInt32(dr["U_SGroupID"]); // 部门ID号与sys_Group表中GroupID关联
}
if (!Convert.IsDBNull(dr["U_FirstCheck"]))
{
nc.U_FirstCheck = Convert.ToInt32(dr["U_FirstCheck"]); // 是否首查
}
return(nc);
}
/// <summary> /// 新增/删除/修改 sys_User /// </summary> /// <param name="fam">sys_UserTable实体类</param> /// <returns>返回0操正常</returns> public abstract int sys_UserInsertUpdate(sys_UserTable fam);
/// <summary>
/// 新增/删除/修改 sys_User
/// </summary>
/// <param name="fam">sys_UserTable实体类</param>
/// <returns>返回0操正常</returns>
public override int sys_UserInsertUpdate(sys_UserTable fam)
{
int rInt = 0;
using (SqlConnection Conn = GetSqlConnection())
{
SqlCommand cmd = new SqlCommand("sys_UserInsertUpdateDelete", Conn);
cmd.CommandType = CommandType.StoredProcedure;
//设置参数
cmd.Parameters.Add("@DB_Option_Action_", SqlDbType.NVarChar).Value = fam.DB_Option_Action_; //操作方法 Insert:增加 Update:修改 Delete:删除 Disp:显示单笔记录
cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = fam.UserID; //用户ID号
cmd.Parameters.Add("@U_LoginName", SqlDbType.NVarChar).Value = fam.U_LoginName; //登陆名
cmd.Parameters.Add("@U_Password", SqlDbType.VarChar).Value = fam.U_Password; //密码md5加密字符
cmd.Parameters.Add("@U_CName", SqlDbType.NVarChar).Value = fam.U_CName; //中文姓名
cmd.Parameters.Add("@U_EName", SqlDbType.VarChar).Value = fam.U_EName; //英文名
cmd.Parameters.Add("@U_GroupID", SqlDbType.Int).Value = fam.U_GroupID; //部门ID号与sys_Group表中GroupID关联
cmd.Parameters.Add("@U_Email", SqlDbType.VarChar).Value = fam.U_Email; //电子邮件
cmd.Parameters.Add("@U_Type", SqlDbType.Int).Value = fam.U_Type; //用户类型0:超级用户1:普通用户
cmd.Parameters.Add("@U_Status", SqlDbType.Int).Value = fam.U_Status; //当前状态0:正常 1:禁止
cmd.Parameters.Add("@U_Licence", SqlDbType.VarChar).Value = fam.U_Licence; //用户序列号
cmd.Parameters.Add("@U_Mac", SqlDbType.VarChar).Value = fam.U_Mac; //锁定机器硬件地址
cmd.Parameters.Add("@U_Remark", SqlDbType.NVarChar).Value = fam.U_Remark; //备注说明
cmd.Parameters.Add("@U_IDCard", SqlDbType.VarChar).Value = fam.U_IDCard; //身份证号码
cmd.Parameters.Add("@U_Sex", SqlDbType.Int).Value = fam.U_Sex; //性别1:男0:女
if (fam.U_BirthDay.HasValue)
{
cmd.Parameters.Add("@U_BirthDay", SqlDbType.DateTime).Value = fam.U_BirthDay; //出生日期
}
else
{
cmd.Parameters.Add("@U_BirthDay", SqlDbType.DateTime).Value = DBNull.Value; //出生日期
}
cmd.Parameters.Add("@U_MobileNo", SqlDbType.VarChar).Value = fam.U_MobileNo; //手机号
cmd.Parameters.Add("@U_UserNO", SqlDbType.VarChar).Value = fam.U_UserNO; //员工编号
if (fam.U_WorkStartDate.HasValue)
{
cmd.Parameters.Add("@U_WorkStartDate", SqlDbType.DateTime).Value = fam.U_WorkStartDate; //到职日期
}
else
{
cmd.Parameters.Add("@U_WorkStartDate", SqlDbType.DateTime).Value = DBNull.Value; //到职日期
}
if (fam.U_WorkEndDate.HasValue)
{
cmd.Parameters.Add("@U_WorkEndDate", SqlDbType.DateTime).Value = fam.U_WorkEndDate; //离职日期
}
else
{
cmd.Parameters.Add("@U_WorkEndDate", SqlDbType.DateTime).Value = DBNull.Value; //离职日期
}
cmd.Parameters.Add("@U_CompanyMail", SqlDbType.VarChar).Value = fam.U_CompanyMail; //公司邮件地址
cmd.Parameters.Add("@U_Title", SqlDbType.Int).Value = fam.U_Title; //职称与应用字段关联
cmd.Parameters.Add("@U_Extension", SqlDbType.VarChar).Value = fam.U_Extension; //分机号
cmd.Parameters.Add("@U_HomeTel", SqlDbType.VarChar).Value = fam.U_HomeTel; //家中电话
cmd.Parameters.Add("@U_PhotoUrl", SqlDbType.NVarChar).Value = fam.U_PhotoUrl; //用户照片网址
cmd.Parameters.Add("@U_DateTime", SqlDbType.DateTime).Value = fam.U_DateTime; //操作时间
cmd.Parameters.Add("@U_LastIP", SqlDbType.VarChar).Value = fam.U_LastIP; //最后访问IP
cmd.Parameters.Add("@U_LastDateTime", SqlDbType.DateTime).Value = fam.U_LastDateTime; //最后访问时间
cmd.Parameters.Add("@U_ExtendField", SqlDbType.NText).Value = fam.U_ExtendField; //扩展字段
Conn.Open();
rInt = Convert.ToInt32(cmd.ExecuteScalar());
cmd.Dispose();
Conn.Dispose();
Conn.Close();
}
return(rInt);
}
