/// <summary>
/// 添加版本信息
/// </summary>
/// <param name="version"></param>
/// <returns></returns>
private static int AddSoftVersionInternal(Sjqd_SoftVersions version)
{
string cmdText = string.Format(@"
insert into Cfg_Versions(`SoftID`,`Platform`,`Version`,`Hidden`)
select {0},{1},'{2}',{3} from dual where not exists(
select * from Cfg_Versions where SoftID={0} and Platform={1} and version='{2}');
select last_insert_id();"
, version.SoftID
, version.Platform
, version.Version
, version.Hidden ? 1 : 0);
object result = MySqlHelper.ExecuteScalar(StatDB_MySQL_ConnString, cmdText);
int verId = Convert.ToInt32(result);
if (verId > 0)
{
//添加日志
new URLoginService().AddLog("AddSoftVersion"
, string.Format("添加版本(SoftID={0},Platform={1},Version={2})"
, version.SoftID, version.Platform, version.Version));
return(1);
}
return(0);
}
protected void OnSave(object sender, DirectEventArgs e)
{
int softid = Convert.ToInt32(add_comboxSofts.SelectedItem.Value);
int platform = Convert.ToInt32(add_comboxPlats.SelectedItem.Value);
string version = add_txtVersion.Value.ToString();
bool isHidden = add_HiddenCheckbox.Checked;
Sjqd_SoftVersions newVersion = new Sjqd_SoftVersions
{
SoftID = softid,
Platform = platform,
Version = version,
Hidden = isHidden
};
int versionId = Sjqd_SoftVersionsService.AddSoftVersion(newVersion);
if (versionId > 0)
{
e.ExtraParamsResponse.Add(new Ext.Net.Parameter("success", "1", false));
//添加成功后在下方显示
X.Msg.Alert("消息", "添加成功").Show();
}
else
{
e.ExtraParamsResponse.Add(new Ext.Net.Parameter("success", "0", false));
X.Msg.Alert("消息", "添加失败").Show();
}
}
/// <summary>
/// 更新版本信息
/// </summary>
/// <param name="SoftVersion"></param>
/// <returns></returns>
public static int UpdateSoftVersion(Sjqd_SoftVersions version)
{
Sjqd_SoftVersions version2 = GetSoftVersion(version.ID);
if (version2 == null)
{
return(0);
}
version2.Hidden = version.Hidden;
version2.IsStatisticsVersion = version.IsStatisticsVersion;
List <int> softIds = new List <int>();
//特殊逻辑，91助手海外自动增加
if (version2.SoftID == 46 || version2.SoftID == 90003 || version2.SoftID == 10101576)
{
softIds.Add(46);
softIds.Add(90003);
softIds.Add(10101576);
}
else
{
softIds.Add(version2.SoftID);
}
int rowCount = 0;
foreach (int softId in softIds)
{
version2.SoftID = softId;
rowCount += UpdateSoftVersionInternal(version2);
int platform = version2.Platform;
switch (version2.Platform)
{
case 1:
version2.Platform = 7;
break;
default:
continue;
}
rowCount += UpdateSoftVersionInternal(version2);
version2.Platform = platform;
}
return(rowCount);
}
/// <summary>
/// 删除版本信息
/// </summary>
/// <param name="versionId"></param>
/// <returns></returns>
private static int DeleteSoftVersionInternal(Sjqd_SoftVersions version)
{
string cmdText =
string.Format(@"delete from Cfg_Versions where SoftID={0} and Platform={1} and Version='{2}'"
, version.SoftID
, version.Platform
, version.Version);
if (MySqlHelper.ExecuteNonQuery(StatDB_MySQL_ConnString, cmdText) > 0)
{
//添加日志
new URLoginService().AddLog("DeleteSoftVersion"
, string.Format("删除版本(SoftID={0},Platform={1},Version={2})"
, version.SoftID, version.Platform, version.Version));
return(1);
}
return(0);
}
/// <summary>
/// 添加版本信息
/// </summary>
/// <param name="version"></param>
/// <returns></returns>
public static int AddSoftVersion(Sjqd_SoftVersions version)
{
if (!versionRegex.IsMatch(version.Version))
{
return(0);
}
List <int> softIds = new List <int>();
//特殊逻辑，91助手海外自动增加
if (version.SoftID == 46 || version.SoftID == 90003 || version.SoftID == 10101576)
{
softIds.Add(46);
softIds.Add(90003);
softIds.Add(10101576);
}
else
{
softIds.Add(version.SoftID);
}
int rowCount = 0;
foreach (int softId in softIds)
{
version.SoftID = softId;
rowCount += AddSoftVersionInternal(version);
int platform = version.Platform;
switch (version.Platform)
{
case 1:
version.Platform = 7;
break;
default:
continue;
}
rowCount += AddSoftVersionInternal(version);
version.Platform = platform;
}
return(rowCount);
}
/// <summary>
/// 更新版本信息
/// </summary>
/// <param name="SoftVersion"></param>
/// <returns></returns>
private static int UpdateSoftVersionInternal(Sjqd_SoftVersions version)
{
string cmdText =
string.Format(
@"update Cfg_Versions set Hidden={0} where SoftID={1} and Platform={2} and Version='{3}'"
, version.Hidden ? 1 : 0
, version.SoftID
, version.Platform
, version.Version);
if (MySqlHelper.ExecuteNonQuery(StatDB_MySQL_ConnString, cmdText) > 0)
{
//添加日志
new URLoginService().AddLog("UpdateSoftVersion"
, string.Format("修改版本(SoftID={0},Platform={1},Version={2})"
, version.SoftID, version.Platform, version.Version));
return(1);
}
return(0);
}
