/// <summary>
/// Select Bảng
/// </summary>
/// <returns></returns>
public Entities.QuayThuNgan[] Select()
{
Sql = new Constants.Sql();
pt = new Constants.QuayThuNgan();
string sql = Sql.SelectQuayThuNgan;
Connection conn = new Connection();
SqlConnection cn = conn.openConnection();
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
//Insert Category into ArrayList
ArrayList arr = new ArrayList();
while (dr.Read())
{
Entities.QuayThuNgan phieuthu = new Entities.QuayThuNgan();
phieuthu.QuayThuNganID = Convert.ToInt32(dr[pt.QuayThuNganID].ToString());
phieuthu.TenQuayThuNgan = dr[pt.TenQuayThuNgan].ToString();
phieuthu.DiaDiem = dr[pt.DiaDiem].ToString();
phieuthu.GhiChu = dr[pt.GhiChu].ToString();
phieuthu.Deleted = (Boolean)dr[pt.Deleted];
arr.Add(phieuthu);
}
int n = arr.Count;
if (n == 0)
{
return(null);
}
Entities.QuayThuNgan[] arrC = new Entities.QuayThuNgan[n];
for (int i = 0; i < n; i++)
{
arrC[i] = (Entities.QuayThuNgan)arr[i];
}
//Giai phong bo nho
arr = null;
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
cn = null;
conn = null;
return(arrC);
}
/// <summary>
/// Select Bảng
/// </summary>
/// <returns></returns>
public Entities.QuayThuNgan[] Select()
{
Sql = new Constants.Sql();
pt = new Constants.QuayThuNgan();
string sql = Sql.SelectQuayThuNgan;
Connection conn = new Connection();
SqlConnection cn = conn.openConnection();
SqlCommand cmd = new SqlCommand(sql, cn);
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
//Insert Category into ArrayList
ArrayList arr = new ArrayList();
while (dr.Read())
{
Entities.QuayThuNgan phieuthu = new Entities.QuayThuNgan();
phieuthu.QuayThuNganID = Convert.ToInt32(dr[pt.QuayThuNganID].ToString());
phieuthu.TenQuayThuNgan = dr[pt.TenQuayThuNgan].ToString();
phieuthu.DiaDiem =dr[pt.DiaDiem].ToString();
phieuthu.GhiChu = dr[pt.GhiChu].ToString();
phieuthu.Deleted = (Boolean)dr[pt.Deleted];
arr.Add(phieuthu);
}
int n = arr.Count;
if (n == 0) return null;
Entities.QuayThuNgan[] arrC = new Entities.QuayThuNgan[n];
for (int i = 0; i < n; i++)
{
arrC[i] = (Entities.QuayThuNgan)arr[i];
}
//Giai phong bo nho
arr = null;
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
cn = null;
conn = null;
return arrC;
}