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