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