/// <summary> /// 新增默认消息 /// </summary> /// <param name="entity"></param> public void AddDefaultMessage(T_WF_DEFAULTMESSAGE entity) { try { if (string.IsNullOrWhiteSpace(entity.MESSAGEID)) { entity.MESSAGEID = Guid.NewGuid().ToString(); } string insSql = @"INSERT INTO T_WF_DEFAULTMESSAGE (MESSAGEID,SYSTEMCODE,SYSTEMNAME,MODELCODE,MODELNAME,AUDITSTATE, MESSAGECONTENT,APPLICATIONURL,CREATEUSERID,CREATEUSERNAME) VALUES (:MESSAGEID,:SYSTEMCODE,:SYSTEMNAME,:MODELCODE, :MODELNAME,:AUDITSTATE,:MESSAGECONTENT,:APPLICATIONURL,:CREATEUSERID,:CREATEUSERNAME)"; Parameter[] pageparm = { new Parameter(":MESSAGEID",dal.GetValue(entity.MESSAGEID)), new Parameter(":SYSTEMCODE",dal.GetValue(entity.SYSTEMCODE)), new Parameter(":SYSTEMNAME",dal.GetValue(entity.SYSTEMNAME)), new Parameter(":MODELCODE",dal.GetValue(entity.MODELCODE)), new Parameter(":MODELNAME",dal.GetValue(entity.MODELNAME)), new Parameter(":AUDITSTATE",dal.GetValue(entity.AUDITSTATE)), new Parameter(":MESSAGECONTENT",dal.GetValue(entity.MESSAGECONTENT)), new Parameter(":APPLICATIONURL",dal.GetValue(entity.APPLICATIONURL)), new Parameter(":CREATEUSERID",dal.GetValue(entity.CREATEUSERID)), new Parameter(":CREATEUSERNAME",dal.GetValue(entity.CREATEUSERNAME)) }; dal.ExecuteSql(insSql, pageparm); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public void InitDefaultMessage() { //using (TransactionScope scope = new TransactionScope()) //{ try { List<AppSystem> ListSystemCode = ListSystem(); foreach (var item in ListSystemCode) { List<AppModel> ListModel = AppModel(item.ObjectFolder); foreach (var detail in ListModel) { for (int i = 1; i <= 3; i++) { T_WF_DEFAULTMESSAGE entity = new T_WF_DEFAULTMESSAGE(); entity.MODELCODE = detail.Name; entity.SYSTEMCODE = item.Name; entity.SYSTEMNAME = item.Description; entity.MODELNAME = detail.Description; entity.APPLICATIONURL = GetMessageUrl(item.ObjectFolder, detail.Name); entity.AUDITSTATE = i; entity.CREATEUSERID = "系统初始化"; entity.CREATEUSERNAME = "******"; switch (i) { case 1: entity.MESSAGECONTENT = "您有一条[" + detail.Description + "]的单据需要审核!"; break; case 2: entity.MESSAGECONTENT = "您的[" + detail.Description + "]已审核通过!"; break; case 3: entity.MESSAGECONTENT = "您的[" + detail.Description + "]审核不通过!"; break; } AddDefaultMessage(entity); } } } //scope.Complete(); } catch (Exception ex) { throw new Exception(ex.Message, ex); } finally { //释放资源 //scope.Dispose(); } //} }
public string EditMessage(T_WF_DEFAULTMESSAGE entity) { try { if (bll.GetBool(entity)) { bll.EditDefaultMessage(entity); } else { return "2"; } return "1"; } catch (Exception ex) { return ex.Message; } }
public void EditDefaultMessage(T_WF_DEFAULTMESSAGE entity) { try { string updSql = @"UPDATE T_WF_DEFAULTMESSAGE SET SYSTEMCODE=:SYSTEMCODE,SYSTEMNAME=:SYSTEMNAME,MODELCODE=: MODELCODE,MODELNAME=:MODELNAME,AUDITSTATE=:AUDITSTATE,MESSAGECONTENT=:MESSAGECONTENT,APPLICATIONURL=:APPLICATIONURL,UPDATEUSERID=:UPDATEUSERID, UPDATEUSERNAME=:UPDATEUSERNAME,UPDATEDATE=:UPDATEDATE WHERE MESSAGEID=:MESSAGEID"; OracleParameter[] pageparm = { new OracleParameter(":SYSTEMCODE",dal.GetValue(entity.SYSTEMCODE)), new OracleParameter(":SYSTEMNAME",dal.GetValue(entity.SYSTEMNAME)), new OracleParameter(":MODELCODE",dal.GetValue(entity.MODELCODE)), new OracleParameter(":SYSTEMCODE",dal.GetValue(entity.SYSTEMCODE)), new OracleParameter(":MODELNAME",dal.GetValue(entity.MODELNAME)), new OracleParameter(":AUDITSTATE",dal.GetValue(entity.AUDITSTATE)), new OracleParameter(":MESSAGECONTENT",dal.GetValue(entity.MESSAGECONTENT)), new OracleParameter(":APPLICATIONURL",dal.GetValue(entity.APPLICATIONURL)), new OracleParameter(":UPDATEUSERID",dal.GetValue(entity.CREATEUSERID)), new OracleParameter(":UPDATEUSERNAME",dal.GetValue(entity.CREATEUSERNAME)), new OracleParameter(":UPDATEDATE",dal.GetValue(DateTime.Now)), new OracleParameter(":MESSAGEID",dal.GetValue(entity.MESSAGEID)) }; dal.ExecuteSql(updSql, pageparm); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
public bool GetBool(T_WF_DEFAULTMESSAGE message) { string sql = "select * from T_WF_DEFAULTMESSAGE where SYSTEMCODE='" + message.SYSTEMCODE + "' and MODELCODE='" + message.MODELCODE + "' and AUDITSTATE='" + message.AUDITSTATE + "'"; sql += " and MESSAGEID!='" + message.MESSAGEID + "'"; if (dal.GetDataTable(sql).Rows.Count > 0) { return false; } return true; }