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;
}
}
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>
/// 构造函数，展示当前登录信息窗口
/// </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();
}
