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;
}
}
