private void UCtongxunlu_Load(object sender, EventArgs e) { //获得所有员工信息 datatable DataTable mydt = _mycontroller.GetPersonInfo(); //循环员工信息构造jjpersoninfo for (int i = 0; i < mydt.Rows.Count; i++) { var mydr = mydt.Rows[i]; JJPersonInfo mypersoninfo = new JJPersonInfo() { _huaming = mydr["花名"].ToString(), _shiming = mydr["实名"].ToString(), _bumen = mydr["部门"].ToString(), _quanxian = mydr["权限"].ToString(), _zhiji = mydr["职级"].ToString(), _shoujihao = mydr["手机号"].ToString(), _dianziyouxiang = mydr["电子邮箱"].ToString(), _zidingyizhanghao = mydr["自定义账号"].ToString(), _touxiang = mydr["头像"].ToString(), _gongzuozhengjianzhao = mydr["工作证件照"].ToString(), _weixinhao = mydr["微信号"].ToString(), _gerenqianming = mydr["个人签名"].ToString(), _dengluquan = Convert.ToInt32(mydr["登录权"].ToString()), _diaoyongguize = mydr["调用规则"].ToString(), _diaoyongchachongku = mydr["调用查重库"].ToString(), _suodingguize = mydr["锁定规则"].ToString(), _suodingchachongku = mydr["锁定查重库"].ToString(), }; //构造uctongxunluxiangqing,加载到flp种 UCtongxunluxiangqing myuc = new UCtongxunluxiangqing(mypersoninfo); flp_my.Controls.Add(myuc); } }
private void 编辑ToolStripMenuItem_Click(object sender, EventArgs e) { //获得dgv_data 当前选中行 DataGridViewRow mydr = dgv_data.CurrentRow; //构造一个jjpersoninfo JJPersonInfo myinfo = new JJPersonInfo() { _huaming = mydr.Cells["花名"].Value.ToString(), _shiming = mydr.Cells["实名"].Value.ToString(), _bumen = mydr.Cells["部门"].Value.ToString(), _zhiji = mydr.Cells["职级"].Value.ToString(), _mima = mydr.Cells["密码"].Value.ToString(), _shoujihao = mydr.Cells["手机号"].Value.ToString(), _dianziyouxiang = mydr.Cells["电子邮箱"].Value.ToString(), _zidingyizhanghao = mydr.Cells["自定义账号"].Value.ToString(), _touxiang = mydr.Cells["头像"].Value.ToString(), _gongzuozhengjianzhao = mydr.Cells["工作证件照"].Value.ToString(), _weixinhao = mydr.Cells["微信号"].Value.ToString(), _gerenqianming = mydr.Cells["个人签名"].Value.ToString() }; //构造一个wfzhuce,把jjpersoninfo传进去 WFzhuce mywin = new WFzhuce(myinfo); //刷新dgv_data if (mywin.ShowDialog() == DialogResult.OK) { UCshouquan_Load(null, null); } }
public UCtongxunluxiangqing(JJPersonInfo personinfo) { InitializeComponent(); _jjpi = personinfo; this.lbl_xingming.Text = $"名字:{personinfo._shiming}"; this.lbl_zhiwu.Text = $"职级职务:{personinfo._zhiji}"; this.lbl_lianxifangshi.Text = $"手机号码:{personinfo._shoujihao}"; Image img = ConvertBase64ToImage(personinfo._touxiang); pb_touxiang.Image = img; }
/// <summary> /// 构造函数,展示当前选中person窗口 /// </summary> /// <param name="i"></param> public WFzhuce(JJPersonInfo pi) { InitializeComponent(); tb_huaming.Text = pi._huaming; tb_shoujihao.Text = pi._shoujihao; tb_shiming.Text = pi._shiming; tb_zidingyi.Text = pi._zidingyizhanghao; tb_bumen.Text = pi._bumen; tb_shurumima.Text = pi._mima; tb_querenmima.Text = pi._mima; tb_zhiji.Text = pi._zhiji; pb_touxiang.Image = JJImageHelper.ConvertBase64ToImage(pi._touxiang); pb_gongzuozheng.Image = JJImageHelper.ConvertBase64ToImage(pi._gongzuozhengjianzhao); tb_weixinhao.Text = pi._weixinhao; tb_dianziyouxiang.Text = pi._dianziyouxiang; tb_gerenqianming.Text = pi._gerenqianming; }
/// <summary> /// 点击保存按钮时触发的事件 /// </summary> /// <returns></returns> public bool BaocunInfo(JJPersonInfo p) { //判断花名,如果已经存在,使用update语句,如果不存在使用insertinto语句 string str_sql = $"select count(*) from jjdbrenwutaizhang.jjperson where 花名='{p._huaming}' and 删除=0"; int num0 = Convert.ToInt32(mysqlhelper.ExecuteScalar(str_sql)); if (num0 > 0) { str_sql = $"update jjdbrenwutaizhang.jjperson set 实名='{p._shiming}',部门='普通员工','{p._bumen}',部门,职级='{p._zhiji}',密码='{p._mima}',手机号='{p._shoujihao}',电子邮箱='{p._dianziyouxiang}'," + $"自定义账号='{p._zidingyizhanghao}',密码='{p._mima}',头像='{p._touxiang}',工作证件照='{p._gongzuozhengjianzhao}',微信号='{p._weixinhao}',个人签名='{p._gerenqianming}' where 花名='{JJLoginInfo._huaming}'"; } else { str_sql = $"insert into jjdbrenwutaizhang.jjperson values('{p._huaming}','{p._shiming}','{p._bumen}'," + $"'普通用户','{p._zhiji}','{p._mima}','{p._shoujihao}','{p._dianziyouxiang}'," + $"'{p._zidingyizhanghao}','{p._touxiang}','{p._gongzuozhengjianzhao}','{p._weixinhao}',0,'{p._gerenqianming}',1,'','','','')"; } int num = mysqlhelper.ExecuteNonQuery(str_sql, null); return(num > 0 ? true : false); }
/// <summary> /// 点击注册按钮时出发的事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_zhuce_Click(object sender, EventArgs e) { //获得输入密码和确认密码 string shurumima = tb_shurumima.Text; string querenmima = tb_querenmima.Text; //判断密码是否相同 if (!shurumima.Equals(querenmima)) { tb_shurumima.Clear(); tb_querenmima.Clear(); MessageBox.Show("两次输入的密码不匹配!"); return; } //构造一个personinfo类 JJPersonInfo myinfo = new JJPersonInfo() { _huaming = tb_huaming.Text.Trim(), _shiming = tb_shiming.Text.Trim(), _shoujihao = tb_shoujihao.Text.Trim(), _bumen = tb_bumen.Text.Trim(), _zhiji = tb_zhiji.Text.Trim(), _dianziyouxiang = tb_dianziyouxiang.Text.Trim(), //_shurumima = tb_shurumima.Text.Trim(), //_querenmima = tb_querenmima.Text.Trim(), _mima = tb_querenmima.Text.Trim(), _zidingyizhanghao = tb_zidingyi.Text.Trim(), _touxiang = JJImageHelper.ConvertImageToBase64(pb_touxiang.Image), _gongzuozhengjianzhao = JJImageHelper.ConvertImageToBase64(pb_gongzuozheng.Image), _weixinhao = tb_weixinhao.Text.Trim(), _gerenqianming = tb_gerenqianming.Text.Trim() }; //保存到数据库中,update语句 bool b = _mycontroller.BaocunInfo(myinfo); //如果保存成功,赋值给 jjlogininfo if (b) { JJLoginInfo._huaming = tb_huaming.Text.Trim(); JJLoginInfo._shiming = tb_shiming.Text.Trim(); JJLoginInfo._shoujihao = tb_shoujihao.Text.Trim(); JJLoginInfo._bumen = tb_bumen.Text.Trim(); JJLoginInfo._zhiji = tb_zhiji.Text.Trim(); JJLoginInfo._dianziyouxiang = tb_dianziyouxiang.Text.Trim(); JJLoginInfo._mima = tb_querenmima.Text.Trim(); //JJLoginInfo._shurumima = tb_shurumima.Text.Trim(); //JJLoginInfo._querenmima = tb_querenmima.Text.Trim(); JJLoginInfo._zidingyizhanghao = tb_zidingyi.Text.Trim(); JJLoginInfo._touxiang = JJImageHelper.ConvertImageToBase64(pb_touxiang.Image); JJLoginInfo._gongzuozhengjianzhao = JJImageHelper.ConvertImageToBase64(pb_gongzuozheng.Image); JJLoginInfo._weixinhao = tb_weixinhao.Text.Trim(); JJLoginInfo._gerenqianming = tb_gerenqianming.Text.Trim(); MessageBox.Show("保存成功!"); this.DialogResult = DialogResult.OK; } //判断是否有没填写的项目 //if (myinfo._huaming.Equals(string.Empty) || shiming.Equals(string.Empty) || shoujihao.Equals(string.Empty) || // myinfo._bumen.Equals(string.Empty) || touxiang == null || weixinhao.Equals(string.Empty) || dianziyouxiang.Equals(string.Empty) || // myinfo._shurumima.Equals(string.Empty) || // myinfo._querenmima.Equals(string.Empty) || gerenqianming.Equals(string.Empty)) //{ // MessageBox.Show("请输入完整信息!"); //} ////判断花名是否已经被注册 //bool existhuaming = _mycontroller.ExistsHuaming(huaming); //if (existhuaming) //{ // lbl_cunzai.Text = "花名有主"; // return; //} //else //{ // lbl_cunzai.Text = "可以捷足先登"; //} //判断自定义账号是否已经被注册 //string zhanghao = tb_zidingyi.Text.Trim(); //if (!zhanghao.Equals(string.Empty)) //{ // bool existzhanghao = _mycontroller.ExistsZidingyi(zhanghao); // if (existzhanghao) // { // lbl_zhanghaocunzai.Text = "账号有主"; // return; // } // else // { // lbl_zhanghaocunzai.Text = "可以捷足先登"; // } //} //构造dic //Dictionary<string, string> dic = new Dictionary<string, string>() { // {"花名",huaming }, // {"实名",shiming }, // {"部门",bumen }, // {"职级",zhiji }, // {"密码",querenmima }, // {"手机号",shoujihao }, // {"电子邮箱",dianziyouxiang }, // {"自定义账号",zidingyizhanghao }, // {"头像",_mycontroller.ConvertImageToBase64(touxiang)},//把图片转换成base64 // { "工作证件照",string.Empty}, // {"微信号",weixinhao } //}; //if (zhengjianzhao != null) //{ // dic["工作证件照"] = _mycontroller.ConvertImageToBase64(zhengjianzhao); //} //bool b = _mycontroller.Zhuce(dic); //if (b) MessageBox.Show("注册成功!"); //this.Dispose(); }
/// <summary> /// 点击注册按钮时出发的事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btn_zhuce_Click(object sender, EventArgs e) { //获得输入密码和确认密码 string shurumima = tb_shurumima.Text; string querenmima = tb_querenmima.Text; //检测必填项目是否有空 if (tb_shiming.Text.Trim().Equals(string.Empty)) { MessageBox.Show("请填写实名!"); return; } if (!Regex.IsMatch(tb_shoujihao.Text, @"\d{11}")) { MessageBox.Show("手机号格式不正确!"); return; } if (tb_shurumima.Text.Trim().Equals(string.Empty) || tb_querenmima.Text.Trim().Equals(string.Empty)) { MessageBox.Show("密码不能为空!"); return; } //判断密码是否相同 if (!shurumima.Equals(querenmima)) { tb_shurumima.Clear(); tb_querenmima.Clear(); MessageBox.Show("两次输入的密码不匹配!"); return; } if (tb_bumen.Text.Trim().Equals(string.Empty)) { MessageBox.Show("请选择部门!"); return; } if (tb_weixinhao.Text.Trim().Equals(string.Empty)) { MessageBox.Show("请填写微信号!"); return; } if (tb_dianziyouxiang.Text.Trim().Equals(string.Empty)) { MessageBox.Show("请填写电子邮箱!"); return; } //构造一个personinfo类 JJPersonInfo myinfo = new JJPersonInfo() { _huaming = tb_huaming.Text.Trim(), _shiming = tb_shiming.Text.Trim(), _shoujihao = tb_shoujihao.Text.Trim(), _bumen = tb_bumen.Text.Trim(), _zhiji = tb_zhiji.Text.Trim(), _dianziyouxiang = tb_dianziyouxiang.Text.Trim(), //_shurumima = tb_shurumima.Text.Trim(), //_querenmima = tb_querenmima.Text.Trim(), _mima = tb_querenmima.Text.Trim(), _zidingyizhanghao = tb_zidingyi.Text.Trim(), _touxiang = JJImageHelper.ConvertImageToBase64(pb_touxiang.Image), _gongzuozhengjianzhao = JJImageHelper.ConvertImageToBase64(pb_gongzuozheng.Image), _weixinhao = tb_weixinhao.Text.Trim(), _gerenqianming = tb_gerenqianming.Text.Trim() }; //保存到数据库中,update语句 bool b = _mycontroller.BaocunInfo(myinfo); //如果保存成功,赋值给 jjlogininfo if (b) { JJLoginInfo.GetLoginInfo(JJLoginInfo._huaming); MessageBox.Show("保存成功!"); this.DialogResult = DialogResult.OK; } }