public MaterialPermitItem(DbDataReader reader, MaterialPermit document) { Id = (int)reader["id"]; Document = document; Material = (string)reader["material"]; MaterialUnit = (string)reader["materialUnit"]; Quantity = (decimal)reader["quantity"]; Tonnage = (decimal)reader["tonnage"]; }
public override bool Equals(object obj) { MaterialPermit otherDocument = obj as MaterialPermit; if (otherDocument != null) { return(Id.Equals(otherDocument.Id)); } return(false); }
public MaterialPermit GetMaterialPermit(Database database) { string query = EntryControl.Resources.Doc.MaterialPermit.GetMaterialPermitId; QueryParameters parameters = new QueryParameters("autoPermit", Id); object result = database.ExecuteScalar(query, parameters); if (result == null || DBNull.Value.Equals(result)) { return(null); } return(MaterialPermit.Load(database, (int)result)); }
public static List <MaterialPermitItem> LoadList(Database database, MaterialPermit document) { List <MaterialPermitItem> itemList = new List <MaterialPermitItem>(); string query = EntryControl.Resources.Doc.MaterialPermit.LoadItemList; QueryParameters parameters = new QueryParameters("id", document.Id); using (DbDataReader reader = database.ExecuteReader(query, parameters)) { while (reader.Read()) { itemList.Add(new MaterialPermitItem(reader, document)); } reader.Close(); } return(itemList); }
/// <summary> /// возвращает объект по идентификатору /// </summary> /// <param name="database">объект БД</param> /// <param name="id">идентификатор документа</param> /// <returns>объект документа</returns> public static MaterialPermit Load(Database database, int id) { string query = EntryControl.Resources.Doc.MaterialPermit.Load; QueryParameters parameters = new QueryParameters("id", id); MaterialPermit materialPermit = null; using (DbDataReader reader = database.ExecuteReader(query, parameters)) { if (reader.Read()) { materialPermit = new MaterialPermit(reader); } reader.Close(); } if (materialPermit == null) { throw new ArgumentException(EntryControl.Resources.Message.Error.WrongIdentifier); } return(materialPermit); }