/// <summary> /// 设置稿件编号格式 /// </summary> /// <param name="cSetEntity"></param> /// <returns></returns> public bool SetContributeNumberFormat(ContributeSetEntity cSetEntity) { return ContributeSetDataAccess.Instance.SetContributeNumberFormat(cSetEntity); }
/// <summary> /// 更新投稿公告 /// </summary> /// <param name="cSetEntity"></param> /// <returns></returns> public bool UpdateStatement(ContributeSetEntity cSetEntity) { return ContributeSetDataAccess.Instance.UpdateStatement(cSetEntity); }
public ActionResult SetStatementAjax(ContributeSetEntity cSetEntity) { ExecResult execResult = new ExecResult(); try { cSetEntity.JournalID = JournalID; IContributionFacadeService service = ServiceContainer.Instance.Container.Resolve<IContributionFacadeService>(); execResult = service.SetContruibuteStatement(cSetEntity); } catch (Exception ex) { execResult.result = EnumJsonResult.error.ToString(); execResult.msg = "设置投稿声明出现异常:" + ex.Message; WKT.Log.LogProvider.Instance.Error("设置投稿声明出现异常:" + ex.Message); } return Content(JsonConvert.SerializeObject(execResult)); }
/// <summary> /// 稿件编号设置 /// </summary> /// <returns></returns> public ActionResult NumberSet() { IContributionFacadeService service = ServiceContainer.Instance.Container.Resolve<IContributionFacadeService>(); QueryBase query = new QueryBase(); query.JournalID = JournalID; ContributeSetEntity cSetEntity = service.GetContributeSetInfo(query); if (cSetEntity == null) { cSetEntity = new ContributeSetEntity(); } return View(cSetEntity); }
/// <summary> /// 设置稿件编号格式 /// </summary> /// <param name="cSetEntity"></param> /// <returns></returns> public bool SetContributeNumberFormat(ContributeSetEntity cSetEntity) { bool flag = false; string sql = @" IF EXISTS(SELECT TOP 1 1 FROM dbo.ContributeSet c WITH(NOLOCK) WHERE c.JournalID=@JournalID) BEGIN UPDATE TOP(1) dbo.ContributeSet SET CCodeType=@CCodeType,CCodeFormat=@CCodeFormat,Separator=@Separator,RandomDigit=@RandomDigit WHERE JournalID=@JournalID END ELSE BEGIN INSERT INTO dbo.ContributeSet(JournalID,CCodeType,CCodeFormat,Separator,RandomDigit) VALUES(@JournalID,@CCodeType,@CCodeFormat,@Separator,@RandomDigit) END"; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@JournalID", DbType.Int64, cSetEntity.JournalID); db.AddInParameter(cmd, "@CCodeType", DbType.Int16, cSetEntity.CCodeType); db.AddInParameter(cmd, "@CCodeFormat", DbType.String, cSetEntity.CCodeFormat); db.AddInParameter(cmd, "@Separator", DbType.String, cSetEntity.Separator); db.AddInParameter(cmd, "@RandomDigit", DbType.Int16, cSetEntity.RandomDigit); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return flag; }
/// <summary> /// 更新投稿公告 /// </summary> /// <param name="cSetEntity"></param> /// <returns></returns> public bool UpdateStatement(ContributeSetEntity cSetEntity) { bool flag = false; string sql = @" IF EXISTS(SELECT TOP 1 1 FROM dbo.ContributeSet c WITH(NOLOCK) WHERE c.JournalID=@JournalID) BEGIN UPDATE TOP(1) dbo.ContributeSet SET [Statement]=@Statement WHERE JournalID=@JournalID END ELSE BEGIN INSERT INTO dbo.ContributeSet(JournalID,CCodeType,CCodeFormat,Separator,RandomDigit,Statement) VALUES(@JournalID,3,'','-','3',@Statement) END"; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@JournalID", DbType.Int64, cSetEntity.JournalID); db.AddInParameter(cmd, "@Statement", DbType.AnsiString, cSetEntity.Statement.HtmlFilter()); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return flag; }
/// <summary> /// 得到投稿配置信息 /// </summary> /// <param name="query"></param> /// <returns></returns> public ContributeSetEntity GetContributeSetInfo(QueryBase query) { ContributeSetEntity cSetEntity = new ContributeSetEntity(); StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 [CSetID],[JournalID],[CCodeType],[CCodeFormat],[Separator],[RandomDigit],[Statement] FROM dbo.[ContributeSet] WITH(NOLOCK) WHERE JournalID=@JournalID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@JournalID", DbType.Int64, query.JournalID); using (IDataReader dr = db.ExecuteReader(cmd)) { if (dr.Read()) { cSetEntity = new ContributeSetEntity(); cSetEntity.CSetID = (Int64)dr["CSetID"]; cSetEntity.JournalID = (Int64)dr["JournalID"]; cSetEntity.CCodeType = (Byte)dr["CCodeType"]; cSetEntity.CCodeFormat = (String)dr["CCodeFormat"]; cSetEntity.Separator = (String)dr["Separator"]; cSetEntity.RandomDigit = (Byte)dr["RandomDigit"]; cSetEntity.Statement = (String)dr["Statement"]; } dr.Close(); } return cSetEntity; }
/// <summary> /// 设置稿件编号格式 /// </summary> /// <param name="cSetEntity"></param> /// <returns></returns> public bool SetContributeNumberFormat(ContributeSetEntity cSetEntity) { return ContributeSetBusProvider.SetContributeNumberFormat(cSetEntity); }
/// <summary> /// 更新投稿公告 /// </summary> /// <param name="cSetEntity"></param> /// <returns></returns> public bool UpdateStatement(ContributeSetEntity cSetEntity) { return ContributeSetBusProvider.UpdateStatement(cSetEntity); }
/// <summary> /// 更新投稿公告 /// </summary> /// <param name="cSetEntity"></param> /// <returns></returns> public ExecResult SetContruibuteStatement(ContributeSetEntity cSetEntity) { HttpClientHelper clientHelper = new HttpClientHelper(); ExecResult execResult = clientHelper.PostAuth<ExecResult, ContributeSetEntity>(GetAPIUrl(APIConstant.CONTRIBUTIOSTATEMENTSET), cSetEntity); return execResult; }
/// <summary> /// 设置稿件编号格式 /// </summary> /// <param name="cSetEntity"></param> /// <returns></returns> public ExecResult SetContributeNumberFormat(ContributeSetEntity cSetEntity) { HttpClientHelper clientHelper = new HttpClientHelper(); ExecResult execResult = clientHelper.PostAuth<ExecResult, ContributeSetEntity>(GetAPIUrl(APIConstant.CONTRIBUTIONNUMBERSET), cSetEntity); return execResult; }