/// <summary>
/// 新增更新信息
/// </summary>
/// <param name="updateInfo"></param>
/// <returns></returns>
public bool Add(Model.UpdateInfo updateInfo)
{
string sql = "INSERT INTO UpdateInfo(AppId,SchemeId,PackName,ChannelNo,VerName,VerCode,PackUrl,PackSize,PackMD5,UpdateType,UpdatePrompt,UpdateDesc,PubTime,Status,ForceUpdateVerCode) VALUES(?AppId,?SchemeId,?PackName,?ChannelNo,?VerName,?VerCode,?PackUrl,?PackSize,?PackMD5,?UpdateType,?UpdatePrompt,?UpdateDesc,?PubTime,?Status,?ForceUpdateVerCode);";
MySqlParameter[] param = new MySqlParameter[15];
int i = 0;
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?AppId", MySqlDbType.Int32, 0, updateInfo.AppId);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?SchemeId", MySqlDbType.Int32, 0, updateInfo.SchemeId);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?PackName", MySqlDbType.VarChar, 50, updateInfo.PackName);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?ChannelNo", MySqlDbType.VarChar, 20, updateInfo.ChannelNo);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?VerName", MySqlDbType.VarChar, 50, updateInfo.VerName);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?VerCode", MySqlDbType.Int32, 0, updateInfo.VerCode);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?PackUrl", MySqlDbType.VarChar, 200, updateInfo.PackUrl);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?PackSize", MySqlDbType.Int32, 0, updateInfo.PackSize);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?PackMD5", MySqlDbType.VarChar, 50, updateInfo.PackMD5);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?UpdateType", MySqlDbType.Int32, 0, updateInfo.UpdateType);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?UpdateDesc", MySqlDbType.VarChar, 500, updateInfo.UpdateDesc);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?UpdatePrompt", MySqlDbType.VarChar, 200, updateInfo.UpdatePrompt);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?PubTime", MySqlDbType.Datetime, 0, updateInfo.PubTime);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?Status", MySqlDbType.Int32, 0, updateInfo.Status);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?ForceUpdateVerCode", MySqlDbType.Int32, 0, updateInfo.ForceUpdateVerCode);
var result = _UpdaterHelper.ExecuteNonQuery(System.Data.CommandType.Text, sql, param);
return(result > 0);
}
/// <summary>
/// 修改更新信息
/// </summary>
/// <param name="updateInfo"></param>
/// <returns></returns>
public bool Update(Model.UpdateInfo updateInfo)
{
string sql = "UPDATE UpdateInfo set AppId=?AppId,SchemeId=?SchemeId,PackName=?PackName,ChannelNo=?ChannelNo,VerName=?VerName,VerCode=?VerCode,PackUrl=?PackUrl,PackSize=?PackSize,PackMD5=?PackMD5,UpdateType=?UpdateType,UpdatePrompt=?UpdatePrompt,UpdateDesc=?UpdateDesc,PubTime=?PubTime,Status=?Status,ForceUpdateVerCode=?ForceUpdateVerCode WHERE UpdateId=?UpdateId";
MySqlParameter[] param = new MySqlParameter[16];
int i = 0;
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?AppId", MySqlDbType.Int32, 0, updateInfo.AppId);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?SchemeId", MySqlDbType.Int32, 0, updateInfo.SchemeId);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?PackName", MySqlDbType.VarChar, 50, updateInfo.PackName);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?ChannelNo", MySqlDbType.VarChar, 20, updateInfo.ChannelNo);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?VerName", MySqlDbType.VarChar, 50, updateInfo.VerName);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?VerCode", MySqlDbType.Int32, 0, updateInfo.VerCode);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?PackUrl", MySqlDbType.VarChar, 200, updateInfo.PackUrl);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?PackSize", MySqlDbType.Int32, 0, updateInfo.PackSize);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?PackMD5", MySqlDbType.VarChar, 50, updateInfo.PackMD5);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?UpdateType", MySqlDbType.Int32, 0, updateInfo.UpdateType);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?UpdatePrompt", MySqlDbType.VarChar, 200, updateInfo.UpdatePrompt);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?UpdateDesc", MySqlDbType.VarChar, 500, updateInfo.UpdateDesc);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?PubTime", MySqlDbType.Datetime, 0, updateInfo.PubTime);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?Status", MySqlDbType.Int32, 0, updateInfo.Status);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?UpdateId", MySqlDbType.Int32, 0, updateInfo.UpdateId);
param[i++] = Common.DbHelper.MySqlHelper.MakeInParam("?ForceUpdateVerCode", MySqlDbType.Int32, 0, updateInfo.ForceUpdateVerCode);
var result = _UpdaterHelper.ExecuteNonQuery(System.Data.CommandType.Text, sql, param);
return(result > 0);
}
/// <summary>
/// 获取所有更新信息
/// </summary>
/// <param name="appid"></param>
/// <returns></returns>
public List <Model.UpdateInfo> GetAll(int appid, int schemeId)
{
string sql = @"SELECT UpdateId,AppId,SchemeId,PackName,ChannelNo,VerName,VerCode,PackUrl,PackSize,PackMD5,UpdateType,PubTime,Status,ForceUpdateVerCode
FROM UpdateInfo";
string condition_sql = " WHERE Status = 1 ";
List <MySqlParameter> param = new List <MySqlParameter>();
if (appid > 0)
{
condition_sql = condition_sql + " AND AppId=?AppId";
var param0 = Common.DbHelper.MySqlHelper.MakeInParam("?AppId", MySqlDbType.Int32, 0, appid);
param.Add(param0);
}
if (schemeId > -1)
{
condition_sql = condition_sql + " AND SchemeId=?SchemeId";
var param0 = Common.DbHelper.MySqlHelper.MakeInParam("?SchemeId", MySqlDbType.Int32, 0, schemeId);
param.Add(param0);
}
sql += condition_sql + " ORDER BY PubTime DESC,AppId,VerCode DESC,ChannelNo;";
MySqlParameter[] paramArray = param.Count == 0 ? null : param.ToArray();
using (var rdr = _UpdaterHelper.ExecuteReader(System.Data.CommandType.Text, sql, paramArray))
{
if (rdr != null && !rdr.IsClosed)
{
List <Model.UpdateInfo> result = new List <Model.UpdateInfo>();
while (rdr.Read())
{
Model.UpdateInfo eachItem = new Model.UpdateInfo();
int i = 0;
eachItem.UpdateId = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
eachItem.AppId = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
eachItem.SchemeId = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
eachItem.PackName = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
eachItem.ChannelNo = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
eachItem.VerName = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
eachItem.VerCode = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
eachItem.PackUrl = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
eachItem.PackSize = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
eachItem.PackMD5 = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
eachItem.UpdateType = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
eachItem.PubTime = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, new DateTime(1970, 1, 1));
eachItem.Status = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
eachItem.ForceUpdateVerCode = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
result.Add(eachItem);
}
return(result);
}
else
{
return(null);
}
}
}
/// <summary>
/// 获取最新的安装包信息
/// </summary>
/// <returns></returns>
public List <Model.UpdateInfo> GetNewList()
{
string sql = @"SELECT SchemeId,PackName,ChannelNo,VerName,VerCode,PackUrl,PackSize,PackMD5,UpdateType,UpdatePrompt,UpdateDesc,PubTime,Status,ForceUpdateVerCode
FROM UpdateInfo as a
where a.Status=1;";
using (var rdr = _UpdaterHelper.ExecuteReader(System.Data.CommandType.Text, sql, null))
{
if (rdr != null && !rdr.IsClosed)
{
List <Model.UpdateInfo> result = new List <Model.UpdateInfo>();
while (rdr.Read())
{
Model.UpdateInfo eachItem = new Model.UpdateInfo();
int i = 0;
eachItem.SchemeId = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
eachItem.PackName = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
eachItem.ChannelNo = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
eachItem.VerName = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
eachItem.VerCode = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
eachItem.PackUrl = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
eachItem.PackSize = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
eachItem.PackMD5 = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
eachItem.UpdateType = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
eachItem.UpdatePrompt = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
eachItem.UpdateDesc = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
eachItem.PubTime = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, new DateTime(1970, 1, 1));
eachItem.Status = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
eachItem.ForceUpdateVerCode = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
result.Add(eachItem);
}
return(result);
}
else
{
return(null);
}
}
return(null);
}
/// <summary>
/// 获取更新信息
/// </summary>
/// <param name="appid"></param>
/// <returns></returns>
public Model.UpdateInfo GetOne(int updateId)
{
string sql = @"SELECT UpdateId,AppId,SchemeId,PackName,ChannelNo,VerName,VerCode,PackUrl,PackSize,PackMD5,UpdateType,UpdatePrompt,UpdateDesc,PubTime,Status,ForceUpdateVerCode
FROM UpdateInfo WHERE UpdateId = ?UpdateId AND Status = 1 LIMIT 1; ";
MySqlParameter param = Common.DbHelper.MySqlHelper.MakeInParam("?UpdateId", MySqlDbType.Int32, 0, updateId);
using (var rdr = _UpdaterHelper.ExecuteReader(System.Data.CommandType.Text, sql, param))
{
if (rdr != null && !rdr.IsClosed && rdr.Read())
{
Model.UpdateInfo result = new Model.UpdateInfo();
int i = 0;
result.UpdateId = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
result.AppId = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
result.SchemeId = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
result.PackName = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
result.ChannelNo = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
result.VerName = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
result.VerCode = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
result.PackUrl = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
result.PackSize = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
result.PackMD5 = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
result.UpdateType = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
result.UpdatePrompt = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
result.UpdateDesc = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, string.Empty);
result.PubTime = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, new DateTime(1970, 1, 1));
result.Status = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
result.ForceUpdateVerCode = Common.DbHelper.MySqlHelper.GetSqlResult(rdr, i++, 0);
return(result);
}
else
{
return(null);
}
}
}
/// <summary>
/// 修改更新信息
/// </summary>
/// <param name="updateInfo"></param>
/// <returns></returns>
public bool Update(Model.UpdateInfo updateInfo)
{
return(new DAL.UpdateInfo().Update(updateInfo));
}
/// <summary>
/// 新增更新信息
/// </summary>
/// <param name="updateInfo"></param>
/// <returns></returns>
public bool Add(Model.UpdateInfo updateInfo)
{
return(new DAL.UpdateInfo().Add(updateInfo));
}
protected void Save_Click(object s, EventArgs e)
{
Model.UpdateInfo updateInfo = new Model.UpdateInfo();
updateInfo.AppId = Convert.ToInt32(ddlAppList.SelectedValue);
updateInfo.ChannelNo = txtChannelNo.Text;
updateInfo.VerName = txtVerName.Text;
updateInfo.VerCode = Convert.ToInt32(txtVerCode.Text);
updateInfo.PackMD5 = txtPackMD5.Text;
updateInfo.PackName = txtPackName.Text;
updateInfo.PackSize = Convert.ToInt32(txtPackSize.Text);
updateInfo.PackUrl = txtPackUrl.Text;
updateInfo.PubTime = DateTime.Now;
updateInfo.UpdateDesc = txtUpdateDesc.Text;
updateInfo.UpdatePrompt = txtUpdatePrompt.Text;
updateInfo.UpdateType = Convert.ToInt32(ddlUpdateType.SelectedValue);
updateInfo.Status = Convert.ToInt32(ddlStatus.SelectedValue);
updateInfo.SchemeId = nwbase_utils.Tools.GetInt(ddlSchemeId.SelectedValue, 0);
updateInfo.UpdateDesc = updateInfo.UpdateDesc.Replace("\r\n", "\n");
updateInfo.UpdatePrompt = updateInfo.UpdatePrompt.Replace("\r\n", "\n");
updateInfo.ForceUpdateVerCode = Convert.ToInt32(txtForceUpdateVerCode.Text);
bool result = false;
if (_UpdateId <= 0)
{
//新增
//appinfo.AppID = Convert.ToInt32(txtAppId.Text);
result = Add(updateInfo);
}
else
{
//修改
updateInfo.UpdateId = _UpdateId;
result = Update(updateInfo);
}
if (result)
{
string keyName = string.Format("hPackList:{0}_{1}_{2}", updateInfo.SchemeId, updateInfo.PackName, updateInfo.ChannelNo);
var client = _GetRedisClient();
client.Del(keyName);
UpdateCache();
ExecJS("DlgIfrmCloseInSubwin(\"Reload\", true);");
//string cache_key = "hApp:" + appinfo.AppID;
//Dictionary<string, string> cache_app_info = new Dictionary<string, string>();
//cache_app_info.Add("uid", "0");
//cache_app_info.Add("devid", "0");
//cache_app_info.Add("name", appinfo.AppName);
//cache_app_info.Add("packflag", appinfo.PackFlag);
//cache_app_info.Add("apptoken", appinfo.AppToken);
//cache_app_info.Add("authlevel", "0");
//cache_app_info.Add("authtime", appinfo.CreateTime.ToString());
//cache_app_info.Add("status", appinfo.Status.ToString());
//rc.SetRangeInHash(cache_key, cache_app_info);
//rc.Del("payua_Appinfo");
//
//
}
Alert("保存" + (result ? "成功" : "失败"));
}
private bool Add(Model.UpdateInfo updateInfo)
{
bool add_result = new BLL.UpdateInfo().Add(updateInfo);
return(add_result);
}
private bool Update(Model.UpdateInfo updateInfo)
{
bool update_result = new BLL.UpdateInfo().Update(updateInfo);
return(update_result);
}