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