/// <summary>
/// 整改后 整改负责人的回复信息
/// </summary>
/// <param name="data"></param>
/// <param name="y_id"></param>
/// <returns></returns>
public int ZhengGai(dynamic data, int y_id)
{
if (ReStatus(y_id) == 2)
{//表单已闭环 不能修改
return(100);
}
Entity.yhtable y = yh.Value.SetData(data);
string sql = "update yhtable set y_zgdesc='" + y.y_zgdesc + "',y_zgtime=" + y.y_zgtime + ",y_zgimg='" + y.y_zgimg + "', " +
"y_status=3 where y_id=" + y_id + " ";
int i = help.Count(sql);
///////发送信息
string sql2 = "select b.mobile from yhtable a " +
"left join user_detail b " +
"on a.y_usid = b.us_id where y_id = " + y_id;
object objs = help.FirstRow(sql2);
if (objs != null)
{
if (objs.ToString() != "")
{
sendXinXi(objs.ToString(), "您收到了来自整改负责人的整改回复信息，请前往系统查看并确认！");
}
}
return(i);
}
/// <summary>
/// 整改确认
/// </summary>
/// <param name="data">确认说明，整改后图片，检查表单状态，确认人ID，确认时间</param>
/// <param name="y_id"></param>
/// <returns></returns>
public int QueRen(dynamic data, int y_id)
{
if (ReStatus(y_id) == 2)
{//表单已闭环 不能修改
return(100);
}
Entity.yhtable y = yh.Value.SetData(data);
string sql = "update yhtable set y_qrdesc='" + y.y_qrdesc + "',y_qrimg='" + y.y_qrimg + "',y_status=" + y.y_status + "," +
"y_qruser="******",y_qrtime=" + y.y_qrtime + " " +
"where y_id=" + y_id;
return(help.Count(sql));
}
/// <summary>
/// 修改检查单 只限检查人修改
/// </summary>
/// <param name="data"></param>
/// <param name="y_id"></param>
/// <returns></returns>
public int JianChaUpdate(dynamic data, int y_id)
{
if (ReSign(y_id) == 2)
{//领导已确认 不能修改
return(100);
}
Entity.yhtable y = yh.Value.SetData(data);
string sql = "update yhtable set y_name='" + y.y_name + "',y_body='" + y.y_body + "',y_area='" + y.y_area + "'," +
"y_type='" + y.y_type + "',y_dengji=" + y.y_dengji + ",y_desc='" + y.y_desc + "',y_endtime=" + y.y_endtime + "," +
"y_zguser="******",y_yaoqiu='" + y.y_yaoqiu + "',y_img1='" + y.y_img1 + "' " +
"where y_id=" + y_id;
return(help.Count(sql));
}
/// <summary>
/// 创建检查表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public int CreateYh(dynamic data)
{
Entity.yhtable y = yh.Value.SetData(data);
////获取编号
string no = SetNo(y.y_headid);
string sql = "insert into yhtable values('" + y.y_name + "'," + y.y_createtime + ",'" + y.y_body + "','" + y.y_area + "'," +
"'" + y.y_type + "'," + y.y_dengji + ",'" + y.y_desc + "','" + y.y_img1 + "'," + y.y_endtime + "," + y.y_usid + "," + y.y_zguser + ",'" + y.y_yaoqiu + "', " +
"" + y.y_headuser + "," + y.y_headtype + ",'" + y.y_zgdesc + "',0,'" + y.y_qrdesc + "'," +
"'" + y.y_qrimg + "'," + y.y_status + "," + y.y_qruser + ",0," + y.y_headid + ",'" + no + "','')";
string sql2 = "";
if (y.y_headuser > 0)
{//如果需要上级审批发信息给上级领导进行通知
sql2 = "select mobile from user_detail where us_id=" + y.y_headuser;
object objs = help.FirstRow(sql2);
if (objs != null)
{
if (objs.ToString() != "")
{
sendXinXi(objs.ToString(), "一个安全检查单需要您的审批，检查类型：" + y.y_type + "。详情请登录系统查看！");
}
}
}
else //需要上级审批 直接发信息给整改人
{
sql2 = "select mobile from user_detail where us_id=" + y.y_zguser;
object objs = help.FirstRow(sql2);
if (objs != null)
{
if (objs.ToString() != "")
{
sendXinXi(objs.ToString(), "您收到一个检查整改通知单，检查类型：" + y.y_type + "。详情请登录系统查看并及时整改！");
}
}
}
return(help.Count(sql));
}