public bool UpdateDictValue(DictValueEntity dictValueEntity)
{
bool flag = false;
StringBuilder whereCommandText = new StringBuilder();
whereCommandText.Append(" DictValueID=@DictValueID");
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" ValueID=@ValueID");
sqlCommandText.Append(", ValueText=@ValueText");
sqlCommandText.Append(", SortID=@SortID");
sqlCommandText.Append(", EditUserID=@EditUserID");
sqlCommandText.Append(", EditDate=getdate()");
DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.DictValue SET {0} WHERE {1}", sqlCommandText.ToString(), whereCommandText.ToString()));
db.AddInParameter(cmd, "@DictValueID", DbType.Int64, dictValueEntity.DictValueID);
db.AddInParameter(cmd, "@ValueID", DbType.Int32, dictValueEntity.ValueID);
db.AddInParameter(cmd, "@ValueText", DbType.AnsiString, dictValueEntity.ValueText);
db.AddInParameter(cmd, "@SortID", DbType.Int32, dictValueEntity.SortID);
db.AddInParameter(cmd, "@EditUserID", DbType.Int64, dictValueEntity.EditUserID);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
public ExecResult SaveDictValue(DictValueEntity model)
{
ExecResult execResult = new ExecResult();
IDictValueService service = ServiceContainer.Instance.Container.Resolve <IDictValueService>();
return(service.Save(model));
}
public bool AddDictValue(DictValueEntity dictValueEntity)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" @JournalID");
sqlCommandText.Append(", @DictKey");
sqlCommandText.Append(", @ValueID");
sqlCommandText.Append(", @ValueText");
sqlCommandText.Append(", @SortID");
sqlCommandText.Append(", @InUserID");
DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.DictValue ({0}) VALUES ({1})", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString()));
db.AddInParameter(cmd, "@JournalID", DbType.Int64, dictValueEntity.JournalID);
db.AddInParameter(cmd, "@DictKey", DbType.AnsiString, dictValueEntity.DictKey);
db.AddInParameter(cmd, "@ValueID", DbType.Int32, dictValueEntity.ValueID);
db.AddInParameter(cmd, "@ValueText", DbType.AnsiString, dictValueEntity.ValueText);
db.AddInParameter(cmd, "@SortID", DbType.Int32, dictValueEntity.SortID);
db.AddInParameter(cmd, "@InUserID", DbType.Int64, dictValueEntity.InUserID);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
public DictValueEntity GetDictValueModel(DictValueQuery query)
{
IDictValueService service = ServiceContainer.Instance.Container.Resolve <IDictValueService>();
DictValueEntity model = service.GetDictValue(query.DictValueID);
return(model);
}
public List <DictValueEntity> MakeDictValueList(DataTable dt)
{
List <DictValueEntity> list = new List <DictValueEntity>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DictValueEntity dictValueEntity = MakeDictValue(dt.Rows[i]);
list.Add(dictValueEntity);
}
}
return(list);
}
public ActionResult SaveDictValue(DictValueEntity model)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
if (model.DictValueID == 0)
{
model.InUserID = CurAuthor.AuthorID;
}
else
{
model.EditUserID = CurAuthor.AuthorID;
}
model.JournalID = CurAuthor.JournalID;
ExecResult result = service.SaveDictValue(model);
return(Json(new { result = result.result, msg = result.msg }));
}
public DictValueEntity GetDictValue(Int64 dictValueID)
{
DictValueEntity dictValueEntity = null;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("SELECT TOP 1 DictValueID,JournalID,DictKey,ValueID,ValueText,SortID,InUserID,EditUserID,EditDate,AddDate FROM dbo.DictValue WITH(NOLOCK)");
sqlCommandText.Append(" WHERE DictValueID=@DictValueID");
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
db.AddInParameter(cmd, "@DictValueID", DbType.Int64, dictValueID);
using (IDataReader dr = db.ExecuteReader(cmd))
{
dictValueEntity = MakeDictValue(dr);
}
return(dictValueEntity);
}
/// <summary>
/// 保存数据字典值
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ExecResult Save(DictValueEntity model)
{
ExecResult execResult = new ExecResult();
model.DictKey = model.DictKey.TextFilter();
if (DictValueIsExists(model))
{
execResult.result = EnumJsonResult.error.ToString();
execResult.msg = "该数据字典值Value已存在！";
return(execResult);
}
bool result = false;
model.ValueText = model.ValueText.TextFilter();
if (model.DictValueID == 0)
{
result = AddDictValue(model);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "新增数据字典值成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "新增数据字典值失败！";
}
}
else
{
result = UpdateDictValue(model);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "修改数据字典值成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "修改数据字典值失败！";
}
}
return(execResult);
}
public ActionResult CreateDictValue(Int64 dictValueId = 0)
{
DictValueEntity model = null;
if (dictValueId > 0)
{
DictValueQuery query = new DictValueQuery();
query.JournalID = CurAuthor.JournalID;
query.DictValueID = dictValueId;
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
model = service.GetDictValueModel(query);
}
if (model == null)
{
model = new DictValueEntity();
}
return(View(model));
}
public DictValueEntity MakeDictValue(DataRow dr)
{
DictValueEntity dictValueEntity = null;
if (dr != null)
{
dictValueEntity = new DictValueEntity();
dictValueEntity.DictValueID = (Int64)dr["DictValueID"];
dictValueEntity.JournalID = (Int64)dr["JournalID"];
dictValueEntity.DictKey = (String)dr["DictKey"];
dictValueEntity.ValueID = (Int32)dr["ValueID"];
dictValueEntity.ValueText = (String)dr["ValueText"];
dictValueEntity.SortID = (Int32)dr["SortID"];
dictValueEntity.InUserID = (Int64)dr["InUserID"];
dictValueEntity.EditUserID = (Int64)dr["EditUserID"];
dictValueEntity.EditDate = (DateTime)dr["EditDate"];
dictValueEntity.AddDate = (DateTime)dr["AddDate"];
}
return(dictValueEntity);
}
/// <summary>
/// 数据字典值是否已经存在
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool DictValueIsExists(DictValueEntity model)
{
string strSql = "SELECT 1 FROM dbo.DictValue a with(nolock) WHERE JournalID=@JournalID and DictKey=@DictKey and ValueID=@ValueID";
if (model.DictValueID > 0)
{
strSql += " and DictValueID<>" + model.DictValueID;
}
DbCommand cmd = db.GetSqlStringCommand(strSql);
db.AddInParameter(cmd, "@JournalID", DbType.Int64, model.JournalID);
db.AddInParameter(cmd, "@DictKey", DbType.AnsiString, model.DictKey);
db.AddInParameter(cmd, "@ValueID", DbType.Int32, model.ValueID);
object obj = db.ExecuteScalar(cmd);
if (obj == null)
{
return(false);
}
return(obj.TryParse <Int32>() == 1);
}
public List <DictValueEntity> MakeDictValueList(IDataReader dr)
{
List <DictValueEntity> list = new List <DictValueEntity>();
while (dr.Read())
{
DictValueEntity dictValueEntity = new DictValueEntity();
dictValueEntity.DictValueID = (Int64)dr["DictValueID"];
dictValueEntity.JournalID = (Int64)dr["JournalID"];
dictValueEntity.DictKey = (String)dr["DictKey"];
dictValueEntity.ValueID = (Int32)dr["ValueID"];
dictValueEntity.ValueText = (String)dr["ValueText"];
dictValueEntity.SortID = (Int32)dr["SortID"];
dictValueEntity.InUserID = (Int64)dr["InUserID"];
dictValueEntity.EditUserID = (Int64)dr["EditUserID"];
dictValueEntity.EditDate = (DateTime)dr["EditDate"];
dictValueEntity.AddDate = (DateTime)dr["AddDate"];
list.Add(dictValueEntity);
}
dr.Close();
return(list);
}
public bool DeleteDictValue(DictValueEntity dictValueEntity)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("DELETE FROM dbo.DictValue");
sqlCommandText.Append(" WHERE DictValueID=@DictValueID");
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
db.AddInParameter(cmd, "@DictValueID", DbType.Int64, dictValueEntity.DictValueID);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
/// <summary>
/// 数据字典值是否已经存在
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool DictValueIsExists(DictValueEntity model)
{
return(DictValueBusProvider.DictValueIsExists(model));
}
/// <summary>
/// 从存储媒介删除实体数据
/// </summary>
/// <param name="dictValue">DictValueEntity实体对象</param>
/// <returns>true:删除成功 false：删除失败</returns>
public bool DeleteDictValue(DictValueEntity dictValue)
{
return(DictValueBusProvider.DeleteDictValue(dictValue));
}
/// <summary>
/// 更新存储媒介中的实体数据
/// </summary>
/// <param name="dictValue">DictValueEntity实体对象</param>
/// <returns>true:更新成功 false：更新失败</returns>
public bool UpdateDictValue(DictValueEntity dictValue)
{
return(DictValueBusProvider.UpdateDictValue(dictValue));
}
/// <summary>
/// 将实体数据存入存储媒介（持久化一个对象）
/// </summary>
/// <param name="dictValue">DictValueEntity实体对象</param>
/// <returns>true:存储成功 false：存储失败</returns>
public bool AddDictValue(DictValueEntity dictValue)
{
return(DictValueBusProvider.AddDictValue(dictValue));
}
/// <summary>
/// 从存储媒介删除实体数据
/// </summary>
/// <param name="dictValue">DictValueEntity实体对象</param>
/// <returns>true:删除成功 false：删除失败</returns>
public bool DeleteDictValue(DictValueEntity dictValue)
{
return(DictValueDataAccess.Instance.DeleteDictValue(dictValue));
}
/// <summary>
/// 数据字典值是否已经存在
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool DictValueIsExists(DictValueEntity model)
{
return(DictValueDataAccess.Instance.DictValueIsExists(model));
}
/// <summary>
/// 将实体数据存入存储媒介（持久化一个对象）
/// </summary>
/// <param name="dictValue">DictValueEntity实体对象</param>
/// <returns>true:存储成功 false：存储失败</returns>
public bool AddDictValue(DictValueEntity dictValue)
{
return(DictValueDataAccess.Instance.AddDictValue(dictValue));
}
public ActionResult SavePayNotice(PayNoticeEntity model)
{
IFinanceFacadeAPIService service = ServiceContainer.Instance.Container.Resolve <IFinanceFacadeAPIService>();
model.JournalID = CurAuthor.JournalID;
model.SendUser = CurAuthor.AuthorID;
model.Status = 0;
model.Body = Server.UrlDecode(model.Body).Replace("${金额}$", model.Amount.ToString());
if (model.NoticeID == 0)
{
#region 改变稿件状态 为 通知交审稿费
int actionID = 0;
ISiteConfigFacadeService facadeService = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
DictEntity dicteEntity = null;
if (model.PayType == 1)//审稿费
{
dicteEntity = facadeService.GetDictModelByKey(new DictQuery()
{
JournalID = CurAuthor.JournalID, DictKey = "PayNotice"
});
}
else //版面费
{
dicteEntity = facadeService.GetDictModelByKey(new DictQuery()
{
JournalID = CurAuthor.JournalID, DictKey = "PayPageNotice"
});
}
if (dicteEntity != null)
{
ISiteConfigFacadeService currentService = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
IList <DictValueEntity> list = currentService.GetDictValueList(new DictValueQuery()
{
JournalID = CurAuthor.JournalID, DictKey = dicteEntity.DictKey
});
if (list != null && list.Count > 0)
{
DictValueEntity entity = list.Single <DictValueEntity>();
if (entity != null)
{
actionID = entity.ValueID;
#region 获取流程操作
FlowActionQuery actionQuery = new FlowActionQuery();
actionQuery.JournalID = JournalID;
actionQuery.ToStatusID = actionID;
IFlowFacadeService flowService = ServiceContainer.Instance.Container.Resolve <IFlowFacadeService>();
IList <FlowActionEntity> actionEntityList = flowService.GetFlowActionList(actionQuery);
//long statusID = actionEntity != null ? actionEntity.StatusID : 0;
#endregion
#region 根据审稿状态获取 审稿流程日志ID
CirculationEntity cirQuery = new CirculationEntity();
AuditBillEntity auditBillEntity = new AuditBillEntity();
cirQuery.CID = model.CID;
cirQuery.JournalID = JournalID;
cirQuery.GroupID = 1;
IFlowFacadeService flowInfoLogService = ServiceContainer.Instance.Container.Resolve <IFlowFacadeService>();
IList <FlowLogInfoEntity> flowLogEntityList = flowInfoLogService.GetFlowLog(cirQuery);
FlowActionEntity single = null;
FlowLogInfoEntity flowLogEntity = null;
if (flowLogEntityList != null && flowLogEntityList.Count > 0)
{
auditBillEntity.ReveiverList = flowLogEntityList[flowLogEntityList.Count - 1].SendUserID.ToString();
flowLogEntity = flowLogEntityList.OrderByDescending(o => o.FlowLogID).Take(1).SingleOrDefault();
single = actionEntityList.Where(o => o.StatusID == flowLogEntity.TargetStatusID).FirstOrDefault();
}
#endregion
IFlowFacadeService flowFacadeService = ServiceContainer.Instance.Container.Resolve <IFlowFacadeService>();
auditBillEntity.JournalID = JournalID;
auditBillEntity.Processer = CurAuthor.AuthorID;
if (single != null)
{
auditBillEntity.ActionID = single.ActionID;
auditBillEntity.StatusID = single.StatusID;
}
auditBillEntity.ActionType = 1;
auditBillEntity.CID = model.CID;
if (flowLogEntity != null)
{
auditBillEntity.FlowLogID = flowLogEntity.FlowLogID;
auditBillEntity.CPath = "";
auditBillEntity.FigurePath = "";
auditBillEntity.OtherPath = "";
}
flowFacadeService.SubmitAuditBill(auditBillEntity);
}
}
}
#endregion
}
ExecResult result = service.SavePayNotice(model);
return(Json(new { result = result.result, msg = result.msg }));
}
public ActionResult BatchSavePayNotice(PayNoticeEntity model)
{
IFinanceFacadeAPIService service = ServiceContainer.Instance.Container.Resolve <IFinanceFacadeAPIService>();
IList <PayNoticeEntity> list = (IList <PayNoticeEntity>)TempData["list"];
if (list != null && list.Count > 0)
{
#region 批量改变稿件状态 为 通知交审稿费
int actionID = 0;
ISiteConfigFacadeService facadeService = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
DictEntity dicteEntity = null;
if (model.PayType == 1)//审稿费
{
dicteEntity = facadeService.GetDictModelByKey(new DictQuery()
{
JournalID = CurAuthor.JournalID, DictKey = "PayNotice"
});
}
else //版面费
{
dicteEntity = facadeService.GetDictModelByKey(new DictQuery()
{
JournalID = CurAuthor.JournalID, DictKey = "PayPageNotice"
});
}
if (dicteEntity != null)
{
ISiteConfigFacadeService currentService = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
IList <DictValueEntity> currentList = currentService.GetDictValueList(new DictValueQuery()
{
JournalID = CurAuthor.JournalID, DictKey = dicteEntity.DictKey
});
if (currentList != null && currentList.Count > 0)
{
DictValueEntity entity = currentList.Single <DictValueEntity>();
if (entity != null)
{
actionID = entity.ValueID;
IFlowFacadeService flowFacadeService = ServiceContainer.Instance.Container.Resolve <IFlowFacadeService>();
#region 获取流程操作
FlowActionQuery actionQuery = new FlowActionQuery();
actionQuery.JournalID = JournalID;
actionQuery.ToStatusID = actionID;
IFlowFacadeService flowService = ServiceContainer.Instance.Container.Resolve <IFlowFacadeService>();
IList <FlowActionEntity> actionEntityList = flowService.GetFlowActionList(actionQuery);
#endregion
foreach (var item in list)
{
item.Status = 0;
item.Body = Server.UrlDecode(model.Body).Replace("${金额}$", model.Amount.ToString()).Replace("${接收人}$", item.AuthorName).Replace("${邮箱}$", item.LoginName).Replace("${稿件编号}$", item.CNumber).Replace("${稿件标题}$", item.CTitle).Replace("${手机}$", item.Mobile);
item.SendUser = CurAuthor.AuthorID;
item.Amount = model.Amount;
item.Title = model.Title;
if (item.NoticeID == 0)
{
#region 根据审稿状态获取 审稿流程日志ID
CirculationEntity cirQuery = new CirculationEntity();
cirQuery.CID = item.CID;
cirQuery.JournalID = JournalID;
cirQuery.GroupID = 1;
IFlowFacadeService flowInfoLogService = ServiceContainer.Instance.Container.Resolve <IFlowFacadeService>();
IList <FlowLogInfoEntity> flowLogEntityList = flowInfoLogService.GetFlowLog(cirQuery);
FlowActionEntity single = null;
FlowLogInfoEntity flowLogEntity = null;
if (flowLogEntityList != null && flowLogEntityList.Count > 0)
{
flowLogEntity = flowLogEntityList.OrderByDescending(o => o.FlowLogID).Take(1).SingleOrDefault();
single = actionEntityList.Where(o => o.StatusID == flowLogEntity.TargetStatusID).SingleOrDefault();
}
#endregion
#region 批量提交审稿状态
AuditBillEntity auditBillEntity = new AuditBillEntity();
auditBillEntity.JournalID = JournalID;
auditBillEntity.Processer = CurAuthor.AuthorID;
auditBillEntity.ActionType = 1;
auditBillEntity.CID = item.CID;
if (single != null && flowLogEntity != null)
{
auditBillEntity.ActionID = single.ActionID;
auditBillEntity.StatusID = single.StatusID;
auditBillEntity.ReveiverList = flowLogEntity.RecUserID.ToString();
auditBillEntity.FlowLogID = flowLogEntity.FlowLogID;
auditBillEntity.CPath = string.IsNullOrEmpty(flowLogEntity.CPath) ? "" : flowLogEntity.CPath;
auditBillEntity.FigurePath = string.IsNullOrEmpty(flowLogEntity.FigurePath) ? "" : flowLogEntity.FigurePath;
auditBillEntity.OtherPath = string.IsNullOrEmpty(flowLogEntity.OtherPath) ? "" : flowLogEntity.OtherPath;
flowFacadeService.SubmitAuditBill(auditBillEntity);
}
#endregion
}
}
}
}
}
#endregion
}
ExecResult result = service.BatchSavePayNotice(list);
return(Json(new { result = result.result, msg = result.msg }));
}
