/// <summary>
/// 点击保存按钮时触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lbl_baocun_Click(object sender, EventArgs e)
{
//构造qingjaiinfo
JJTaskInfo myinfo = new JJTaskInfo()
{
_shiyou = tb_shiyou.Text,
_jinjichengdu = rb_putong.Checked ? "普通" : "紧急",
_qingjiatianshu = Convert.ToInt32(tb_qingjaitianshu.Text),
_qizhishijian = $"{dtp_start.Value.ToString()}|{dtp_end.Value.ToString()}",
_weituoduixiang = tb_weituoren.Text,
_shenherenyuan = tb_shenherenyuan.Text,
_shenheyijian = tb_shenheyijian.Text,
_xiaojiaqingkuang = tb_xiaojiaqingkuang.Text,
_chuangjianshijian = DateTime.Now.ToString(),
_chuangjianren = JJLoginInfo._shiming,
_leixing = "请休假单",
_zhuangtai = "保存"
};
//保存
bool b = _mycontroller.SaveQingxiujia(myinfo);
if (b)
{
JJMethod.a_checknewtask(null, null);
MessageBox.Show("保存成功!");
this.DialogResult = DialogResult.OK;
}
}
private void link_bianji_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
//获得通知公告表中标题对应的信息，实例化一个jjtongzhiinfo
string biaoti = lbl_mingcheng.Text;
string leixing = lbl_leixing.Text;
//实例化一个mftongzhigonggao，把jjtongzhiinfo传递进来，mftongzhigonggao的状态设置为编辑模式（还有一个是创建模式）
string str_sql = $"select * from jjdbrenwutaizhang.通知公告表 " +
$"where 标题='{biaoti}'";
DataTable mydt = _mysql.ExecuteDataTable(str_sql);
List <string> list_fanwei = new List <string>();
foreach (DataRow dataRow in mydt.Rows)
{
list_fanwei.Add(dataRow["阅读范围"].ToString());
}
JJTongzhiInfo myinfo = new JJTongzhiInfo()
{
_biaoti = mydt.Rows[0]["标题"].ToString(),
_qianfaren = mydt.Rows[0]["签发人"].ToString(),
_qingzhonghuanji = mydt.Rows[0]["轻重缓急"].ToString(),
_neirongpath = mydt.Rows[0]["内容"].ToString(),
_shixian = mydt.Rows[0]["时限"].ToString(),
_fujian = mydt.Rows[0]["附件"].ToString(),
_chuangjianren = mydt.Rows[0]["创建人"].ToString(),
_yuedufanwei = string.Join(",", list_fanwei)
};
WFtongzhigonggao mywin = new WFtongzhigonggao(myinfo);
mywin.mode = "编辑";
if (mywin.ShowDialog() == DialogResult.OK)
{
JJMethod.a_shuaxinzhuye(null, null);
}
}
private void lbl_baocun_Click(object sender, EventArgs e)
{
//构造一个jjtongzhiinfo
JJTaskInfo myinfo = new JJTaskInfo
{
_biaoti = tb_biaoti.Text,
_chuangjianren = JJLoginInfo._shiming,
_fankuiduixiang = tb_fankuiduixiang.Text,
_neirong = tb_neirong.Text,
_chuangjianshijian = DateTime.Now.ToString(),
_jinjichengdu = rb_jinji.Checked == true ? "紧急" : "普通",
_chuliyijian = tb_chuliyijian.Text,
_leixing = "意见建议",
_zhuangtai = "保存"
};
//保存jjtonzhiinfo
bool b = _mycontroller.SaveYijian(myinfo);
if (b)
{
JJMethod.a_checknewtask(null, null);
MessageBox.Show("保存成功！");
}
}
/// <summary>
/// 点击钉子按钮时触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void pb_dingzi_Click(object sender, EventArgs e)
{
WinForm.WFgongzuoqingdan mywinform = new WinForm.WFgongzuoqingdan();
if (mywinform.ShowDialog() == DialogResult.OK)
{
JJMethod.a_shuaxinzhuye(null, null);
}
}
private async void WinFormTongzhi_Load(object sender, EventArgs e)
{
//下载到临时文件，然后加载到richtextbox
await JJMethod.DownLoadFileAsync(myinfo._neirongpath, ".\\temp.rtf");
richTextBox1.LoadFile(".\\temp.rtf");
//获得标题下所有人员，获得已读和未读人员，刷新未读panel
UpdatePanelWeidu();
}
/// <summary>
/// 点击发送办理按钮时触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void label10_Click(object sender, EventArgs e)
{
//再发送之前先保存任务信息
//构造qingjaiinfo
JJTaskInfo myinfo = new JJTaskInfo()
{
_shiyou = tb_shiyou.Text,
_jinjichengdu = rb_putong.Checked ? "普通" : "紧急",
_qingjiatianshu = Convert.ToInt32(tb_qingjaitianshu.Text),
_qizhishijian = $"{dtp_start.Value.ToString()}|{dtp_end.Value.ToString()}",
_weituoduixiang = tb_weituoren.Text,
_shenherenyuan = tb_shenherenyuan.Text,
_shenheyijian = tb_shenheyijian.Text,
_xiaojiaqingkuang = tb_xiaojiaqingkuang.Text,
_chuangjianshijian = DateTime.Now.ToString(),
_chuangjianren = JJLoginInfo._shiming,
_leixing = "请休假单",
_zhuangtai = "保存"
};
//保存
bool b = _mycontroller.SaveQingxiujia(myinfo);
//分解委托对象
string[] arr_weituoduixiang = Regex.Split(tb_weituoren.Text, ",");
//分解审核人员
string[] arr_shenherenyuan = Regex.Split(tb_shenherenyuan.Text, ",");
foreach (string weituoren in arr_weituoduixiang)
{
foreach (string shenheduixiang in arr_shenherenyuan)
{
//构造一个jjtongzhiinfo
JJTaskInfo info = new JJTaskInfo
{
_shiyou = tb_shiyou.Text,
_jinjichengdu = rb_putong.Checked ? "普通" : "紧急",
_qingjiatianshu = Convert.ToInt32(tb_qingjaitianshu.Text),
_qizhishijian = $"{dtp_start.Value.ToString()}|{dtp_end.Value.ToString()}",
_weituoduixiang = weituoren,
_shenherenyuan = shenheduixiang,
_shenheyijian = tb_shenheyijian.Text,
_xiaojiaqingkuang = tb_xiaojiaqingkuang.Text,
_fasongshijian = DateTime.Now.ToString(),
_fasongren = JJLoginInfo._shiming,
_leixing = "请休假单",
_zhuangtai = "未读"
};
//拆解反馈对象，对每一个对象，向任务信息表中插入一条jjtaskinfo
b = _mycontroller.FasongBanli(info);
}
}
JJMethod.a_checknewtask(null, null);
MessageBox.Show("发送办理成功！");
}
/// <summary>
/// 点击删除图片时触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lbl_shanchu_Click(object sender, EventArgs e)
{
//工作清单删除=0
bool b = _myc.DeleteGongzuoqingdan(task);
if (b)
{
JJMethod.a_shuaxinzhuye(null, null);
MessageBox.Show("工作清单已删除！");
}
}
/// <summary>
/// 点击销项按钮时触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lbl_xiaoxiang_Click(object sender, EventArgs e)
{
//显示心得体会窗口
WinFormXiaoxiang mywin = new WinFormXiaoxiang(task)
{
StartPosition = FormStartPosition.CenterParent
};
//刷新数据
if (mywin.ShowDialog() == DialogResult.OK)
{
JJMethod.a_shuaxinzhuye(null, null);
}
}
/// <summary>
/// 点击发送办理按钮时触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_fasongbanli_Click(object sender, EventArgs e)
{
//发送任务之前，需要先保存任务信息，方便打开的时候调用
//构造一个jjtongzhiinfo
JJTaskInfo myinfo = new JJTaskInfo
{
_mingcheng = tb_renwumingcheng.Text,
_jinjichengdu = rb_jinji.Checked == true ? "紧急" : "普通",
_jutiyaoqiu = tb_jutiyaoqiu.Text,
_fujian = string.Join("|", uCfujian1.list_fujian),
_shixian = dtp_shixian.Value.ToString("yyyy-MM-dd hh:mm:ss"),
_banliyijian = tb_banliyijian.Text,
_banlirenyuan = tb_banlirenyuan.Text,
_jinzhanqingkuang = tb_jinzhanqingkuang.Text,
_chuangjianshijian = DateTime.Now.ToString(),
_chuangjianren = JJLoginInfo._shiming,
_leixing = "常规事项",
_zhuangtai = "保存"
};
//添加任务
bool b = mycontroller.AddTask(myinfo);
//分解办理人员
string[] arr_banlirenyuan = Regex.Split(tb_banlirenyuan.Text, ",");
foreach (string s in arr_banlirenyuan)
{
//构造一个jjtongzhiinfo
myinfo = new JJTaskInfo
{
_mingcheng = tb_renwumingcheng.Text,
_jinjichengdu = rb_jinji.Checked == true ? "紧急" : "普通",
_jutiyaoqiu = tb_jutiyaoqiu.Text,
_fujian = string.Join("|", uCfujian1.list_fujian),
_shixian = dtp_shixian.Value.ToString("yyyy-MM-dd hh:mm:ss"),
_banliyijian = tb_banliyijian.Text,
_banlirenyuan = s,
_jinzhanqingkuang = tb_jinzhanqingkuang.Text,
_fasongshijian = DateTime.Now.ToString(),
_fasongren = JJLoginInfo._shiming,
_leixing = "常规事项",
_zhuangtai = "未读"
};
//拆解反馈对象，对每一个对象，向任务信息表中插入一条jjtaskinfo
b = mycontroller.FasongBanli(myinfo);
}
JJMethod.a_checknewtask(null, null);
MessageBox.Show("发送办理成功！");
}
private async void pb_shangchuan_Click(object sender, EventArgs e)
{
pb_shangchuangongxiang.Visible = true;
pb_shangchuangeren.Visible = false;
//上传共享文件
OpenFileDialog ofd = new OpenFileDialog();
if (ofd.ShowDialog() == DialogResult.OK)
{
string file = Path.GetFileName(ofd.FileName);
JJFujianInfo info = new JJFujianInfo()
{
_wenjianming = file,
_chuangjianren = JJLoginInfo._shiming,
_quanlujing = $"{uripath}/{file}",
_chuangjianshijian = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"),
_xiazaicishu = 0,
_kejian = string.Empty,
_leixing = "共享"
};
//添加控件，显示正在上传
UCfujianInfo myuc = new UCfujianInfo(info)
{
Dock = DockStyle.Top
};
panel_fujian.Controls.Add(myuc);
Application.DoEvents();
//开始上传
myuc.lbl_info.Visible = true;
myuc.lbl_info.Text = "正在上传……";
Application.DoEvents();
//UpSound_Request(uripath, ofd.FileName, "xxx.zip", progressBar1);
await JJMethod.UpLoadFile(ofd.FileName, uripath, false);
InsertFile(info);
//上传完之后，不显示正在上传
myuc.lbl_info.Text = string.Empty;
myuc.lbl_info.Visible = false;
}
}
/// <summary>
/// 点击删除按钮时出发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void link_shanchu_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
//显示提示框，是否确认删除
DialogResult mydr = MessageBox.Show("确认删除?", "删除信息", MessageBoxButtons.YesNo);
if (mydr == DialogResult.Yes)
{
//从通知公告表中删除通知
string name = lbl_mingcheng.Text;
string str_sql = $"delete from jjdbrenwutaizhang.通知公告表 where 标题='{name}'";
_mysql.ExecuteNonQuery(str_sql);
//刷新主界面
JJMethod.a_shuaxinzhuye(null, null);
//显示删除成功
MessageBox.Show("通知公告已删除！");
}
}
private async void UCfujianInfo_Load(object sender, EventArgs e)
{
if (_myinfo == null)
{
//判断文件是否存在，如果不存在上传，显示已上传，如果已经存在，直接显示已上传
bool exist = ExistFile(path);
lbl_wenjianming.Text = file;
if (!exist)
{
JJFujianInfo info = new JJFujianInfo()
{
_wenjianming = file,
_chuangjianren = JJLoginInfo._shiming,
_leixing = "共享",
_quanlujing = path,
_chuangjianshijian = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"),
_xiazaicishu = 0,
};
InsertFile(info);
lbl_info.Text = "正在上传……";
await JJMethod.UpLoadFile(_filename, uripath, false);
}
lbl_info.Text = "已上传!";
}
else
{
lbl_wenjianming.Text = _myinfo._wenjianming;
lbl_chuangjianren.Text = _myinfo._chuangjianren;
lbl_chuangjianren.Visible = true;
lbl_shijian.Text = _myinfo._chuangjianshijian;
lbl_shijian.Visible = true;
lbl_xiazai.Visible = true;
lbl_info.Visible = false;
pb_guanbi.Visible = false;
//共享文件可以看见垃圾桶,非共享文件可以
if (!_myinfo._leixing.Equals("共享"))
{
pb_shanchu.Visible = true;
}
//创建人上传的共享任务可以设置可见范围，显示眼睛
if (JJLoginInfo._shiming.Equals(_myinfo._chuangjianren) && _myinfo._leixing.Equals("共享"))
{
pb_kejian.Visible = true;
}
}
}
private async void btn_xiazai_Click(object sender, EventArgs e)
{
try
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "Excel 97~2003工作簿|*.xls|Excel 工作簿|*.xlsx";
if (sfd.ShowDialog() == DialogResult.OK)
{
string filename = "http://49.233.40.109/标准表格.xlsx";
await JJMethod.DownLoadFileAsync(filename, sfd.FileName);
MessageBox.Show("表格下载成功！");
}
}
catch (Exception ex) { string aa = ex.Message; }
}
/// <summary>
/// 判断是否有新任务，如果新未读的消息数量大于newmsgnum则，有新任务
/// </summary>
/// <returns></returns>
public static int GetWeiduTaskNum()
{
string str_sql = $"select * from jjdbrenwutaizhang.任务信息表 where 状态='未读' and (参与人='{JJLoginInfo._shiming}' or 负责人='{JJLoginInfo._shiming}' or " +
$"反馈对象='{JJLoginInfo._shiming}' or 办理人员='{JJLoginInfo._shiming}' or 委托对象='{JJLoginInfo._shiming}' or " +
$"审核人员='{JJLoginInfo._shiming}' or 总体验收人='{JJLoginInfo._shiming}' )";
DataTable mydt = _mysqlhelper.ExecuteDataTable(str_sql);
if (mydt.Rows.Count > 0)
{
JJMethod.IconStartShanshuo();
}
else
{
JJMethod.IconStopShanshuo();
}
return(mydt.Rows.Count);
}
private void btn_baocun_Click(object sender, EventArgs e)
{
//判断信息是否为空
bool b1 = tb_renwumingcheng.Text.Trim().Equals(string.Empty);
bool b2 = tb_jutiyaoqiu.Text.Trim().Equals(string.Empty);
if (b1)
{
MessageBox.Show("任务名称未填写！");
return;
}
if (b2)
{
MessageBox.Show("详情未填写！");
return;
}
//构造一个jjtongzhiinfo
JJTaskInfo myinfo = new JJTaskInfo
{
_mingcheng = tb_renwumingcheng.Text,
_jinjichengdu = rb_jinji.Checked == true ? "紧急" : "普通",
_jutiyaoqiu = tb_jutiyaoqiu.Text,
_fujian = string.Join("|", uCfujian1.list_fujian),
_shixian = dtp_shixian.Value.ToString("yyyy-MM-dd hh:mm:ss"),
_banliyijian = tb_banliyijian.Text,
_banlirenyuan = tb_banlirenyuan.Text,
_jinzhanqingkuang = tb_jinzhanqingkuang.Text,
_chuangjianshijian = DateTime.Now.ToString(),
_chuangjianren = JJLoginInfo._shiming,
_leixing = "常规事项",
_zhuangtai = "保存"
};
//添加任务
bool b = mycontroller.AddTask(myinfo);
if (b)
{
JJMethod.a_checknewtask(null, null);
MessageBox.Show("保存成功！");
mytask = myinfo;
this.DialogResult = DialogResult.OK;
}
}
private async void lbl_xiazai_Click(object sender, EventArgs e)
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "Excel 97-2003工作簿|*.xls|Excel 工作簿|*.xlsx|压缩文件(ZIP)|*.zip";
sfd.FileName = Path.GetFileName(_myinfo._quanlujing);
if (Path.GetExtension(_myinfo._quanlujing).Equals(".xls"))
{
sfd.Filter = "Excel 97-2003工作簿|*.xls";
}
if (Path.GetExtension(_myinfo._quanlujing).Equals(".xlsx"))
{
sfd.Filter = "Excel 工作簿|*.xlsx";
}
if (Path.GetExtension(_myinfo._quanlujing).Equals(".zip"))
{
sfd.Filter = "压缩文件(ZIP)|*.zip";
}
if (Path.GetExtension(_myinfo._quanlujing).Equals(".doc"))
{
sfd.Filter = "Word 97-2003文档|*.doc";
}
if (Path.GetExtension(_myinfo._quanlujing).Equals(".docx"))
{
sfd.Filter = "Word 文档|*.docx";
}
if (Path.GetExtension(_myinfo._quanlujing).Equals(".txt"))
{
sfd.Filter = "文本文件TXT|*.txt";
}
if (sfd.ShowDialog() == DialogResult.OK)
{
lbl_info.Visible = true;
lbl_info.Text = "正在下载……";
await JJMethod.DownLoadFileAsync(_myinfo._quanlujing, sfd.FileName);
lbl_info.Visible = false;
MessageBox.Show("下载完成！");
}
}
/// <summary>
/// 点击保存按钮时触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lbl_baocun_Click(object sender, EventArgs e)
{
List <JJchengguoInfo> list = new List <JJchengguoInfo>();
foreach (UCchengguo item in panel_my.Controls)
{
item.myinfo._fujian = string.Join("|", item.uCfujian1.list_fujian);
list.Add(item.myinfo);
}
//序列化chengguoji
JJchengguoji chengguoji = new JJchengguoji()
{
_list_chengguo = list
};
//构造一个jjtongzhiinfo
JJTaskInfo myinfo = new JJTaskInfo
{
_mingcheng = tb_renwumingcheng.Text,
_mubiao = tb_mubiao.Text,
_zongtiyanshouren = tb_zongtiyanshouren.Text,
_chuangjianshijian = DateTime.Now.ToString(),
_jinjichengdu = rb_jinji.Checked == true ? "紧急" : "普通",
_chuangjianren = JJLoginInfo._shiming,
_leixing = "OKR事项",
_zhuangtai = "保存",
_chengguoji = JsonConvert.SerializeObject(chengguoji)
};
//保存信息
bool b = _mycontroller.SaveOkrshixiang(myinfo);
if (b)
{
JJMethod.a_checknewtask(null, null);
MessageBox.Show("保存okr事项成功！");
//this.DialogResult = DialogResult.OK;
}
}
/// <summary>
/// 点击发送办理按钮时触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lbl_fasongbanli_Click(object sender, EventArgs e)
{
//再发送之前，先保存本任务
//构造一个jjtongzhiinfo
JJTaskInfo myinfo = new JJTaskInfo
{
_biaoti = tb_biaoti.Text,
_chuangjianren = JJLoginInfo._shiming,
_fankuiduixiang = tb_fankuiduixiang.Text,
_neirong = tb_neirong.Text,
_chuangjianshijian = DateTime.Now.ToString(),
_jinjichengdu = rb_jinji.Checked == true ? "紧急" : "普通",
_chuliyijian = tb_chuliyijian.Text,
_leixing = "意见建议",
_zhuangtai = "保存"
};
//保存jjtonzhiinfo
bool b = _mycontroller.SaveYijian(myinfo);
//分解反馈对象
string[] arr = Regex.Split(tb_fankuiduixiang.Text, ",");
foreach (string s in arr)
{
//构造一个jjtongzhiinfo
myinfo = new JJTaskInfo
{
_biaoti = tb_biaoti.Text,
_fasongren = JJLoginInfo._shiming,
_fankuiduixiang = s,
_neirong = tb_neirong.Text,
_fasongshijian = DateTime.Now.ToString(),
_jinjichengdu = rb_jinji.Checked == true ? "紧急" : "普通",
_chuliyijian = tb_chuliyijian.Text,
_leixing = "意见建议",
_zhuangtai = "未读"
}; //拆解反馈对象，对每一个对象，向任务信息表中插入一条jjtaskinfo
b = _mycontroller.FasongBanli(myinfo);
}
JJMethod.a_checknewtask(null, null);
}
private void timer1_Tick(object sender, EventArgs e)
{
//获得新消息，如果数量大于一，在 我的任务右侧显示红点
int num = JJLoginInfo.GetWeiduTaskNum();
if (num > 0)
{
lbl_newtask.Visible = true;
lbl_newtask.Text = $"{num}";
//判断软件目前界面是否为我的主页，如果是的话需要刷新
if (lbl_wodezhuye.BackColor == Color.White)
{
if (num > JJLoginInfo.newmsgnum)
{
JJMethod.a_shuaxinzhuye(null, null);
JJLoginInfo.newmsgnum = num;
}
}
}
else
{
lbl_newtask.Visible = false;
}
}
private void lbl_fasongbanli_Click(object sender, EventArgs e)
{
//发送办理之前先保存任务信息
List <JJchengguoInfo> list = new List <JJchengguoInfo>();
foreach (UCchengguo item in panel_my.Controls)
{
item.myinfo._fujian = string.Join("|", item.uCfujian1.list_fujian);
list.Add(item.myinfo);
}
//序列化chengguoji
JJchengguoji chengguoji = new JJchengguoji()
{
_list_chengguo = list
};
//构造一个jjtongzhiinfo
JJTaskInfo myinfo = new JJTaskInfo
{
_mingcheng = tb_renwumingcheng.Text,
_mubiao = tb_mubiao.Text,
_zongtiyanshouren = tb_zongtiyanshouren.Text,
_chuangjianshijian = DateTime.Now.ToString(),
_jinjichengdu = rb_jinji.Checked == true ? "紧急" : "普通",
_chuangjianren = JJLoginInfo._shiming,
_leixing = "OKR事项",
_zhuangtai = "保存",
_chengguoji = JsonConvert.SerializeObject(chengguoji)
};
//保存信息
bool b = _mycontroller.SaveOkrshixiang(myinfo);
//开始发送办理，先形成成果集
list = new List <JJchengguoInfo>();
foreach (UCchengguo item in panel_my.Controls)
{
item.myinfo._fujian = string.Join("|", item.uCfujian1.list_fujian);
list.Add(item.myinfo);
}
//序列化chengguoji
chengguoji = new JJchengguoji()
{
_list_chengguo = list
};
//分解总体验收人，获得所有的办理人员
List <string> list_yanshouren = Regex.Split(tb_zongtiyanshouren.Text, ",").ToList();
List <string> list_banliren = new List <string>();
foreach (Control c in panel_my.Controls)
{
UCchengguo cc = c as UCchengguo;
List <string> list_temp = Regex.Split(cc.myinfo._banlirenyuan, ",").ToList();
foreach (string str in list_temp)
{
if (!list_banliren.Contains(str))
{
list_banliren.Add(str);
}
}
}
//循环添加记录
foreach (string yanshouren in list_yanshouren)
{
foreach (string banliren in list_banliren)
{
//构造一个jjtongzhiinfo
myinfo = new JJTaskInfo
{
_mingcheng = tb_renwumingcheng.Text,
_mubiao = tb_mubiao.Text,
_zongtiyanshouren = yanshouren,
_fasongshijian = DateTime.Now.ToString(),
_banlirenyuan = banliren,
_jinjichengdu = rb_jinji.Checked == true ? "紧急" : "普通",
_fasongren = JJLoginInfo._shiming,
_leixing = "OKR事项",
_zhuangtai = "未读",
_chengguoji = JsonConvert.SerializeObject(chengguoji),
};
b = _mycontroller.FasongBanli(myinfo);
}
}
JJMethod.a_checknewtask(null, null);
MessageBox.Show("发送办理成功！");
}
/// <summary>
/// 点击保存按钮时触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void label5_Click(object sender, EventArgs e)
{
//先判断数据库中是否有登陆人创建的同名工作清单
string str_sql = $"select count(*) from jjdbrenwutaizhang.通知公告表 " +
$"where 标题='{tb_biaoti.Text}'";
int num = Convert.ToInt32(_mysql.ExecuteScalar(str_sql));
//判断窗体的模式，如果是保存就提示名称已经存在并且return
//如果是编辑模式，那么提示是否保存编辑，选择是之后，就update
if (num > 0)
{
if (mode.Equals("创建"))
{
MessageBox.Show("标题名称重复！请重新输入！");
return;
}
else if (mode.Equals("编辑"))
{
//删除这条标题通知公告，为一会重新保存做准备
str_sql = $"delete from jjdbrenwutaizhang.通知公告表 " +
$"where 标题='{tb_biaoti.Text}'";
_mysql.ExecuteNonQuery(str_sql);
}
}
//将内容保存到本地
//这里为了防止通知过多，需要单独创建一个temp文件夹存放，通知的数量始终保持一个
string localdir = $"{Environment.CurrentDirectory}\\temp";
if (Directory.Exists(localdir))
{
//清空temp中的文件
string[] files = Directory.GetFiles(localdir);
File.Delete(files[0]);
}
else
{
Directory.CreateDirectory(localdir);
}
string filename = $"{localdir}\\{tb_biaoti.Text}.rtf";
devUCrichtextbox1.richEditControl1.Document.SaveDocument(filename, DevExpress.XtraRichEdit.DocumentFormat.Rtf);
//将本地文件上传到服务器,存放位置
string uristring = $"http://49.233.40.109/通知公告";
await JJMethod.UpLoadFile(filename, uristring, false);
//将服务器地址赋值给tongzhiinfo的内容
//分解阅读范围
string[] person = Regex.Split(tb_yuedufanwei.Text, ",");
foreach (string s in person)
{
//构造一个jjtongzhiinfo
JJTongzhiInfo myinfo = new JJTongzhiInfo()
{
_chuangjianren = JJLoginInfo._shiming,
_biaoti = tb_biaoti.Text,
_qianfaren = tb_wenhao.Text,
_neirongpath = $"{ uristring}/{tb_biaoti.Text}.rtf",
_qingzhonghuanji = rb_putong.Checked ? "普通" : "紧急",
_zhuangtai = "未读",
_fabushijian = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"),
_shixian = dtp_shixian.Value.ToString("yyyy-MM-dd hh:mm:ss"),
_yuedufanwei = s
};
//保存jjtonzhiinfo
_mycontroller.SaveTongzhi(myinfo);
}
MessageBox.Show("保存成功！");
this.DialogResult = DialogResult.OK;
}
/// <summary>
/// 点击名称时触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void label2_Click(object sender, EventArgs e)
{
//判断uc的类型，工作清单，通知公告，待办任务
if (task is JJTaskInfo)
{
var myti = task as JJTaskInfo;
//如果myti的状态是未读，就把状态变成未处理，然后让信封消失
if (myti._zhuangtai.Equals("未读"))
{
lbl_zhuangtai.Visible = false;
myti._zhuangtai = "办理中";
_myc.UpdateZhuangtai(myti);
}
//判断未读任务数量，如果是0，要取消主界面我的任务右侧的红点
int num = JJLoginInfo.GetWeiduTaskNum();
if (num > 0)
{
(this.ParentForm as Form1).lbl_newtask.Visible = true;
(this.ParentForm as Form1).lbl_newtask.Text = $"{num}";
}
else
{
(this.ParentForm as Form1).lbl_newtask.Visible = false;
}
//在这里，不能直接使用转换后的task，因为信息不完整，应当根据类型和名称获得状态为“保存的”taskinfo
JJTaskInfo info0 = task as JJTaskInfo;
JJTaskInfo info = GetBaocunTask(info0);
Form mywin = null;
if (info._leixing.Equals("OKR事项"))
{
mywin = new WFokrshixiang(info)
{
StartPosition = FormStartPosition.CenterParent
};
}
else if (info._leixing.Equals("常规事项"))
{
mywin = new WFchangguishixiang(info)
{
StartPosition = FormStartPosition.CenterParent
};
}
else if (info._leixing.Equals("请休假单"))
{
mywin = new WFqingxiujiadan(info)
{
StartPosition = FormStartPosition.CenterParent
};
}
else if (info._leixing.Equals("意见建议"))
{
mywin = new WFyijianjianyi(info)
{
StartPosition = FormStartPosition.CenterParent
};
}
if (mywin.ShowDialog() == DialogResult.OK)
{
//刷新数据
JJMethod.a_shuaxinzhuye(null, null);
}
}
//如果是通知公告类型
if (task is JJTongzhiInfo)
{
//将该任务的状态变为已读，，字体从粗体变为常规
this.lbl_mingcheng.Font = new System.Drawing.Font(this.Font.Name, 9, FontStyle.Regular);
JJTongzhiInfo info = task as JJTongzhiInfo;
_myc.Yidu(info);//将状态从未读变为已读
WinFormTongzhi mywin = new WinFormTongzhi(info)
{
StartPosition = FormStartPosition.CenterParent
};
if (mywin.ShowDialog() == DialogResult.OK)
{
JJMethod.a_shuaxinzhuye(null, null);
}
//WFtongzhigonggao mywin = new WFtongzhigonggao(info);
//if (mywin.ShowDialog() == DialogResult.OK)
//{
// //刷新数据
// _updatemaindata(null, null);
//}
}
//如果是工作清单类型
if (task is JJQingdanInfo)
{
JJQingdanInfo ci = task as JJQingdanInfo;
WFgongzuoqingdan mywin = new WFgongzuoqingdan(ci)
{
StartPosition = FormStartPosition.CenterParent
};
if (mywin.ShowDialog() == DialogResult.OK)
{
//刷新数据
JJMethod.a_shuaxinzhuye(null, null);
}
}
}
