public DataResult EditProcessInfoStatus(ProcessInfoDel Model)
{
//BForm bWorkOrder = new BForm();
UserInfo mUser = BusinessConst.GetDefault();
Model.OperatorID = mUser.ID;
Model.OperatorName = mUser.Name;
Model.OperateTime = DateTime.Now;
int iBack = processService.DelProcessInfo(Model);
if (iBack == 1)
{
dataResult.Code = ResponseStatusCode.Success;
dataResult.Msg = "操作成功！";
}
else
{
dataResult.Code = ResponseStatusCode.Error;
dataResult.Msg = "操作失败！";
}
return dataResult;
}
/// <summary>
/// 关闭/开启自定义流程（不会增加删除自定义表单)
/// </summary>
/// <param name="Model"></param>
public int DelProcessInfo(ProcessInfoDel Model) {
MySqlConnection conn = DbMySqlConnectionWrite();
int iBack = 0;
try
{
//if (Model.Status == 1) {
////清理未使用的表单副本
//string pullOrgDeptSql = "select PK_FormBU from processinfobackups where PK_FormBU in( select PK_FormBU from processinfo where PK_Process = @ProcessID )";
//List<MySqlParameter> lstSqlParameters = new List<MySqlParameter>();
//lstSqlParameters.Add(new MySqlParameter("@ProcessID", Model.ID));
//var t3 = conn.ExecuteReader(pullOrgDeptSql, lstSqlParameters.ToArray());
//List<string> lstFormBUID = new List<string>();
//while(t3.Read())
//{
// lstFormBUID.Add(t3.TryGetValue<string>("PK_FormBU"));
//}
//iBack = conn.Delete("forminfobackups")
// .Where(WhereMySQL.In("PK_FormBU", DbType.AnsiString, lstFormBUID.ToArray()))
// .Execute();
//}
iBack = conn.Update("process")
.Set("T_Deleted", DbType.Int32, Model.Status)
.Set("T_Updater", DbType.AnsiString, Model.OperatorID)
.Set("T_UpdaterName", DbType.AnsiString, Model.OperatorName)
.Set("T_UpdateTime", DbType.AnsiString, Model.OperateTime)
.Where(WhereMySQL.Equal("PK_Process", DbType.AnsiString, Model.ID))
.Execute();
return iBack;
}
catch
{
return 0;
}
}
