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