/// <summary>
/// 通過頁面編輯上架版本
/// </summary>
/// <returns></returns>
public HttpResponseBase EditAppversionsInfo()
{
string json = string.Empty;
try
{
_iappversionsMgr = new AppversionsMgr(mySqlConnectionString);
//獲得頁面SaveReport方法提交的參數
AppversionsQuery asq = new AppversionsQuery();
if (!string.IsNullOrEmpty(Request.Params["txtid"]))
{
asq.id = Convert.ToInt32(Request.Params["txtid"].ToString());
}
asq.drive = Convert.ToInt32(Request.Params["cmbdriverEdit"].ToString());
asq.versions_code = Convert.ToInt32(Request.Params["txtversions_code"].ToString());
asq.versions_desc = Request.Params["txtversions_desc"].ToString();
asq.versions_id = Convert.ToInt32(Request.Params["txtversions_id"].ToString());
asq.versions_name = Request.Params["txtversions_name"].ToString();
asq.release_type = Convert.ToInt32(Request.Params["status_type"]);
string releasedateQuerytime = Request.Params["daterelease_date"].ToString();
if (!string.IsNullOrEmpty(releasedateQuerytime))
{
asq.release_date = Convert.ToInt32(CommonFunction.GetPHPTime(releasedateQuerytime));
}
//調用編輯事件
json = _iappversionsMgr.EditAppversionsInfo(asq);
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false}";
}
return BackAjaxData(json);
}
public int EditAppversions(AppversionsQuery appsions)
{
StringBuilder str = new StringBuilder();
try
{
appsions.Replace4MySQL();
str.AppendFormat(@"update appversions set versions_id='{0}',versions_code='{1}',versions_name='{2}', versions_desc='{3}',drive='{4}',release_date='{5}',release_type='{6}' where id='{7}';"
,appsions.versions_id,appsions.versions_code,appsions.versions_name,appsions.versions_desc,appsions.drive,appsions.release_date,appsions.release_type,appsions.id);
return _access.execCommand(str.ToString());
}
catch (Exception ex)
{
throw new Exception("AppversionsDao-->EditAppversions" + ex.Message + str.ToString(), ex);
}
}
/// <summary>
/// 通過條件得到上架版本列表
/// </summary>
/// <returns></returns>
public HttpResponseBase GetAppversionsInfo()
{
string json = string.Empty;
AppversionsQuery asq = new AppversionsQuery();
try
{
_iappversionsMgr = new AppversionsMgr(mySqlConnectionString);
asq.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
asq.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
string cmbdriver = Request.Params["cmbdriver"].ToString();
if (!string.IsNullOrEmpty(cmbdriver))
{
asq.drive = Convert.ToInt32(cmbdriver);
}
//調用查詢事件
json = _iappversionsMgr.GetAppversionsList(asq);
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "";
}
return BackAjaxData(json);
}