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