/// <summary>
/// app版本管理
/// </summary>
/// <param name="para">CBApVersion</param>
/// <param name="currPageIndex">当前页索引</param>
/// <param name="pageSize">每页显示条数</param>
/// <returns>Dictionary-CBApVersion</returns>
/// <remarks>2013-9-4 黄伟 创建</remarks>
public override Dictionary <int, IList <CBApVersion> > QueryAppVersion(CBApVersion para, int currPageIndex = 1,
int pageSize = 10)
{
string sqlSelect = @"a.*",
sqlFrom = @"ApVersion a",
sqlCondition = @"(:versionnumber is null or a.versionnumber=:versionnumber)";
using (var context = Context.UseSharedConnection(true))
{
var lstResult = context.Select <CBApVersion>(sqlSelect)
.From(sqlFrom).
AndWhere(sqlCondition)
.Parameter("versionnumber", para.VersionNumber)
.Paging(currPageIndex, pageSize) //index从1开始
.OrderBy("a.sysno desc")
.QueryMany();
var count = context.Select <int>(@"count(*)")
.From(sqlFrom).
AndWhere(sqlCondition)
.Parameter("versionnumber", para.VersionNumber)
.QuerySingle();
return(new Dictionary <int, IList <CBApVersion> > {
{ count, lstResult }
});
}
}
/// <summary>
/// 新增版本
/// </summary>
/// <param name="model">CBApVersion</param>
/// <param name="operatorSysNo">操作人员编号</param>
/// <returns>Result instance</returns>
/// <remarks>2013-9-10 黄伟 创建</remarks>
public override int CreateVersion(CBApVersion model, int operatorSysNo)
{
model.CreatedBy = operatorSysNo;
model.CreatedDate = DateTime.Now;
if (model.LastUpdateDate == DateTime.MinValue)
{
model.LastUpdateDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
}
return(Context.Insert("ApVersion", model).AutoMap(m => m.SysNo).ExecuteReturnLastId <int>("SysNo"));
}
public ActionResult CreateOrUpdateVersion(int?sysNo)
{
var model = new CBApVersion();
if (sysNo != null && sysNo > 0)
{
model = AppContentBo.Instance.GetAppVersion(sysNo ?? 0);
return(View(model));
}
return(View(model));
}
/// <summary>
/// 更新版本
/// </summary>
/// <param name="model">CBApVersion</param>
/// <param name="operatorSysNo">操作人员编号</param>
/// <returns>the rows affected</returns>
/// <remarks>2013-9-10 黄伟 创建</remarks>
public override int UpdateVersion(CBApVersion model, int operatorSysNo)
{
model.LastUpdateBy = operatorSysNo;
model.LastUpdateDate = DateTime.Now;
return(Context.Update("ApVersion", model)
.Column(m => m.AppCode)
.Column(m => m.VersionNumber)
.Column(m => m.VersionLink)
.Column(m => m.UpgradeInfo)
.Column(m => m.Description)
.Column(m => m.LastUpdateBy)
.Column(m => m.LastUpdateDate)
.Where(m => m.SysNo).Execute());
}
public ActionResult VersionManagement(int?id, CBApVersion para)
{
var dic = AppContentBo.Instance.QueryAppVersion(para, id ?? 1);
var model = new PagedList <CBApVersion>
{
TData = dic.Any() ? dic.First().Value : null,
CurrentPageIndex = id ?? 1,
TotalItemCount = dic.Any() ? dic.First().Key : 0
};
if (Request.IsAjaxRequest())
{
return(PartialView("pAjaxPager_AppVersion", model));
}
return(View(model));
}
/// <summary>
/// 更新版本
/// </summary>
/// <param name="model">CBApVersion</param>
/// <param name="userIp">访问者ip</param>
/// <param name="operatorSysno">操作人员编号</param>
/// <returns></returns>
/// <remarks>2013-9-10 黄伟 创建</remarks>
public Result UpdateVersion(CBApVersion model, string userIp, int operatorSysno)
{
try
{
var sysNo = IAppContentDao.Instance.UpdateVersion(model, operatorSysno);
SysLog.Instance.WriteLog(LogStatus.SysLogLevel.Info, LogStatus.系统日志来源.后台, "更新App版本",
LogStatus.系统日志目标类型.App版本, sysNo, null, userIp, operatorSysno);
}
catch (Exception ex)
{
SysLog.Instance.WriteLog(LogStatus.SysLogLevel.Error, LogStatus.系统日志来源.后台, "更新App版本",
LogStatus.系统日志目标类型.App版本, 0, ex, userIp, operatorSysno);
return(new Result {
Status = false, Message = string.Format("更新失败:{0}", ex.Message)
});
}
return(new Result {
Status = true, Message = "更新成功!"
});
}
/// <summary>
/// app版本管理
/// </summary>
/// <param name="para">CBApVersion</param>
/// <param name="currPageIndex">当前页索引</param>
/// <param name="pageSize">每页显示条数</param>
/// <returns>Pager-CBCrBrowseHistory分页对象</returns>
/// <remarks>2013-9-4 黄伟 创建</remarks>
public Dictionary <int, IList <CBApVersion> > QueryAppVersion(CBApVersion para, int currPageIndex = 1, int pageSize = 10)
{
return(IAppContentDao.Instance.QueryAppVersion(para, currPageIndex, pageSize));
}
/// <summary> /// 更新版本 /// </summary> /// <param name="operatorSysNo">操作人员编号</param> /// <param name="model">CBApVersion</param> /// <returns></returns> /// <remarks>2013-9-10 黄伟 创建</remarks> public abstract int UpdateVersion(CBApVersion model, int operatorSysNo);
/// <summary> /// app版本管理 /// </summary> /// <param name="para">CBApVersion</param> /// <param name="currPageIndex">当前页索引</param> /// <param name="pageSize">每页显示条数</param> /// <returns>Dictionary-CBApVersion</returns> /// <remarks>2013-9-9 黄伟 创建</remarks> public abstract Dictionary <int, IList <CBApVersion> > QueryAppVersion(CBApVersion para, int currPageIndex = 1, int pageSize = 10);
public ActionResult UpdateVersion(CBApVersion model)
{
var result = AppContentBo.Instance.UpdateVersion(model, HttpContext.Request.ServerVariables["Remote_Add"], CurrentUser.Base.SysNo);
return(Json(result, JsonRequestBehavior.AllowGet));
}
