public IList<Core.Business.PurchasingRecord> GetAllPurchasingRecord() { IList<Core.Business.PurchasingRecord> purchasingRecordlist = new List<Core.Business.PurchasingRecord>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader = sql.ExecuteSqlReader(SqlGetAllPurchasingRecord); if(reader != null) { while(reader.Read()) { Core.Business.PurchasingRecord purchasingRecord = new Core.Business.PurchasingRecord(); if (!reader.IsDBNull(0)) purchasingRecord.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) purchasingRecord.PurchasingItem = reader.GetString(1); if (!reader.IsDBNull(2)) purchasingRecord.State = reader.GetByte(2); if (!reader.IsDBNull(3)) purchasingRecord.Date = reader.GetDateTime(3); if (!reader.IsDBNull(4)) purchasingRecord.Amount = reader.GetInt32(4); if (!reader.IsDBNull(5)) purchasingRecord.Price = reader.GetDecimal(5); if (!reader.IsDBNull(6)) purchasingRecord.Unit = reader.GetString(6); if (!reader.IsDBNull(7)) purchasingRecord.PurchaserName = reader.GetString(7); if (!reader.IsDBNull(8)) purchasingRecord.TotalValue = reader.GetDecimal(8); if (!reader.IsDBNull(9)) purchasingRecord.PurchaseCate = reader.GetString(9); purchasingRecord.MarkOld(); purchasingRecordlist.Add(purchasingRecord); } reader.Close(); } return purchasingRecordlist; }
public Core.Business.PurchasingRecord Select(int id) { SqlServerUtility sql = new SqlServerUtility(); sql.AddParameter("@Id", SqlDbType.Int, id); SqlDataReader reader = sql.ExecuteSqlReader(SqlSelectPurchasingRecord); if (reader != null && !reader.IsClosed && reader.Read()) { Core.Business.PurchasingRecord purchasingRecord = new Core.Business.PurchasingRecord(); if (!reader.IsDBNull(0)) purchasingRecord.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) purchasingRecord.PurchasingItem = reader.GetString(1); if (!reader.IsDBNull(2)) purchasingRecord.State = reader.GetByte(2); if (!reader.IsDBNull(3)) purchasingRecord.Date = reader.GetDateTime(3); if (!reader.IsDBNull(4)) purchasingRecord.Amount = reader.GetInt32(4); if (!reader.IsDBNull(5)) purchasingRecord.Price = reader.GetDecimal(5); if (!reader.IsDBNull(6)) purchasingRecord.Unit = reader.GetString(6); if (!reader.IsDBNull(7)) purchasingRecord.PurchaserName = reader.GetString(7); if (!reader.IsDBNull(8)) purchasingRecord.TotalValue = reader.GetDecimal(8); if (!reader.IsDBNull(9)) purchasingRecord.PurchaseCate = reader.GetString(9); reader.Close(); return purchasingRecord; } else { if (reader != null && !reader.IsClosed) reader.Close(); return null; } }
public IList<PurchasingRecord> SelectByNameandDate(DateTime beginDate, DateTime endDate, string ItemName) { IList<Core.Business.PurchasingRecord> purchasingRecordlist = new List<Core.Business.PurchasingRecord>(); SqlServerUtility sql = new SqlServerUtility(); SqlDataReader reader; if (ItemName.Equals("")) { sql.AddParameter("@beginDate",SqlDbType.DateTime,beginDate); sql.AddParameter("@endDate",SqlDbType.DateTime,endDate); reader=sql.ExecuteSqlReader(SqlSelectByDate); } else { sql.AddParameter("@beginDate",SqlDbType.DateTime,beginDate); sql.AddParameter("@endDate",SqlDbType.DateTime,endDate); sql.AddParameter("@Name",SqlDbType.NVarChar,ItemName); reader=sql.ExecuteSqlReader(SqlSelectByDateandName); } if (reader != null) { while (reader.Read()) { Core.Business.PurchasingRecord purchasingRecord = new Core.Business.PurchasingRecord(); if (!reader.IsDBNull(0)) purchasingRecord.Id = reader.GetInt32(0); if (!reader.IsDBNull(1)) purchasingRecord.PurchasingItem = reader.GetString(1); if (!reader.IsDBNull(2)) purchasingRecord.State = reader.GetByte(2); if (!reader.IsDBNull(3)) purchasingRecord.Date = reader.GetDateTime(3); if (!reader.IsDBNull(4)) purchasingRecord.Amount = reader.GetInt32(4); if (!reader.IsDBNull(5)) purchasingRecord.Price = reader.GetDecimal(5); if (!reader.IsDBNull(6)) purchasingRecord.Unit = reader.GetString(6); if (!reader.IsDBNull(7)) purchasingRecord.PurchaserName = reader.GetString(7); if (!reader.IsDBNull(8)) purchasingRecord.TotalValue = reader.GetDecimal(8); if (!reader.IsDBNull(9)) purchasingRecord.PurchaseCate = reader.GetString(9); purchasingRecord.MarkOld(); purchasingRecordlist.Add(purchasingRecord); } reader.Close(); } return purchasingRecordlist; }