public bool DownloadCount(SiteResourceEntity model)
{
ISiteResourceService service = ServiceContainer.Instance.Container.Resolve <ISiteResourceService>();
bool result = service.AccumulationDownloadCount(model);
return(result);
}
/// <summary>
/// 累加下载次数
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AccumulationDownloadCount(SiteResourceEntity model)
{
string strSql = string.Format("UPDATE dbo.SiteResource set DownloadCount=DownloadCount+1 WHERE ResourceID={0}", model.ResourceID);
DbCommand cmd = db.GetSqlStringCommand(strSql);
return(db.ExecuteNonQuery(cmd) > 0);
}
public SiteResourceEntity GetModel(SiteResourceQuery query)
{
ISiteResourceService service = ServiceContainer.Instance.Container.Resolve <ISiteResourceService>();
SiteResourceEntity model = service.GetSiteResourceModel(query);
return(model);
}
/// <summary>
/// 获取资源实体
/// </summary>
/// <param name="ResourceID"></param>
/// <returns></returns>
public SiteResourceEntity GetSiteResourceModel(SiteResourceQuery query)
{
SiteResourceEntity item = null;
string strSql = string.Format("SELECT TOP 1 * FROM dbo.SiteResource with(nolock) WHERE ResourceID=@ResourceID AND JournalID=@JournalID");
DbCommand cmd = db.GetSqlStringCommand(strSql);
db.AddInParameter(cmd, "@JournalID", DbType.Int64, query.JournalID);
db.AddInParameter(cmd, "@ResourceID", DbType.Int64, query.ResourceID);
using (IDataReader dr = db.ExecuteReader(cmd))
{
if (dr.Read())
{
item = MakeSiteResourceModel(dr);
}
}
return(item);
}
public ActionResult Save(SiteResourceEntity model)
{
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
model.JournalID = CurAuthor.JournalID;
if (model.ResourceID == 0)
{
model.InUserID = CurAuthor.AuthorID;
}
else
{
model.EditUserID = CurAuthor.AuthorID;
}
ExecResult result = service.SaveSiteResource(model);
return(Json(new { result = result.result, msg = result.msg }));
}
private SiteResourceEntity GetModel(Int64 ResourceID)
{
SiteResourceEntity model = null;
if (ResourceID > 0)
{
SiteResourceQuery query = new SiteResourceQuery();
query.JournalID = CurAuthor.JournalID;
query.ResourceID = ResourceID;
ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>();
model = service.GetSiteResourceModel(query);
}
if (model == null)
{
model = new SiteResourceEntity();
}
return(model);
}
/// <summary>
/// 组装数据
/// </summary>
/// <param name="dr"></param>
/// <returns></returns>
private SiteResourceEntity MakeSiteResourceModel(IDataReader dr)
{
SiteResourceEntity model = new SiteResourceEntity();
model.ResourceID = (Int64)dr["ResourceID"];
model.JournalID = (Int64)dr["JournalID"];
model.ChannelID = (Int64)dr["ChannelID"];
model.Name = (String)dr["Name"];
model.FileIntro = (String)dr["FileIntro"];
model.FilePath = (String)dr["FilePath"];
model.FileEx = (String)dr["FileEx"];
model.FileSize = (Decimal)dr["FileSize"];
model.DownloadCount = (Int32)dr["DownloadCount"];
model.InUserID = (Int64)dr["InUserID"];
model.EditUserID = (Int64)dr["EditUserID"];
model.EditDate = (DateTime)dr["EditDate"];
model.AddDate = (DateTime)dr["AddDate"];
return(model);
}
/// <summary>
/// 新增资源
/// </summary>
/// <param name="SiteResourceEntity"></param>
/// <returns></returns>
public bool AddSiteResource(SiteResourceEntity model)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" @JournalID");
sqlCommandText.Append(", @ChannelID");
sqlCommandText.Append(", @Name");
sqlCommandText.Append(", @FileIntro");
sqlCommandText.Append(", @FilePath");
sqlCommandText.Append(", @FileEx");
sqlCommandText.Append(", @FileSize");
sqlCommandText.Append(", @DownloadCount");
sqlCommandText.Append(", @InUserID");
DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.SiteResource ({0},AddDate) VALUES ({1},getdate())", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString()));
db.AddInParameter(cmd, "@JournalID", DbType.Int64, model.JournalID);
db.AddInParameter(cmd, "@ChannelID", DbType.Int64, model.ChannelID);
db.AddInParameter(cmd, "@Name", DbType.AnsiString, model.Name);
db.AddInParameter(cmd, "@FileIntro", DbType.AnsiString, model.FileIntro);
db.AddInParameter(cmd, "@FilePath", DbType.AnsiString, model.FilePath);
db.AddInParameter(cmd, "@FileEx", DbType.AnsiString, model.FileEx);
db.AddInParameter(cmd, "@FileSize", DbType.Decimal, model.FileSize);
db.AddInParameter(cmd, "@DownloadCount", DbType.Int32, model.DownloadCount);
db.AddInParameter(cmd, "@InUserID", DbType.Int64, model.InUserID);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
/// <summary>
/// 编辑资源
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateSiteResource(SiteResourceEntity model)
{
bool flag = false;
StringBuilder whereCommandText = new StringBuilder();
whereCommandText.Append(" ResourceID=@ResourceID");
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" Name=@Name");
sqlCommandText.Append(", FileIntro=@FileIntro");
sqlCommandText.Append(", FilePath=@FilePath");
sqlCommandText.Append(", FileEx=@FileEx");
sqlCommandText.Append(", FileSize=@FileSize");
sqlCommandText.Append(", EditUserID=@EditUserID");
sqlCommandText.Append(", EditDate=getdate()");
DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.SiteResource SET {0} WHERE {1}", sqlCommandText.ToString(), whereCommandText.ToString()));
db.AddInParameter(cmd, "@ResourceID", DbType.Int64, model.ResourceID);
db.AddInParameter(cmd, "@Name", DbType.AnsiString, model.Name);
db.AddInParameter(cmd, "@FileIntro", DbType.AnsiString, model.FileIntro);
db.AddInParameter(cmd, "@FilePath", DbType.AnsiString, model.FilePath);
db.AddInParameter(cmd, "@FileEx", DbType.AnsiString, model.FileEx);
db.AddInParameter(cmd, "@FileSize", DbType.Decimal, model.FileSize);
db.AddInParameter(cmd, "@EditUserID", DbType.Int64, model.EditUserID);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
/// <summary>
/// 保存资源
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ExecResult Save(SiteResourceEntity model)
{
ExecResult execResult = new ExecResult();
bool result = false;
model.Name = model.Name.TextFilter();
model.FileIntro = model.FileIntro.TextFilter();
if (model.ResourceID == 0)
{
result = AddSiteResource(model);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "新增资源文件成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "新增资源文件失败！";
}
}
else
{
result = UpdateSiteResource(model);
if (result)
{
execResult.result = EnumJsonResult.success.ToString();
execResult.msg = "修改资源文件成功！";
}
else
{
execResult.result = EnumJsonResult.failure.ToString();
execResult.msg = "修改资源文件失败！";
}
}
return(execResult);
}
/// <summary>
/// 编辑资源
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateSiteResource(SiteResourceEntity model)
{
return(SiteResourceBusProvider.UpdateSiteResource(model));
}
/// <summary>
/// 新增资源
/// </summary>
/// <param name="SiteResourceEntity"></param>
/// <returns></returns>
public bool AddSiteResource(SiteResourceEntity model)
{
return(SiteResourceBusProvider.AddSiteResource(model));
}
/// <summary>
/// 累加下载次数
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AccumulationDownloadCount(SiteResourceEntity model)
{
return(SiteResourceBusProvider.AccumulationDownloadCount(model));
}
public ExecResult Save(SiteResourceEntity model)
{
ISiteResourceService service = ServiceContainer.Instance.Container.Resolve <ISiteResourceService>();
return(service.Save(model));
}
/// <summary>
/// 新增资源
/// </summary>
/// <param name="SiteResourceEntity"></param>
/// <returns></returns>
public bool AddSiteResource(SiteResourceEntity model)
{
return(SiteResourceDataAccess.Instance.AddSiteResource(model));
}
/// <summary>
/// 编辑资源
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateSiteResource(SiteResourceEntity model)
{
return(SiteResourceDataAccess.Instance.UpdateSiteResource(model));
}
/// <summary>
/// 累加下载次数
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AccumulationDownloadCount(SiteResourceEntity model)
{
return(SiteResourceDataAccess.Instance.AccumulationDownloadCount(model));
}
