//保存 private void Btn_Save_Click(object sender, EventArgs e) { D_User UsersItem = new D_User(); UsersItem.Code = this.Tb_Code.Text.Trim(); UsersItem.Name = this.Tb_Name.Text.Trim(); UsersItem.Uid = this.Tb_Uid.Text.Trim(); UsersItem.Pwd = this.Tb_Pwd.Text.Trim(); UsersItem.Role = this.Cmb_Role.SelectedValue.ToString(); UsersItem.Used = this.Cb_Used.Checked; if (UsersItem.Code == "" || UsersItem.Name == "" || UsersItem.Uid == "" || UsersItem.Pwd == "") { Function.MessageWarning("请把数据填写完整!"); return; } if (UsersItem.Role == "0") { Function.MessageWarning("请选择用户角色!"); return; } if (!Function.IsRegEx("^[a-zA-Z0-9]{2,12}$", UsersItem.Uid)) { Function.MessageWarning("用户名必须是2-12位的字母或数字!"); return; } if (!Function.IsRegEx("^[a-zA-Z0-9]{3,32}$", UsersItem.Pwd)) { Function.MessageWarning("用户密码格式不正确,应是3-12位的字母或数字!"); return; } if (Function.CheckKey("D_User", "Code", UsersItem.Code, Id)) { Function.MessageWarning("该编号已存在!"); return; } if (Function.CheckKey("D_User", "Uid", UsersItem.Uid, Id)) { Function.MessageWarning("该用户名已存在!"); return; } UsersItem.Pwd = BaseClass.Function.Md5(UsersItem.Pwd); if (Id== 0) { if (UsersBLL.Insert(UsersItem)) { Function.Message("添加成功!"); ResetData(); DataBind(); } } else { UsersItem.Id = Id; if (UsersBLL.Update(UsersItem)) { Function.Message("修改成功!"); DataBind(); } } }
//保存 private void Btn_Save_Click(object sender, EventArgs e) { D_User UsersItem = new D_User(); UsersItem.Id = LUser.Id; UsersItem.OldPwd = this.Tb_OldPwd.Text.Trim().Replace("'", ""); UsersItem.Pwd = this.Tb_Pwd.Text.Trim().Replace("'", ""); UsersItem.CheckPwd = this.Tb_CheckPwd.Text.Trim().Replace("'", ""); if (UsersItem.OldPwd == "" || UsersItem.Pwd == "" || UsersItem.CheckPwd == "") { Function.MessageWarning("请把信息填写完整!"); return; } if (!UsersBLL.CheckPwd(Function.Md5(UsersItem.OldPwd))) { Function.MessageWarning("原始密码不正确!"); return; } if (!Function.IsRegEx("^[a-zA-Z0-9]{3,32}$", UsersItem.Pwd)) { Function.MessageWarning("用户密码格式不正确,应是3-12位的字母或数字!"); return; } if (UsersItem.Pwd != UsersItem.CheckPwd) { Function.MessageWarning("两次输入密码不一致!"); return; } UsersItem.Pwd = Function.Md5(UsersItem.Pwd); if (UsersBLL.RePwd(UsersItem)) { Function.Message("密码修改成功!"); this.Close(); } }
//��½ private void Btn_Login_Click(object sender, EventArgs e) { D_User UsersItem = new D_User(); UsersItem.Uid = this.Tb_Uid.Text.Trim(); UsersItem.Pwd = this.Tb_Pwd.Text.Trim(); if (UsersItem.Uid == "" || UsersItem.Pwd == "") { Function.MessageWarning("�û��������벻����Ϊ�գ�"); return; } UsersItem.Pwd = Function.Md5(UsersItem.Pwd); if (UsersBLL.UserLogin(UsersItem)) { BLL.PublicFun.IniFile Ini = new BLL.PublicFun.IniFile(WSV.Model.FilePath.Config); if (Ini.ExistIniFile()) { Ini.IniWriteValue("systemload", "username", Tb_Uid.Text); } this.DialogResult = DialogResult.OK; } else { Function.MessageWarning("�û��������벻��ȷ��"); } }
/// <summary> /// 用户登陆 /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static bool UserLogin(D_User Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new UsersDAL(); bool Flag = false; SqlParameter[] prams ={ db.MakeInParam("@Uid",SqlDbType.VarChar,50,Item.Uid), db.MakeInParam("@Pwd",SqlDbType.VarChar,50,Item.Pwd) }; try { DataSet ds = new DataSet(); ds = db.ReturnDataSet(visitor, prams, "UserLogin"); DataRowCollection drc = ds.Tables[0].Rows; if (drc.Count > 0) { DataRow dr = drc[0]; CUser.Id = Convert.ToInt64(dr["Id"]); CUser.Code = dr["Code"].ToString(); CUser.Uid = dr["Uid"].ToString(); CUser.Name = dr["Name"].ToString(); CUser.Role = dr["Role"].ToString(); //PublicFun.IniFile Ini = new PublicFun.IniFile(WSV.Model.FilePath.Config); //if (Ini.ExistIniFile()) //{ // LUser.TableNum = Ini.IniReadValue("LoadoMeter", "TableNum"); //} //ds = WSV.BLL.SysInfo.LoadoMeterBLL.SelectAll(" where TableNum='" + LUser.TableNum + "'"); //drc = ds.Tables[0].Rows; //if (drc.Count > 0) //{ // dr = drc[0]; // LUser.TableName = dr["Name"].ToString(); // LUser.Ip = dr["Ip"].ToString(); // LUser.Port = dr["Port"].ToString(); //} //else //{ // LUser.TableNum = ""; //} Flag = true; } } catch (Exception ex) { throw ex; } finally { db.Dispose(); } return Flag; }
/// <summary> /// 修改数据 /// </summary> /// <param name="Item">model</param> /// <returns></returns> public static bool Update(D_User Item) { DataBase db = new DataBase(); DataBaseVisitor visitor = new UsersDAL(); bool Flag= false,ReFlag=false; int N= 0; SqlParameter[] prams ={ db.MakeInParam("@Code", SqlDbType.VarChar,50, Item.Code), db.MakeInParam("@Name", SqlDbType.VarChar,50, Item.Name), db.MakeInParam("@Uid", SqlDbType.VarChar,50, Item.Uid), db.MakeInParam("@Pwd", SqlDbType.VarChar,50, Item.Pwd), db.MakeInParam("@Role", SqlDbType.VarChar,50, Item.Role), db.MakeInParam("@Used", SqlDbType.Bit,0, Item.Used), db.MakeInParam("@Id", SqlDbType.BigInt,0,Item.Id) }; try { ReFlag= db.TransactSql(visitor, "Update", prams, out N); } catch (Exception ex) { throw ex; } finally { db.Dispose(); } if (ReFlag && N > 0) { Flag = true; } return Flag; }