public override string QueryResult()
{
DataModel dataModel = Newtonsoft.Json.JsonConvert.DeserializeObject <DataModel>(this.Data);
string responseString = "{\"NeedUpdate\":false,\"strProjectVersion\":\"\",\"strUpdateBrief\":\"未知的版本信息\",\"strPackageUrl\":\"\",\"strMainExeName\":\"\"}";
try
{
string strProjectID = dataModel.pid;
string strProjectVersion = dataModel.version;
DBUpdateVersion newVersion = new DBUpdateVersion();
if (DBUpdateVersion.GetProjectVersion(strProjectID, newVersion))
{
if (newVersion.strProjectVersion != strProjectVersion)
{
responseString = "{\"NeedUpdate\":true,\"strProjectVersion\":\"" + newVersion.strProjectVersion + "\",\"strUpdateBrief\":\"" +
newVersion.strUpdateBrief + "\",\"strPackageUrl\":\"http://" + Context.Request.Url.Authority + newVersion.strPackageUrl + "\",\"strMainExeName\":\"" + newVersion.strMainExeName + "\"}";
}
}
}
finally
{
}
return(responseString);
}
public static bool GetProjectVersion(string ProjectID, DBUpdateVersion NewVersion)
{
string strSql = "select top 1 * from VIEW_AutoUpdate_Version where strProjectID = @strProjectID order by dtCreateTime desc";
SqlParameter[] sqlParams =
{
new SqlParameter("strProjectID", ProjectID)
};
DataTable dt = SqlHelper.ExecuteDataset(SqlHelper.ConnString, CommandType.Text, strSql, sqlParams).Tables[0];
if (dt.Rows.Count > 0)
{
NewVersion.nid = int.Parse(dt.Rows[0]["nid"].ToString());
NewVersion.strProjectID = dt.Rows[0]["strProjectID"].ToString();
NewVersion.dtCreateTime = DateTime.Parse(dt.Rows[0]["dtCreateTime"].ToString());
NewVersion.strProjectVersion = dt.Rows[0]["strProjectVersion"].ToString();
NewVersion.strUpdateBrief = dt.Rows[0]["strUpdateBrief"].ToString();
NewVersion.strPackageUrl = dt.Rows[0]["strPackageUrl"].ToString();
NewVersion.strMainExeName = dt.Rows[0]["strMainExeName"].ToString();
return(true);
}
return(false);
}
