private void btn_gengxin_Click(object sender, EventArgs e)
{
//构造一个待办任务实例
JJchangguiInfo ci = new JJchangguiInfo()
{
_renwumingcheng = tb_renwumingcheng.Text,
//_jutiyaoqiu = tb_jutiyaoqiu.Text,
//_jinzhanqingkuang = tb_jinzhan.Text,
//_zerenren = tb_zerenren.Text,
//_yanshouren = tb_yanshouren.Text
};
bool b = _mycontroller.UpdateTask(ci);
if (b)
{
MessageBox.Show("更新数据成功！");
this.DialogResult = DialogResult.OK;
}
////刷新数据
//int selectindex = dgv_data.SelectedRows[0].Index;
//UCdaiban_Load(null, null);
//dgv_data.Rows[0].Selected = false;
//dgv_data.Rows[selectindex].Selected = true;
//if (b) MessageBox.Show("更新数据成功！");
}
/// <summary>
/// 更新常规事项的信息
/// </summary>
/// <param name="ci"></param>
/// <returns></returns>
public bool UpdateTask(JJchangguiInfo ci)
{
string str_sql = $"update 常规事项表 set 具体要求='{ci._xiangqing}',进展情况='{ci._jinzhanqingkuang}',责任人='{ci._fuzeren}',验收人='{ci._canjiaren}' where 任务名称='{ci._renwumingcheng}'";
int num = mysqlhelper.ExecuteNonQuery(str_sql, null);
return(num > 0 ? true : false);
}
/// <summary>
/// 构造函数2
/// </summary>
/// <param name="renwuming">任务名称</param>
public WFdaiban(JJchangguiInfo ci)
{
InitializeComponent();
//获得任务详细信息,赋值到界面中
tb_renwumingcheng.Text = ci._renwumingcheng;
//tb_jutiyaoqiu.Text = ci._jutiyaoqiu;
//tb_jinzhan.Text = ci._jinzhanqingkuang;
//tb_zerenren.Text = ci._zerenren;
//tb_yanshouren.Text = ci._yanshouren;
}
/// <summary>
/// 验收已提交的任务
/// </summary>
/// <param name="renwumingcheng">任务名称</param>
/// <param name="yanshouren">验收人</param>
/// <returns></returns>
public bool YanshouRenwu(JJchangguiInfo ci)
{
// string str_date = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string str_sql = string.Empty;
// for (int i = 0; i < person.Count; i++)
//{
//str_sql = $"insert into jjtasksend values('{renwumingcheng}','{banliren}','{str_date}','已发送','{yanshouren}')";
str_sql = $"update 常规事项表 set 状态='通过验收' where 任务名称='{ci._renwumingcheng}'";
int num = mysqlhelper.ExecuteNonQuery(str_sql, null);
return(num > 0 ? true : false);
}
private void btn_yanshou_Click(object sender, EventArgs e)
{
//将选中的任务构造jjchangguinifo实例
JJchangguiInfo info = new JJchangguiInfo()
{
_renwumingcheng = tb_renwumingcheng.Text
};
//将任务名称和发送时间，办理人员存入数据库中jjtasksend
bool b = _mycontroller.TijiaoYanshou(info);
if (b)
{
MessageBox.Show("任务已提交验收！");
this.DialogResult = DialogResult.OK;
}
}
/// <summary>
/// 点击通过验收按钮时触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_tongguoyanshou_Click(object sender, EventArgs e)
{
//将选中的任务构造jjchangguinifo实例
JJchangguiInfo info = new JJchangguiInfo()
{
_renwumingcheng = tb_renwumingcheng.Text
};
//将任务名称和发送时间，办理人员存入数据库中jjtasksend
bool b = mycontroller.YanshouRenwu(info);
if (b)
{
//刷新数据
//刷新数据
int selectindex = dgv_data.SelectedRows[0].Index;
UCdaiban_Load(null, null);
dgv_data.Rows[0].Selected = false;
dgv_data.Rows[selectindex].Selected = true;
MessageBox.Show("任务已通过验收！");
}
}
/// <summary>
/// 点击提交验收按钮时触发的事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btn_yanshou_Click(object sender, EventArgs e)
{
//将选中的任务构造jjchangguinifo实例
DataGridViewRow mydr = dgv_data.CurrentRow;
JJchangguiInfo info = new JJchangguiInfo()
{
_renwumingcheng = mydr.Cells["任务名称"].Value.ToString()
};
//将任务名称和发送时间，办理人员存入数据库中jjtasksend
bool b = mycontroller.TijiaoYanshou(info);
if (b)
{
//刷新数据
int selectindex = dgv_data.SelectedRows[0].Index;
UCdaiban_Load(null, null);
dgv_data.Rows[0].Selected = false;
dgv_data.Rows[selectindex].Selected = true;
MessageBox.Show("任务已提交验收！");
}
}
