public ExecResult SaveYearVolume(YearVolumeEntity model)
{
IIssueService service = ServiceContainer.Instance.Container.Resolve<IIssueService>();
return service.SaveYearVolume(model);
}
/// <summary>
/// 组装年卷数据
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private YearVolumeEntity MakeYearVolume(IDataReader dr)
{
YearVolumeEntity model = new YearVolumeEntity();
model.SetID = (Int64)dr["SetID"];
model.JournalID = (Int64)dr["JournalID"];
model.Year = (Int32)dr["Year"];
model.Volume = (Int32)dr["Volume"];
model.Status = (Byte)dr["Status"];
model.AddDate = (DateTime)dr["AddDate"];
return model;
}
/// <summary>
/// 新增年卷
/// </summary>
/// <param name="yearVolumeEntity"></param>
/// <returns></returns>
public bool AddYearVolume(YearVolumeEntity yearVolumeEntity)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" @JournalID");
sqlCommandText.Append(", @Year");
sqlCommandText.Append(", @Volume");
sqlCommandText.Append(", @Status");
DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.YearVolume ({0},AddDate) VALUES ({1},getdate())", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString()));
db.AddInParameter(cmd, "@JournalID", DbType.Int64, yearVolumeEntity.JournalID);
db.AddInParameter(cmd, "@Year", DbType.Int32, yearVolumeEntity.Year);
db.AddInParameter(cmd, "@Volume", DbType.Int32, yearVolumeEntity.Volume);
db.AddInParameter(cmd, "@Status", DbType.Byte, yearVolumeEntity.Status);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return flag;
}
/// <summary>
/// 编辑年卷
/// </summary>
/// <param name="yearVolumeEntity"></param>
/// <returns></returns>
public bool UpdateYearVolume(YearVolumeEntity yearVolumeEntity)
{
bool flag = false;
StringBuilder whereCommandText = new StringBuilder();
whereCommandText.Append(" SetID=@SetID");
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" Year=@Year");
sqlCommandText.Append(", Volume=@Volume");
sqlCommandText.Append(", Status=@Status");
DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.YearVolume SET {0} WHERE {1}", sqlCommandText.ToString(), whereCommandText.ToString()));
db.AddInParameter(cmd, "@SetID", DbType.Int64, yearVolumeEntity.SetID);
db.AddInParameter(cmd, "@Year", DbType.Int32, yearVolumeEntity.Year);
db.AddInParameter(cmd, "@Volume", DbType.Int32, yearVolumeEntity.Volume);
db.AddInParameter(cmd, "@Status", DbType.Byte, yearVolumeEntity.Status);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return flag;
}
/// <summary>
/// 年是否存在
/// </summary>
/// <param name="yearVolumeEntity"></param>
/// <returns></returns>
public bool YearVolumeYearIsExists(YearVolumeEntity yearVolumeEntity)
{
string strSql = string.Format("SELECT 1 FROM dbo.YearVolume WHERE JournalID={0} and Year={1}", yearVolumeEntity.JournalID, yearVolumeEntity.Year);
if (yearVolumeEntity.SetID > 0)
strSql += " and SetID<>" + yearVolumeEntity.SetID;
DbCommand cmd = db.GetSqlStringCommand(strSql);
return db.ExecuteScalar(cmd).TryParse<Int32>() == 1;
}
/// <summary>
/// 新增年卷
/// </summary>
/// <param name="yearVolumeEntity"></param>
/// <returns></returns>
public bool AddYearVolume(YearVolumeEntity yearVolumeEntity)
{
return IssueDataAccess.Instance.AddYearVolume(yearVolumeEntity);
}
/// <summary>
/// 获取最新的年卷
/// </summary>
/// <param name="JournalID"></param>
/// <returns></returns>
public YearVolumeEntity GetMaxYearVolume(Int64 JournalID)
{
YearVolumeEntity model = null;
string strSql = string.Format("SELECT MAX(Year) as Year,MAX(Volume) as Volume FROM dbo.YearVolume WHERE JournalID={0}", JournalID);
DbCommand cmd = db.GetSqlStringCommand(strSql);
using (IDataReader dr = db.ExecuteReader(cmd))
{
if (dr.Read())
{
model = new YearVolumeEntity();
model.Year = dr.GetDrValue<Int32>("Year", 2004) + 1;
model.Volume = dr.GetDrValue<Int32>("Volume", 0) + 1;
}
dr.Close();
}
return model;
}
/// <summary>
/// 编辑年卷
/// </summary>
/// <param name="yearVolumeEntity"></param>
/// <returns></returns>
public bool UpdateYearVolume(YearVolumeEntity yearVolumeEntity)
{
return IssueDataAccess.Instance.UpdateYearVolume(yearVolumeEntity);
}
/// <summary>
/// 年是否存在
/// </summary>
/// <param name="yearVolumeEntity"></param>
/// <returns></returns>
public bool YearVolumeYearIsExists(YearVolumeEntity yearVolumeEntity)
{
return IssueDataAccess.Instance.YearVolumeYearIsExists(yearVolumeEntity);
}
public ActionResult SaveYearVolume(YearVolumeEntity model)
{
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
model.JournalID = CurAuthor.JournalID;
ExecResult result = service.SaveYearVolume(model);
return Json(new { result = result.result, msg = result.msg });
}
private YearVolumeEntity GetYearVolumeModel(Int64 SetID)
{
YearVolumeQuery query = new YearVolumeQuery();
query.JournalID = CurAuthor.JournalID;
query.setID = SetID;
IIssueFacadeService service = ServiceContainer.Instance.Container.Resolve<IIssueFacadeService>();
YearVolumeEntity model = service.GetYearVolumeModel(query);
if (model == null)
model = new YearVolumeEntity();
return model;
}
/// <summary>
/// 保存年卷设置
/// </summary>
/// <param name="query"></param>
/// <returns></returns>
public ExecResult SaveYearVolume(YearVolumeEntity model)
{
HttpClientHelper clientHelper = new HttpClientHelper();
ExecResult result = clientHelper.Post<ExecResult, YearVolumeEntity>(GetAPIUrl(APIConstant.YEARVOLUME_SAVE), model);
return result;
}
/// <summary>
/// 年是否存在
/// </summary>
/// <param name="yearVolumeEntity"></param>
/// <returns></returns>
public bool YearVolumeYearIsExists(YearVolumeEntity yearVolumeEntity)
{
return IssueBusProvider.YearVolumeYearIsExists(yearVolumeEntity);
}
/// <summary>
/// 编辑年卷
/// </summary>
/// <param name="yearVolumeEntity"></param>
/// <returns></returns>
public bool UpdateYearVolume(YearVolumeEntity yearVolumeEntity)
{
return IssueBusProvider.UpdateYearVolume(yearVolumeEntity);
}
/// <summary>
/// 保存年卷设置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ExecResult SaveYearVolume(YearVolumeEntity model)
{
ExecResult execResult = new ExecResult();
if (YearVolumeYearIsExists(model))
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "该年信息已经存在！";
return execResult;
}
if (YearVolumeVolumeIsExists(model))
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "该卷信息已经存在！";
return execResult;
}
bool result = false;
if (model.SetID == 0)
result = AddYearVolume(model);
else
result = UpdateYearVolume(model);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "保存年卷设置成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "保存年卷设置失败！";
}
return execResult;
}
/// <summary>
/// 新增年卷
/// </summary>
/// <param name="yearVolumeEntity"></param>
/// <returns></returns>
public bool AddYearVolume(YearVolumeEntity yearVolumeEntity)
{
return IssueBusProvider.AddYearVolume(yearVolumeEntity);
}
