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