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 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; } }
public UCTaskInfo(JJTaskInfo ti) { InitializeComponent(); this.Dock = DockStyle.Fill; myti = ti; tb_renwumingcheng.Text = ti._mingcheng; if (ti._jinjichengdu == "普通") { rb_putong.Checked = true; } else if (ti._jinjichengdu == "急件") { rb_jijian.Checked = true; } else if (ti._jinjichengdu == "特急") { rb_teji.Checked = true; } tb_xiangqing.Text = ti._xiangqing; tb_fuzeren.Text = ti._fuzeren; tb_canyuren.Text = ti._canyuren; try { dtp_shixian.Value = Convert.ToDateTime(ti._shixian); } catch { } }
/// <summary> /// 获得所有的任务信息 /// </summary> /// <param name="yongdao"></param> /// <returns></returns> public List <JJTaskInfo> GetAllTaskInfo() { List <JJTaskInfo> list_result = new List <JJTaskInfo>(); string str_sql = $"select * from 谦海数据库.任务信息表 " + $"where 删除=0"; string constr = ConfigurationManager.ConnectionStrings["constr"].ToString(); DataTable mydt = MySqlHelper.ExecuteDataset(constr, str_sql).Tables[0]; foreach (DataRow dataRow in mydt.Rows) { JJTaskInfo _ti = new JJTaskInfo() { _bianhao = dataRow["编号"].ToString(), _mingcheng = dataRow["名称"].ToString(), _miaoshu = dataRow["描述"].ToString(), _fuzeren = dataRow["负责人"].ToString(), _quanxian = dataRow["权限"].ToString(), _youxianji = dataRow["优先级"].ToString(), _chuangjianren = dataRow["创建人"].ToString(), _chuangjianshijian = dataRow["创建时间"].ToString(), _haoshi = dataRow["耗时"].ToString(), _yujikaishi = dataRow["预计开始"].ToString(), _yujijieshu = dataRow["预计结束"].ToString(), _yongdao = dataRow["泳道"].ToString() }; list_result.Add(_ti); } return(list_result); }
public WFokrshixiang(JJTaskInfo ji) { InitializeComponent(); _info = ji; //加载信息到窗体 tb_renwumingcheng.Text = _info._mingcheng; rb_putong.Checked = _info._jinjichengdu.Equals("普通") ? true : false; rb_jinji.Checked = _info._jinjichengdu.Equals("紧急") ? true : false; tb_mubiao.Text = _info._mubiao; tb_zongtiyanshouren.Text = _info._zongtiyanshouren; JJchengguoji jc = JsonConvert.DeserializeObject <JJchengguoji>(_info._chengguoji); for (int i = 0; i < jc._list_chengguo.Count; i++) { var item = jc._list_chengguo[i]; UCchengguo myuc = new UCchengguo(item) { Dock = DockStyle.Top }; panel_my.Controls.Add(myuc); } //判断登录信息,创建人是否等于登录人,如果不是,任务任务名称,紧急程度,任务具体要求,上传附件,时限不可用 if (!JJLoginInfo._huaming.Equals(_info._fasongren)) { tb_renwumingcheng.Enabled = false; flp_jinjichengdu.Enabled = false; tb_mubiao.Enabled = false; tb_zongtiyanshouren.Enabled = false; tlp_chengguoji.Enabled = false; panel_my.Enabled = false; } }
/// <summary> /// 修改任务状态 /// </summary> /// <param name="ti"></param> /// <returns></returns> public bool UpdateZhuangtai(JJTaskInfo ti) { //判断任务类型,构造不同的str_sql语句 string str_sql = string.Empty; if (ti._leixing.Equals("意见建议")) { str_sql = $"update jjdbrenwutaizhang.任务信息表 set 状态='{ti._zhuangtai}' where 标题='{ti._biaoti}' and 类型='{ti._leixing}' " + $"and 反馈对象='{ti._fankuiduixiang}' and 删除=0"; } if (ti._leixing.Equals("常规事项")) { str_sql = $"update jjdbrenwutaizhang.任务信息表 set 状态='{ti._zhuangtai}' where 名称='{ti._mingcheng}' and 类型='{ti._leixing}' " + $"and 办理人员='{ti._banlirenyuan}' and 删除=0"; } if (ti._leixing.Equals("OKR事项")) { str_sql = $"update jjdbrenwutaizhang.任务信息表 set 状态='{ti._zhuangtai}' where 名称='{ti._mingcheng}' and 类型='{ti._leixing}' " + $"and (总体验收人='{ti._zongtiyanshouren}' or 办理人员='{ti._banlirenyuan}') and 删除=0"; } if (ti._leixing.Equals("请休假单")) { str_sql = $"update jjdbrenwutaizhang.任务信息表 set 状态='{ti._zhuangtai}' where 事由='{ti._shiyou}' and 类型='{ti._leixing}' " + $"and 审核人员='{ti._shenherenyuan}' and 删除=0"; } int num = _mysql.ExecuteNonQuery(str_sql); return(num > 0 ? true : false); }
public bool FasongBanli(JJTaskInfo myinfo) { string str_sql = $"insert into jjdbrenwutaizhang.任务信息表 (事由,紧急程度,请假天数,起止时间," + $"审核人员,审核意见,销假情况,发送时间,发送人,类型,删除,状态) " + $"values('{myinfo._shiyou}','{myinfo._jinjichengdu}',{myinfo._qingjiatianshu},'{myinfo._qizhishijian}'," + $"'{myinfo._shenherenyuan}','{myinfo._shenheyijian}','{myinfo._xiaojiaqingkuang}','{myinfo._fasongshijian}','{myinfo._fasongren}','{myinfo._leixing}',0,'{myinfo._zhuangtai}')"; int num = _mysql.ExecuteNonQuery(str_sql); return(num > 0 ? true : false); }
public bool FasongBanli(JJTaskInfo myinfo) { string str_sql = $"insert into jjdbrenwutaizhang.任务信息表 (名称,紧急程度,总体目标,总体验收人,办理人员,成果集,发送人,发送时间,类型,删除,状态) " + $"values('{myinfo._mingcheng}','{myinfo._jinjichengdu}','{myinfo._mubiao}','{myinfo._zongtiyanshouren}'," + $"'{myinfo._banlirenyuan}','{myinfo._chengguoji}'," + $"'{myinfo._fasongren}','{myinfo._fasongshijian}','{myinfo._leixing}',0,'{myinfo._zhuangtai}')"; int num = _mysql.ExecuteNonQuery(str_sql); return(num > 0 ? true : false); }
public bool FasongBanli(JJTaskInfo myinfo) { string str_sql = $"insert into jjdbrenwutaizhang.任务信息表 (名称,紧急程度,具体要求,附件,时限," + $"办理意见,办理人员,进展情况,发送时间,发送人,类型,删除,状态) " + $"values('{myinfo._mingcheng}','{myinfo._jinjichengdu}','{myinfo._jutiyaoqiu}',@附件,'{myinfo._shixian}'," + $"'{myinfo._banliyijian}','{myinfo._banlirenyuan}','{myinfo._jinzhanqingkuang}','{myinfo._fasongshijian}','{myinfo._fasongren}','{myinfo._leixing}',0,'{myinfo._zhuangtai}')"; int num = _mysql.ExecuteNonQuery(str_sql, new MySqlParameter("@附件", myinfo._fujian)); return(num > 0 ? true : false); }
/// <summary> /// 根据待办任务名称获得信息 /// </summary> /// <param name="s"></param> /// <returns></returns> public JJTaskInfo GetChangguiInfo(string s) { string str_sql = $"select * from jjdbrenwutaizhang.常规事项表 where 名称='{s}' and 删除=0"; DataRow mydr = _sql.ExecuteDataRow(str_sql); JJTaskInfo myti = new JJTaskInfo() { }; return(myti); }
/// <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("发送办理成功!"); }
public WFyijianjianyi(JJTaskInfo ji) { InitializeComponent(); _info = ji; if (!JJLoginInfo._huaming.Equals(_info._fasongren)) { tb_biaoti.Enabled = false; p_jinjichengdu.Enabled = false; tb_neirong.Enabled = false; } }
public WFqingxiujiadan(JJTaskInfo ji) { InitializeComponent(); _info = ji; if (!JJLoginInfo._huaming.Equals(_info._chuangjianren)) { tb_shiyou.Enabled = false; panel1.Enabled = false; tlp_shijian.Enabled = false; tb_qingjaitianshu.Enabled = false; tb_weituoren.Enabled = false; tb_xiaojiaqingkuang.Enabled = false; } }
/// <summary> /// 在我的主页中显示任务待办 /// </summary> /// <param name="o"></param> public void UpdatePdaiban(object o) { panel_daibanrenwu.Controls.Clear(); List <JJTaskInfo> list_daiban = o as List <JJTaskInfo>; for (int i = list_daiban.Count - 1; i >= 0; i--) { JJTaskInfo info = list_daiban[i]; UCMessage myuc = new UCMessage(info); panel_daibanrenwu.Controls.Add(myuc); } //显示待办任务数量 gb_daibairenwu.Text = $"待办任务 共{panel_daibanrenwu.Controls.Count}项"; }
/// <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("发送办理成功!"); }
/// <summary> /// 获得需要的任务信息 /// </summary> /// <param name="s">sql语句</param> /// <returns></returns> public List <JJTaskInfo> GetTaskinfo(string s) { List <JJTaskInfo> list = new List <JJTaskInfo>(); JJTaskInfo myti = new JJTaskInfo(); DataTable mydt = mysql.ExecuteDataTable(s); foreach (DataRow mydr in mydt.Rows) { myti = new JJTaskInfo() { _mingcheng = mydr["名称"].ToString(), _leixing = mydr["类型"].ToString(), _canyuren = mydr["参与人"].ToString(), _fuzeren = mydr["负责人"].ToString(), _zhuangtai = mydr["状态"].ToString(), _xiangqing = mydr["详情"].ToString(), _chuangjianren = mydr["创建人"].ToString(), _chuangjianshijian = mydr["创建时间"].ToString(), _duqushijian = mydr["读取时间"].ToString(), _shixian = mydr["时限"].ToString(), _jinjichengdu = mydr["紧急程度"].ToString(), _shanchu = Convert.ToInt32(mydr["删除"].ToString()), _mubiao = mydr["总体目标"].ToString(), _chengguoji = mydr["成果集"].ToString(), _shenqingren = mydr["申请人"].ToString(), _shiyou = mydr["事由"].ToString(), _kaishishijian = mydr["开始时间"].ToString(), _jieshushijian = mydr["结束时间"].ToString(), _weituoduixiang = mydr["委托对象"].ToString(), _shenheyijian = mydr["审核意见"].ToString(), _biaoti = mydr["标题"].ToString(), _fankuiren = mydr["反馈人"].ToString(), _fankuiduixiang = mydr["反馈对象"].ToString(), _neirong = mydr["内容"].ToString(), _banliyijian = mydr["办理意见"].ToString(), _banlirenyuan = mydr["办理人员"].ToString(), _jinzhanqingkuang = mydr["进展情况"].ToString(), _zongtiyanshouren = mydr["总体验收人"].ToString(), _chuliyijian = mydr["处理意见"].ToString(), _shenherenyuan = mydr["审核人员"].ToString(), _fasongren = mydr["发送人"].ToString() }; list.Add(myti); } return(list); }
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; } }
public UCTaskmsg(JJTaskInfo ti) { InitializeComponent(); this.Dock = DockStyle.Top; myti = ti; string leixing = string.Empty; if (ti._leixing.Equals("OKR事项")) { leixing = "OKR"; lbl_renwuming.Text = ti._mingcheng; } else if (ti._leixing.Equals("常规事项")) { leixing = "事务"; lbl_renwuming.Text = ti._mingcheng; } else if (ti._leixing.Equals("请休假单")) { leixing = "假单"; lbl_renwuming.Text = ti._shiyou; } else if (ti._leixing.Equals("意见建议")) { leixing = "建言"; lbl_renwuming.Text = ti._mubiao; } lbl_renwuleixing.Text = leixing; try { lbl_shixian.Text = Convert.ToDateTime(ti._shixian).ToString("yyyy-MM-dd"); } catch { } if (myti._zhuangtai.Equals("未读")) { pb_weidu.Visible = true; } else { pb_weidu.Visible = false; } }
public bool SaveOkrshixiang(JJTaskInfo myinfo) { //判断该任务是否存在,如果存在,使用update,如果不存在使用insert into string str_sql = $"select count(*) from jjdbrenwutaizhang.任务信息表 where 删除=0 and 名称='{myinfo._mingcheng}' and 类型='{myinfo._leixing}'"; int num = Convert.ToInt32(_mysql.ExecuteScalar(str_sql)); if (num > 0) { str_sql = $"update jjdbrenwutaizhang.任务信息表 set 名称='{myinfo._mingcheng}',紧急程度='{myinfo._jinjichengdu}',总体目标='{myinfo._mubiao}'," + $"总体验收人='{myinfo._zongtiyanshouren}',成果集='{myinfo._chengguoji}' where 名称='{myinfo._mingcheng}' and 删除=0 and 类型='{myinfo._leixing}'"; } else { str_sql = $"insert into jjdbrenwutaizhang.任务信息表 (名称,紧急程度,总体目标,总体验收人,成果集,创建人,创建时间,类型,删除,状态) " + $"values('{myinfo._mingcheng}','{myinfo._jinjichengdu}','{myinfo._mubiao}','{myinfo._zongtiyanshouren}','{myinfo._chengguoji}'," + $"'{JJLoginInfo._huaming}','{myinfo._chuangjianshijian}','{myinfo._leixing}',0,'{myinfo._zhuangtai}')"; } num = _mysql.ExecuteNonQuery(str_sql); return(num > 0 ? true : false); }
/// <summary> /// 保存请假信息 /// </summary> /// <param name="myinfo"></param> /// <returns></returns> public bool SaveQingxiujia(JJTaskInfo myinfo) { string str_sql = $"select count(*) from jjdbrenwutaizhang.任务信息表 where 删除=0 and 事由='{myinfo._shiyou}' and 类型='{myinfo._leixing}'"; int num = Convert.ToInt32(_mysql.ExecuteScalar(str_sql)); if (num > 0) { str_sql = $"update jjdbrenwutaizhang.任务信息表 set 事由='{myinfo._shiyou}',紧急程度='{myinfo._jinjichengdu}',请假天数={myinfo._qingjiatianshu}," + $"起止时间='{myinfo._qizhishijian}',委托对象='{myinfo._weituoduixiang}',审核人员='{myinfo._shenherenyuan}'," + $"审核意见='{myinfo._shenheyijian}',销假情况='{myinfo._xiaojiaqingkuang}' where 事由='{myinfo._shiyou}' and 删除=0 and 类型='{myinfo._leixing}'"; } else { str_sql = $"insert into jjdbrenwutaizhang.任务信息表 (事由,紧急程度,请假天数,起止时间,委托对象," + $"审核人员,审核意见,销假情况,创建时间,创建人,类型,删除,状态) " + $"values('{myinfo._shiyou}','{myinfo._jinjichengdu}',{myinfo._qingjiatianshu},'{myinfo._qizhishijian}','{myinfo._weituoduixiang}'," + $"'{myinfo._shenherenyuan}','{myinfo._shenheyijian}','{myinfo._xiaojiaqingkuang}','{myinfo._chuangjianshijian}','{myinfo._chuangjianren}','{myinfo._leixing}',0,'{myinfo._zhuangtai}')"; } num = _mysql.ExecuteNonQuery(str_sql); return(num > 0 ? true : false); }
public bool AddTask(JJTaskInfo ci) { string str_sql = string.Empty; int num = 0; //拆分参与人,循环对参与人构造新的记录,并执行insertinto命令 string[] arr_canyuren = Regex.Split(ci._canyuren, "[,,|]"); foreach (string str in arr_canyuren) { //将常规事项的内容同时插入到常规事项表和 任务信息汇总表中 str_sql = $"insert into jjdbrenwutaizhang.任务信息表 values('{ci._mingcheng}'," + $"'{ci._leixing}','{ci._fuzeren}','{str}','{ci._zhuangtai}','{ci._xiangqing}','{ci._chuangjianren}','{ci._chuangjianshijian}'," + $"'{ci._duqushijian}','{ci._shixian}','{ci._jinjichengdu}',0)"; num = mysql.ExecuteNonQuery(str_sql); } //判断该任务名是否存在,如果存在,使用update语句,否则 //str_sql = $"insert into 常规事项表 values('{ci._renwumingcheng}','{ci._jinjichengdu}','{ci._jutiyaoqiu}'," + //$"'{ci._zerenren}','{ci._canjiarem}','{ci._shixian}','{ci._jinzhanqingkuang}','进行中','','',0,'{DateTime.Now.ToString()}',0)"; //int num = mysqlhelper.ExecuteNonQuery(str_sql, null); return(num > 0 ? true : false); }
/// <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); }
/// <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; } }
public bool AddTask(JJTaskInfo myinfo) { //判断该任务是否存在,如果存在,使用update,如果不存在使用insert into string str_sql = $"select count(*) from jjdbrenwutaizhang.任务信息表 where 删除=0 and 名称='{myinfo._mingcheng}' and 类型='{myinfo._leixing}'"; int num = Convert.ToInt32(_mysql.ExecuteScalar(str_sql)); if (num > 0) { str_sql = $"update jjdbrenwutaizhang.任务信息表 set 名称='{myinfo._mingcheng}',紧急程度='{myinfo._jinjichengdu}',具体要求='{myinfo._jutiyaoqiu}'," + $"附件=@附件,时限='{myinfo._shixian}',办理意见='{myinfo._banliyijian}'," + $"办理人员='{myinfo._banlirenyuan}',进展情况='{myinfo._jinzhanqingkuang}' where 名称='{myinfo._mingcheng}' and 删除=0 and 类型='{myinfo._leixing}'"; } else { str_sql = $"insert into jjdbrenwutaizhang.任务信息表 (名称,紧急程度,具体要求,附件,时限," + $"办理意见,办理人员,进展情况,创建时间,创建人,类型,删除,状态) " + $"values('{myinfo._mingcheng}','{myinfo._jinjichengdu}','{myinfo._jutiyaoqiu}',@附件,'{myinfo._shixian}'," + $"'{myinfo._banliyijian}','{myinfo._banlirenyuan}','{myinfo._jinzhanqingkuang}','{myinfo._chuangjianshijian}','{myinfo._chuangjianren}','{myinfo._leixing}',0,'{myinfo._zhuangtai}')"; } num = _mysql.ExecuteNonQuery(str_sql, new MySqlParameter("@附件", myinfo._fujian)); return(num > 0 ? true : false); }
public List <JJTaskInfo> GetTasks(JJTaskInfo ti) { List <JJTaskInfo> list = new List <JJTaskInfo>(); string str_sql = $"select * from jjdbrenwutaizhang.任务信息表 where 名称='{ti._mingcheng}' " + $"and 类型='{ti._leixing}'"; DataTable mydt = _mysql.ExecuteDataTable(str_sql); foreach (DataRow mydr in mydt.Rows) { JJTaskInfo myinfo = new JJTaskInfo() { _mingcheng = mydr["名称"].ToString(), //_leixing= mydr[""].ToString(), _canyuren = mydr["参与人"].ToString(), _zhuangtai = mydr["状态"].ToString(), }; list.Add(myinfo); } return(list); }
public WinFormYidu(JJTaskInfo myti) { InitializeComponent(); //根据myti的名称和类型获得所有的taskinfo var list = _myc.GetTasks(myti); //判断每个taskinfo的人员类别,添加label控件到负责人和参与人中,同时根据已读未读设置背景色 foreach (JJTaskInfo ti in list) { Label ml = new Label() { Text = ti._canyuren, BackColor = Color.LightGray }; if (ti._zhuangtai != "已读") { ml.BackColor = Color.SeaGreen; } flp_canyu.Controls.Add(ml); } }
public WFchangguishixiang(JJTaskInfo myinfo) { InitializeComponent(); this.StartPosition = FormStartPosition.CenterParent; tb_renwumingcheng.Text = myinfo._mingcheng; rb_putong.Checked = myinfo._jinjichengdu.Equals("普通") ? true : false; rb_jinji.Checked = myinfo._jinjichengdu.Equals("紧急") ? true : false; tb_jutiyaoqiu.Text = myinfo._jutiyaoqiu; tb_banlirenyuan.Text = myinfo._banlirenyuan; tb_banliyijian.Text = myinfo._banliyijian; tb_jinzhanqingkuang.Text = myinfo._jinzhanqingkuang; dtp_shixian.Value = Convert.ToDateTime(myinfo._shixian); //加载附件 foreach (string s in Regex.Split(myinfo._fujian, @"\|")) { if (s.Equals(string.Empty)) { continue; } UCfujianInfo myuc = new UCfujianInfo(s) { Dock = DockStyle.Top }; uCfujian1.panel_fujian.Controls.Add(myuc); } //判断登录信息,创建人是否等于登录人,如果不是,任务任务名称,紧急程度,任务具体要求,上传附件,时限不可用 if (!JJLoginInfo._huaming.Equals(myinfo._chuangjianren)) { tb_renwumingcheng.Enabled = false; panel1.Enabled = false; tlp_yaoqiu.Enabled = false; panel_fujian.Enabled = false; dtp_shixian.Enabled = false; } }
/// <summary> /// 获得待办任务 ,包括OKR,常规事项,请休假单,意见建议 /// </summary> /// <returns></returns> public List <JJTaskInfo> GetDaibanRenwu(int start, string s, int displaynum) { List <JJTaskInfo> list = new List <JJTaskInfo>(); string str_sql = string.Empty; DataTable data = null; //获得所有未读任务 str_sql = $"select * from jjdbrenwutaizhang.任务信息表 " + $"where 删除=0 and 状态='未读' and (审核人员='{JJLoginInfo._shiming}' or 委托对象='{JJLoginInfo._shiming}'" + $" or 总体验收人='{JJLoginInfo._shiming}' or 办理人员='{JJLoginInfo._shiming}' " + $"or 反馈对象='{JJLoginInfo._shiming}')"; data = _mysqlhelper.ExecuteDataTable(str_sql); foreach (DataRow dr in data.Rows) { JJTaskInfo info = new JJTaskInfo() { _mingcheng = dr["名称"].ToString(), _leixing = dr["类型"].ToString(), _fuzeren = dr["负责人"].ToString(), _canyuren = dr["参与人"].ToString(), _zhuangtai = dr["状态"].ToString(), _xiangqing = dr["详情"].ToString(), _chuangjianren = dr["创建人"].ToString(), _chuangjianshijian = dr["创建时间"].ToString(), _shixian = dr["时限"].ToString(), _jinjichengdu = dr["紧急程度"].ToString(), _mubiao = dr["总体目标"].ToString(), _chengguoji = dr["成果集"].ToString(), _shenqingren = dr["申请人"].ToString(), _shiyou = dr["事由"].ToString(), _kaishishijian = dr["开始时间"].ToString(), _jieshushijian = dr["结束时间"].ToString(), _weituoduixiang = dr["委托对象"].ToString(), _shenheyijian = dr["审核意见"].ToString(), _biaoti = dr["标题"].ToString(), _fankuiren = dr["反馈人"].ToString(), _fankuiduixiang = dr["反馈对象"].ToString(), _neirong = dr["内容"].ToString(), _banliyijian = dr["办理意见"].ToString(), _banlirenyuan = dr["办理人员"].ToString(), _jinzhanqingkuang = dr["进展情况"].ToString(), _zongtiyanshouren = dr["总体验收人"].ToString(), _chuliyijian = dr["处理意见"].ToString(), _shenherenyuan = dr["审核人员"].ToString(), _fasongren = dr["发送人"].ToString(), _fasongshijian = dr["发送时间"].ToString(), _jutiyaoqiu = dr["具体要求"].ToString(), _fujian = dr["附件"].ToString(), _qizhishijian = dr["起止时间"].ToString(), _xiaojiaqingkuang = dr["销假情况"].ToString(), _qingjiatianshu = Convert.ToInt32(dr["请假天数"].ToString()) }; list.Add(info); } //获得紧急程度是紧急的四种任务,按照请休假,okr,常规事项,意见建议排序,其中又按照完成时间排序,状态等于办理中 //获得请休假单 str_sql = $"select * from jjdbrenwutaizhang.任务信息表 " + $"where 事由 like '%{s}%' and 删除=0 and 类型='请休假单' and 紧急程度='紧急' and 状态='办理中' " + $"and (审核人员='{JJLoginInfo._shiming}' or 委托对象='{JJLoginInfo._shiming}') " + $"order by 起止时间 desc"; data = _mysqlhelper.ExecuteDataTable(str_sql); foreach (DataRow dr in data.Rows) { JJTaskInfo info = new JJTaskInfo() { _mingcheng = dr["名称"].ToString(), _jinjichengdu = dr["紧急程度"].ToString(), _fuzeren = dr["负责人"].ToString(), _shixian = dr["时限"].ToString(), _leixing = dr["类型"].ToString(), _canyuren = dr["参与人"].ToString(), _zhuangtai = dr["状态"].ToString(), _xiangqing = dr["详情"].ToString(), _chuangjianren = dr["创建人"].ToString(), _chuangjianshijian = dr["创建时间"].ToString(), _mubiao = dr["总体目标"].ToString(), _chengguoji = dr["成果集"].ToString(), _shenqingren = dr["申请人"].ToString(), _shiyou = dr["事由"].ToString(), _kaishishijian = dr["开始时间"].ToString(), _jieshushijian = dr["结束时间"].ToString(), _weituoduixiang = dr["委托对象"].ToString(), _shenherenyuan = dr["审核人员"].ToString(), _shenheyijian = dr["审核意见"].ToString(), _qizhishijian = dr["起止时间"].ToString(), _fasongren = dr["发送人"].ToString() }; list.Add(info); } //获得okr str_sql = $"select * from jjdbrenwutaizhang.任务信息表 where 名称 like '%{s}%' and 删除=0 and 类型='okr事项' " + $"and 紧急程度='紧急' and 状态='办理中' " + $"and (总体验收人='{JJLoginInfo._shiming}' or 办理人员='{JJLoginInfo._shiming}') " + $"order by 时限 desc"; data = _mysqlhelper.ExecuteDataTable(str_sql); foreach (DataRow dr in data.Rows) { JJTaskInfo info = new JJTaskInfo() { _mingcheng = dr["名称"].ToString(), _jinjichengdu = dr["紧急程度"].ToString(), _zongtiyanshouren = dr["总体验收人"].ToString(), _mubiao = dr["总体目标"].ToString(), _chengguoji = dr["成果集"].ToString(), _leixing = dr["类型"].ToString(), _zhuangtai = dr["状态"].ToString(), _fasongren = dr["发送人"].ToString() }; list.Add(info); } //获得常规事项 str_sql = $"select * from jjdbrenwutaizhang.任务信息表 where 名称 like '%{s}%' and 删除=0 and " + $"类型='常规事项' and 紧急程度='紧急' and 状态='办理中' and 办理人员='{JJLoginInfo._shiming}' " + $"order by 时限 desc"; data = _mysqlhelper.ExecuteDataTable(str_sql); foreach (DataRow dr in data.Rows) { JJTaskInfo info = new JJTaskInfo() { _mingcheng = dr["名称"].ToString(), _jinjichengdu = dr["紧急程度"].ToString(), _jutiyaoqiu = dr["具体要求"].ToString(), _fujian = dr["附件"].ToString(), _shixian = dr["时限"].ToString(), _banliyijian = dr["办理意见"].ToString(), _banlirenyuan = dr["办理人员"].ToString(), _jinzhanqingkuang = dr["进展情况"].ToString(), _leixing = dr["类型"].ToString(), _zhuangtai = dr["状态"].ToString(), _fasongren = dr["发送人"].ToString() }; list.Add(info); } //获得意见建议 str_sql = $"select * from jjdbrenwutaizhang.任务信息表 where 标题 like '%{s}%' and 删除=0 and " + $"类型='意见建议' and 紧急程度='紧急' and 状态='办理中' and 反馈对象='{JJLoginInfo._shiming}'" + $"order by 时限 desc"; data = _mysqlhelper.ExecuteDataTable(str_sql); foreach (DataRow dr in data.Rows) { JJTaskInfo info = new JJTaskInfo() { _mingcheng = dr["名称"].ToString(), _jinjichengdu = dr["紧急程度"].ToString(), _fuzeren = dr["负责人"].ToString(), _shixian = dr["时限"].ToString(), _leixing = dr["类型"].ToString(), _canyuren = dr["参与人"].ToString(), _zhuangtai = dr["状态"].ToString(), _xiangqing = dr["详情"].ToString(), _chuangjianren = dr["创建人"].ToString(), _chuangjianshijian = dr["创建时间"].ToString(), //_mubiao = dr["objectives目标"].ToString(), _chengguoji = dr["成果集"].ToString(), _biaoti = dr["标题"].ToString(), _fankuiren = dr["反馈人"].ToString(), _fankuiduixiang = dr["反馈对象"].ToString(), _neirong = dr["内容"].ToString(), _fasongren = dr["发送人"].ToString(), _chuliyijian = dr["处理意见"].ToString() }; list.Add(info); } //获得紧急程度是普通的四种任务 //获得请休假单 str_sql = $"select * from jjdbrenwutaizhang.任务信息表 " + $"where 事由 like '%{s}%' and 删除=0 and 类型='请休假单' and 紧急程度='普通' and 状态='办理中' " + $"and (审核人员='{JJLoginInfo._shiming}' or 委托对象='{JJLoginInfo._shiming}')" + $"order by 起止时间 desc"; data = _mysqlhelper.ExecuteDataTable(str_sql); foreach (DataRow dr in data.Rows) { JJTaskInfo info = new JJTaskInfo() { _mingcheng = dr["名称"].ToString(), _jinjichengdu = dr["紧急程度"].ToString(), _fuzeren = dr["负责人"].ToString(), _shixian = dr["时限"].ToString(), _leixing = dr["类型"].ToString(), _canyuren = dr["参与人"].ToString(), _zhuangtai = dr["状态"].ToString(), _xiangqing = dr["详情"].ToString(), _chuangjianren = dr["创建人"].ToString(), _chuangjianshijian = dr["创建时间"].ToString(), _mubiao = dr["总体目标"].ToString(), _chengguoji = dr["成果集"].ToString(), _shenqingren = dr["申请人"].ToString(), _shiyou = dr["事由"].ToString(), _kaishishijian = dr["开始时间"].ToString(), _jieshushijian = dr["结束时间"].ToString(), _weituoduixiang = dr["委托对象"].ToString(), _shenheyijian = dr["审核意见"].ToString(), _qizhishijian = dr["起止时间"].ToString(), _shenherenyuan = dr["审核人员"].ToString(), _fasongren = dr["发送人"].ToString() }; list.Add(info); } //获得okr str_sql = $"select * from jjdbrenwutaizhang.任务信息表 where 名称 like '%{s}%' and 删除=0 and 类型='okr事项' " + $"and 紧急程度='普通' and 状态='办理中' " + $"and (总体验收人='{JJLoginInfo._shiming}' or 办理人员='{JJLoginInfo._shiming}') " + $"order by 时限 desc"; data = _mysqlhelper.ExecuteDataTable(str_sql); foreach (DataRow dr in data.Rows) { JJTaskInfo info = new JJTaskInfo() { _mingcheng = dr["名称"].ToString(), _jinjichengdu = dr["紧急程度"].ToString(), _zongtiyanshouren = dr["总体验收人"].ToString(), _mubiao = dr["总体目标"].ToString(), _chengguoji = dr["成果集"].ToString(), _leixing = dr["类型"].ToString(), _zhuangtai = dr["状态"].ToString(), _fasongren = dr["发送人"].ToString() }; list.Add(info); } //获得常规事项 str_sql = $"select * from jjdbrenwutaizhang.任务信息表 where 名称 like '%{s}%' and 删除=0 and " + $"类型='常规事项' and 紧急程度='普通' and 状态='办理中' " + $"and 办理人员='{JJLoginInfo._shiming}' " + $"order by 时限 desc"; data = _mysqlhelper.ExecuteDataTable(str_sql); foreach (DataRow dr in data.Rows) { JJTaskInfo info = new JJTaskInfo() { _mingcheng = dr["名称"].ToString(), _jinjichengdu = dr["紧急程度"].ToString(), _jutiyaoqiu = dr["具体要求"].ToString(), _fujian = dr["附件"].ToString(), _shixian = dr["时限"].ToString(), _banliyijian = dr["办理意见"].ToString(), _banlirenyuan = dr["办理人员"].ToString(), _jinzhanqingkuang = dr["进展情况"].ToString(), _leixing = dr["类型"].ToString(), _zhuangtai = dr["状态"].ToString(), _fasongren = dr["发送人"].ToString() }; list.Add(info); } //获得意见建议 str_sql = $"select * from jjdbrenwutaizhang.任务信息表 where 标题 like '%{s}%' and 删除=0 and " + $"类型='意见建议' and 紧急程度='普通' and 状态='办理中' " + $"and 反馈对象='{JJLoginInfo._shiming}'" + $"order by 时限 desc"; data = _mysqlhelper.ExecuteDataTable(str_sql); foreach (DataRow dr in data.Rows) { JJTaskInfo info = new JJTaskInfo() { _mingcheng = dr["名称"].ToString(), _jinjichengdu = dr["紧急程度"].ToString(), _fuzeren = dr["负责人"].ToString(), _shixian = dr["时限"].ToString(), _leixing = dr["类型"].ToString(), _canyuren = dr["参与人"].ToString(), _zhuangtai = dr["状态"].ToString(), _xiangqing = dr["详情"].ToString(), _chuangjianren = dr["创建人"].ToString(), _chuangjianshijian = dr["创建时间"].ToString(), //_mubiao = dr["objectives目标"].ToString(), _chengguoji = dr["成果集"].ToString(), _biaoti = dr["标题"].ToString(), _fankuiren = dr["反馈人"].ToString(), _fankuiduixiang = dr["反馈对象"].ToString(), _neirong = dr["内容"].ToString(), _fasongren = dr["发送人"].ToString(), _chuliyijian = dr["处理意见"].ToString() }; list.Add(info); } //获得第i个开始的10个结果 List <JJTaskInfo> list_result = new List <JJTaskInfo>(); for (int i = (start - 1) * displaynum; i < start * displaynum; i++) { try { list_result.Add(list[i]); } catch { break; } } return(list_result); }
public UCMessage(object o) { InitializeComponent(); this.Dock = DockStyle.Top; task = o; if (o is JJQingdanInfo)//如果是工作清单 { JJQingdanInfo info = o as JJQingdanInfo; //在uc上显示 象限 名称 完成时间 this.lbl_leixing.Text = Regex.Match(info._xiangxian, @".类").Value; this.lbl_xiangxian.Text = info._xiangxian; this.lbl_mingcheng.Text = info._renwumingcheng; this.lbl_shijian.Text = Convert.ToDateTime(info._wanchengshijian).ToString("yyyy-MM-dd"); //获得当前时间 //计算完成时间和现在的差 DateTime dt0 = Convert.ToDateTime(info._wanchengshijian); DateTime dt = DateTime.Now; TimeSpan ts = dt0.Subtract(dt); //如果当前时间超过完成时间显示红点,如果完成时间比现在大不到三天显示黄点 if (dt > dt0) { pb_point.Image = Properties.Resources.redpoint; } if (dt < dt0 && dt.AddDays(3) > dt0) { pb_point.Image = Properties.Resources.yellowpoint; } } if (o is JJTongzhiInfo)//如果是通知公告 { JJTongzhiInfo info = o as JJTongzhiInfo; //不是清单关闭销项 lbl_leixing.Visible = false; pb_xiaoxiang.Visible = false; pb_shanchu.Visible = false; //如果创建人等于登陆人那么显示编辑和删除按钮 if (info._chuangjianren.Equals(JJLoginInfo._shiming)) { link_bianji.Visible = true; link_shanchu.Visible = true; } //在uc上显示 状态标题 发布时间 lbl_xiangxian.Text = string.Empty; this.lbl_shijian.Text = Convert.ToDateTime(info._shixian).ToString("yyyy-MM-dd"); if (info._zhuangtai.Equals("未读")) { this.lbl_mingcheng.Font = new System.Drawing.Font(this.Font.Name, 9, FontStyle.Bold); } this.lbl_mingcheng.Text = info._biaoti; this.lbl_shijian.Text = Convert.ToDateTime(info._fabushijian).ToString("yyyy-MM-dd"); //判断轻重缓急,如果是紧急,任务显示红色,如果是普通,正常显示为黑色 if (info._qingzhonghuanji.Equals("紧急")) { lbl_mingcheng.ForeColor = Color.Red; } } if (o is JJTaskInfo)//如果是四大任务直以 { //不是清单关闭销项 pb_xiaoxiang.Visible = false; pb_shanchu.Visible = false; JJTaskInfo info = o as JJTaskInfo; string leixing = string.Empty; if (info._leixing.Equals("请休假单")) { leixing = "假单"; //请假单时间赋值为终止时间 string end_time = Regex.Split(info._qizhishijian, @"\|")[1]; this.lbl_shijian.Text = Convert.ToDateTime(end_time).ToString("yyyy-MM-dd"); this.lbl_mingcheng.Text = info._shiyou; } else if (info._leixing.Equals("OKR事项")) { leixing = "OKR"; this.lbl_shijian.Visible = false; this.lbl_mingcheng.Text = info._mingcheng; } else if (info._leixing.Equals("常规事项")) { leixing = "事务"; this.lbl_shijian.Text = Convert.ToDateTime(info._shixian).ToString("yyyy-MM-dd"); this.lbl_mingcheng.Text = info._mingcheng; } else if (info._leixing.Equals("意见建议")) { leixing = "建言"; this.lbl_shijian.Visible = false; this.lbl_mingcheng.Text = info._biaoti; } if (info._zhuangtai.Equals("未读")) { lbl_zhuangtai.Text = info._zhuangtai; lbl_zhuangtai.Visible = true; } lbl_leixing.Text = leixing; lbl_leixing.Visible = true; this.lbl_xiangxian.Text = info._jinjichengdu; this.lbl_mingcheng.TextAlign = ContentAlignment.MiddleLeft; //判断紧急程度,如果是紧急,任务显示红色,如果是普通,正常显示为黑色 if (info._jinjichengdu.Equals("紧急")) { lbl_mingcheng.ForeColor = Color.Red; } try { this.lbl_shijian.Text = Convert.ToDateTime(info._shixian).ToString("yyyy-MM-dd"); } catch { } } }
/// <summary> /// 获得状态为保存的任务信息 /// </summary> /// <returns></returns> public JJTaskInfo GetBaocunTask(JJTaskInfo info) { string str_sql = string.Empty; //判断类型,请休假单事由,事项名称,意见建议标题 if (info._leixing.Equals("常规事项") || info._leixing.Equals("OKR事项")) { str_sql = $"select * from jjdbrenwutaizhang.任务信息表 " + $"where 名称='{info._mingcheng}' and 类型='{info._leixing}' and 状态='保存' and 删除=0"; } else if (info._leixing.Equals("请休假单")) { str_sql = $"select * from jjdbrenwutaizhang.任务信息表 " + $"where 事由='{info._shiyou}' and 类型='{info._leixing}' and 状态='保存' and 删除=0"; } else if (info._leixing.Equals("意见建议")) { str_sql = $"select * from jjdbrenwutaizhang.任务信息表 " + $"where 标题='{info._biaoti}' and 类型='{info._leixing}' and 状态='保存' and 删除=0"; } DataRow mydr = _mysql.ExecuteDataRow(str_sql); JJTaskInfo result = new JJTaskInfo(); try { result._mingcheng = mydr["名称"].ToString(); } catch (Exception) { result._mingcheng = string.Empty; } try { result._leixing = mydr["类型"].ToString(); } catch { result._leixing = string.Empty; } result._zhuangtai = mydr["状态"].ToString(); result._xiangqing = mydr["详情"].ToString(); result._chuangjianren = mydr["创建人"].ToString(); result._chuangjianshijian = mydr["创建时间"].ToString(); result._duqushijian = mydr["读取时间"].ToString(); result._shixian = mydr["时限"].ToString(); result._jinjichengdu = mydr["紧急程度"].ToString(); result._mubiao = mydr["总体目标"].ToString(); result._chengguoji = mydr["成果集"].ToString(); result._shenqingren = mydr["申请人"].ToString(); result._shiyou = mydr["事由"].ToString(); result._kaishishijian = mydr["开始时间"].ToString(); result._jieshushijian = mydr["结束时间"].ToString(); result._weituoduixiang = mydr["委托对象"].ToString(); result._shenheyijian = mydr["审核意见"].ToString(); result._biaoti = mydr["标题"].ToString(); result._fankuiren = mydr["反馈人"].ToString(); result._fankuiduixiang = mydr["反馈对象"].ToString(); result._neirong = mydr["内容"].ToString(); result._banliyijian = mydr["办理意见"].ToString(); result._banlirenyuan = mydr["办理人员"].ToString(); result._jinzhanqingkuang = mydr["进展情况"].ToString(); result._zongtiyanshouren = mydr["总体验收人"].ToString(); result._chuliyijian = mydr["处理意见"].ToString(); result._shenherenyuan = mydr["审核人员"].ToString(); result._fasongren = mydr["发送人"].ToString(); result._fasongshijian = mydr["发送时间"].ToString(); result._jutiyaoqiu = mydr["具体要求"].ToString(); result._fujian = mydr["附件"].ToString(); result._qizhishijian = mydr["起止时间"].ToString(); result._xiaojiaqingkuang = mydr["销假情况"].ToString(); result._qingjiatianshu = mydr["请假天数"].ToString().Equals(string.Empty) ? 0 : Convert.ToInt32(mydr["请假天数"].ToString()); return(result); }