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