public static int Insert(SoftVersion softVersion)
{
using (var connection = new DBConnection())
using (var command = DBConnection.CreateCommand())
{
command.CommandText = InsertQuery;
if (softVersion == null)
{
MessageBox.Show("В метод Insert не передана ссылка на объект лицензионного ключа", "Ошибка",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
return(-1);
}
command.Parameters.Add(DBConnection.CreateParameter("IDSoftware", softVersion.IdSoftware));
command.Parameters.Add(DBConnection.CreateParameter("Version", softVersion.Version));
try
{
return(Convert.ToInt32(connection.SqlExecuteScalar(command), CultureInfo.InvariantCulture));
}
catch (SqlException e)
{
connection.SqlRollbackTransaction();
MessageBox.Show(string.Format(CultureInfo.InvariantCulture,
"Не удалось добавить лицензионный ключ в базу данных. Подробная ошибка: {0}", e.Message), "Ошибка",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
return(-1);
}
}
}
//根据软件id 和 平台id 获取版本
public List <SoftVersion> GetVersion(int softid, int platformid, int versiontype)
{
string sql = @"select id,Version
from Cfg_Versions
where softid=?softid and platform=?platform and hidden=0";
MySqlParameter[] parameters = new MySqlParameter[]
{
new MySqlParameter("?softid", softid),
new MySqlParameter("?platform", platformid)
};
List <SoftVersion> versions = new List <SoftVersion>();
using (IDataReader dataReader = MySqlHelper.ExecuteReader(statdbConn, sql, parameters))
{
while (dataReader.Read())
{
try
{
SoftVersion ver = new SoftVersion();
ver.VersionID = dataReader["Version"].ToString();
ver.VersionCode = dataReader["Version"].ToString();
versions.Add(ver);
}
catch
{
}
}
}
return(versions.OrderByDescending(a => a.Version).ToList());
}
public static int Update(SoftVersion softVersion)
{
using (var connection = new DBConnection())
using (var command = DBConnection.CreateCommand())
{
command.CommandText = UpdateQuery;
if (softVersion == null)
{
MessageBox.Show("В метод Update не передана ссылка на объект лицензионного ключа", "Ошибка",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
return(-1);
}
command.Parameters.Add(DBConnection.CreateParameter("IDSoftware", softVersion.IdSoftware));
command.Parameters.Add(DBConnection.CreateParameter("Version", softVersion.Version));
command.Parameters.Add(DBConnection.CreateParameter("IDVersion", softVersion.IdVersion));
try
{
return(connection.SqlExecuteNonQuery(command));
}
catch (SqlException e)
{
MessageBox.Show(string.Format(CultureInfo.InvariantCulture,
"Не удалось изменить данные о лицензионном ключе. Подробная ошибка: {0}", e.Message), "Ошибка",
MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
return(-1);
}
}
}
private static SoftVersion RowToSoftVersion(DataRow row)
{
var softVersion = new SoftVersion
{
IdVersion = ViewportHelper.ValueOrNull <int>(row, "ID Version"),
IdSoftware = ViewportHelper.ValueOrNull <int>(row, "ID Software"),
Version = ViewportHelper.ValueOrNull(row, "Version")
};
return(softVersion);
}
private List <SoftVersion> SoftVersionsFromView()
{
var list = new List <SoftVersion>();
for (var i = 0; i < _vSoftVersions.Count; i++)
{
var row = (DataRowView)_vSoftVersions[i];
var sv = new SoftVersion
{
IdVersion = ViewportHelper.ValueOrNull <int>(row, "ID Version"),
IdSoftware = ViewportHelper.ValueOrNull <int>(row, "ID Software"),
Version = ViewportHelper.ValueOrNull(row, "Version")
};
list.Add(sv);
}
return(list);
}
private List <SoftVersion> SoftVersionsFromViewport()
{
var list = new List <SoftVersion>();
for (var i = 0; i < dataGridView.Rows.Count; i++)
{
if (!dataGridView.Rows[i].IsNewRow)
{
var row = dataGridView.Rows[i];
var sv = new SoftVersion
{
IdVersion = ViewportHelper.ValueOrNull <int>(row, "idVersion"),
IdSoftware = ViewportHelper.ValueOrNull <int>(row, "idSoftware"),
Version = ViewportHelper.ValueOrNull(row, "Version")
};
list.Add(sv);
}
}
return(list);
}
public bool Equals(SoftVersion other)
{
return(Equals((object)other));
}
