/// <summary>
/// khoi tao gia tri
/// </summary>
public BCChiTietHangHoa()
{
kh = null;
Sql = null;
conn = null;
cmd = null;
arr = null;
dr = null;
khachhang = null;
cn = null;
}
/// <summary>
/// Select Bảng
/// </summary>
/// <returns></returns>
public rptBCChiTietHangHoa[] Select()
{
rptBCChiTietHangHoa[] arrC = null;
try
{
kh = new Constants.BCChiTietHangHoa();
Sql = new Constants.Sql();
string sql = Sql.SelectChiTietHangHoa;
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
arr = new ArrayList();
while (dr.Read())
{
rptBCChiTietHangHoa rptBcChiTietHangHoa = new rptBCChiTietHangHoa
{
MaHangHoa = dr[kh.MaHangHoa].ToString(),
TenNhomHang = dr[kh.TenNhomHang].ToString(),
TenHangHoa = dr[kh.TenHangHoa].ToString(),
TenDonViTinh = dr[kh.TenDonViTinh].ToString(),
GiaNhap = double.Parse(dr[kh.GiaNhap].ToString()),
GiaBanBuon = double.Parse(dr[kh.GiaBanBuon].ToString()),
GiaBanLe = double.Parse(dr[kh.GiaBanLe].ToString()),
MucDatHang = Convert.ToInt32(dr[kh.MucDatHang].ToString()),
MucTonToiThieu = Convert.ToInt32(dr[kh.MucTonToiThieu].ToString())
};
arr.Add(rptBcChiTietHangHoa);
}
int n = arr.Count;
if (n == 0) { return null; }
arrC = new rptBCChiTietHangHoa[n];
for (int i = 0; i < n; i++)
{
arrC[i] = (rptBCChiTietHangHoa)arr[i];
}
}
catch (Exception)
{
}
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return arrC;
}