/// <summary>
/// Выбрать строку из справочника по коду груза
/// </summary>
/// <param name="CargoCode">Код груза</param>
/// <returns></returns>
public CargoGuide GetCargoByCode(string Cargo_ID)
{
using (SqlConnection sqlConn = new SqlConnection(connectionString))
{
using (SqlCommand sqlCmd = sqlConn.CreateCommand())
{
sqlCmd.CommandText = "SELECT * FROM Cargo where Cargo.Cargo_ID = @Cargo_ID";
sqlCmd.Parameters.AddWithValue("@Cargo_ID", Int32.Parse(Cargo_ID));
CargoGuide cargo = new CargoGuide();
sqlConn.Open();
using (SqlDataReader sqlDR = sqlCmd.ExecuteReader())
{
while (sqlDR.Read())
cargo = GetCargoGuideInfo(sqlDR);
if (sqlDR != null)
sqlDR.Close();
sqlConn.Close();
}
return cargo;
}
}
}
public CargoGuide GetCargoGuideInfo(SqlDataReader sqlDR)
{
CargoGuide row = new CargoGuide();
row.Cargo_ID = DBNullToString(sqlDR["Cargo_ID"]);
row.Name = DBNullToString(sqlDR["Name"]);
row.Description = DBNullToString(sqlDR["Description"]);
row.ShortCode = DBNullToString(sqlDR["ShortCode"]);
row.Code = DBNullToString(sqlDR["Code"]);
row.CodeGNG = DBNullToString(sqlDR["CodeGNG"]);
row.Mnemocode = DBNullToString(sqlDR["Mnemocode"]);
row.IsUsed = DBNullToString(sqlDR["IsUsed"]);
row.IsEmpty = DBNullToString(sqlDR["IsEmpty"]);
return row;
}