private void btn_chuangjian_Click(object sender, EventArgs e) { //构造一个团队信息类 JJTuanduiInfo myinfo = new JJTuanduiInfo() { _mingcheng = tb_mingcheng.Text.Trim(), _fuzeren = tb_fuzeren.Text.Trim(), _chengyuan = tb_chengyuan.Text.Trim(), _tuanduitupian = JJImageHelper.ConvertImageToBase64(pb_zhaopian.Image), _gongzuolingyu = tb_lingyu.Text.Trim() }; if (myinfo._mingcheng.Equals(string.Empty)) { MessageBox.Show("团队名不能为空!"); return; } //添加团队名称,负责人,成员到数据库 bool bb = mycontroller.InsertTuandui(myinfo); //提示是否保存成功 if (bb) { MessageBox.Show("团队创建成功!"); } //刷新父窗体 //dialog.result赋值 this.DialogResult = DialogResult.OK; }
public WFtuandui(JJTuanduiInfo myinfo) { InitializeComponent(); this.tb_mingcheng.Text = myinfo._mingcheng; this.tb_fuzeren.Text = myinfo._fuzeren; this.tb_chengyuan.Text = myinfo._chengyuan; this.pb_zhaopian.Image = JJImageHelper.ConvertBase64ToImage(myinfo._tuanduitupian); this.tb_lingyu.Text = myinfo._gongzuolingyu; }
private void pb_tianjiagongzuozhao_Click(object sender, EventArgs e) { //打开文件 OpenFileDialog ofd = new OpenFileDialog(); if (ofd.ShowDialog() == DialogResult.OK) { Bitmap mybmp = new Bitmap(ofd.FileName); var newbmp = JJImageHelper.UpdateImageSize(mybmp, 256, 256); pb_gongzuozheng.Image = newbmp; } }
public UCtuanduixiagnqing(JJTuanduiInfo myinfo) { InitializeComponent(); _tuanduiinfo = myinfo; //赋值控件值 this.lbl_tuanduimingcheng.Text = myinfo._mingcheng; this.lbl_fuzeren.Text = myinfo._fuzeren; var list_chengyuan = Regex.Split(myinfo._chengyuan, ",").ToList(); list_chengyuan.Remove(""); this.lbl_renshu.Text = list_chengyuan.Count.ToString(); this.pb_tuandui.Image = JJImageHelper.ConvertBase64ToImage(myinfo._tuanduitupian); }
private void lbl_shangchuan_Click(object sender, EventArgs e) { //打开文件选择 OpenFileDialog ofd = new OpenFileDialog(); if (ofd.ShowDialog() == DialogResult.OK) { //文件转化成图片 Image img = Image.FromFile(ofd.FileName); //图片改变尺寸 Image newimg = JJImageHelper.UpdateImageSize(img, 256, 256); //显示在image中 pb_zhaopian.Image = newimg; } }
/// <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> /// <param name="i"></param> public WFzhuce(int i) { InitializeComponent(); tb_huaming.Text = JJLoginInfo._huaming; tb_shoujihao.Text = JJLoginInfo._shoujihao; tb_shiming.Text = JJLoginInfo._shiming; tb_zidingyi.Text = JJLoginInfo._zidingyizhanghao; tb_bumen.Text = JJLoginInfo._bumen; tb_zhiji.Text = JJLoginInfo._zhiji; //获得头像和额工作证件头像,然后进行缩小处理 //var pt= JJImageHelper.ConvertBase64ToImage(JJLoginInfo._touxiang); //pb_touxiang.Image = JJImageHelper.UpdateImageSize(pt, 256, 256); pb_touxiang.Image = JJImageHelper.ConvertBase64ToImage(JJLoginInfo._touxiang);; var pg = JJImageHelper.ConvertBase64ToImage(JJLoginInfo._gongzuozhengjianzhao); pb_gongzuozheng.Image = JJImageHelper.UpdateImageSize(pg, 128, 128); tb_weixinhao.Text = JJLoginInfo._weixinhao; tb_dianziyouxiang.Text = JJLoginInfo._dianziyouxiang; tb_gerenqianming.Text = JJLoginInfo._gerenqianming; tb_shurumima.Text = JJLoginInfo._mima; tb_querenmima.Text = JJLoginInfo._mima; }
/// <summary> /// 获得花名对应的登陆人员信息 /// </summary> /// <param name="huaming"></param> /// <returns></returns> public static void GetLoginInfo(string str) { string str_sql = string.Empty; //判断uid是账号还是邮箱,还是电话,从而给出不同的strsql字符串 if (str.Contains("@")) { str_sql = $"select * from jjdbrenwutaizhang.jjperson where 电子邮箱='{str}' and 删除=0"; } else if (Regex.IsMatch(str, @"\d{11}")) { str_sql = $"select * from jjdbrenwutaizhang.jjperson where 手机号='{str}' and 删除=0"; } else { str_sql = $"select * from jjdbrenwutaizhang.jjperson where 花名='{str}' and 删除=0"; } var mydr = _mysqlhelper.ExecuteDataRow(str_sql); JJLoginInfo._huaming = mydr["花名"].ToString(); JJLoginInfo._shiming = mydr["实名"].ToString(); JJLoginInfo._bumen = mydr["部门"].ToString(); JJLoginInfo._quanxian = mydr["权限"].ToString(); JJLoginInfo._zhiji = mydr["职级"].ToString(); JJLoginInfo._mima = mydr["密码"].ToString(); JJLoginInfo._shoujihao = mydr["手机号"].ToString(); JJLoginInfo._dianziyouxiang = mydr["电子邮箱"].ToString(); JJLoginInfo._zidingyizhanghao = mydr["自定义账号"].ToString(); JJLoginInfo._touxiang = mydr["头像"].ToString(); var pt = JJImageHelper.ConvertBase64ToImage(JJLoginInfo._touxiang); _form1.pb_touxiang.Image = JJImageHelper.UpdateImageSize(pt, 128, 128); JJLoginInfo._gongzuozhengjianzhao = mydr["工作证件照"].ToString(); JJLoginInfo._weixinhao = mydr["微信号"].ToString(); JJLoginInfo._gerenqianming = mydr["个人签名"].ToString(); JJLoginInfo._denlguquan = Convert.ToInt32(mydr["登录权"].ToString()); //调用查重库和规则,暂时开放所有权限 //LoginInfo._diaoyongchachongku = mydr["调用查重库"].ToString(); //LoginInfo._diaoyongguize = mydr["调用规则"].ToString(); str_sql = $"select 名称 from jjdbwenbenjiexi.规则信息表 where 删除=0"; var dt = _mysqlhelper.ExecuteDataTable(str_sql); List <string> list = new List <string>(); for (int i = 0; i < dt.Rows.Count; i++) { list.Add(dt.Rows[i]["名称"].ToString()); } JJLoginInfo._diaoyongguize = string.Join("|", list); str_sql = $"select 名称 from jjdbwenbenjiexi.查重库信息表 where 删除=0"; dt = _mysqlhelper.ExecuteDataTable(str_sql); list = new List <string>(); for (int i = 0; i < dt.Rows.Count; i++) { list.Add(dt.Rows[i]["名称"].ToString()); } JJLoginInfo._diaoyongchachongku = string.Join("|", list); JJLoginInfo._suodingguize = mydr["锁定规则"].ToString(); JJLoginInfo._suodingchachongku = mydr["锁定查重库"].ToString(); }
/// <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; } }