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