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)); }