protected List <DIC_PHONGBAN> DataReaderToList(SqlDataReader dataReader)
{
try
{
List <DIC_PHONGBAN> dsphongban = new List <DIC_PHONGBAN>();
while (dataReader.Read())
{
DIC_PHONGBAN phongban = new DIC_PHONGBAN();
phongban.MaPhongBan = DataConverter.StringToInt(dataReader["MaPhongBan"].ToString());
phongban.TenPhongBan = dataReader["TenPhongBan"].ToString();
phongban.NhomPhongBan = DataConverter.ToInt(dataReader["NhomPhongBan"].ToString());
phongban.ChuyenKhoa = dataReader["ChuyenKhoa"].ToString();
phongban.QuanLy = DataConverter.ToInt(dataReader["QuanLy"].ToString());
phongban.BuongGiuong = dataReader["BuongGiuong"].ToString();
phongban.PhanLoai = dataReader["PhanLoai"].ToString();
phongban.MaQuyetDinh = dataReader["MaQuyetDinh"].ToString();
phongban.MaPhongBanCu = dataReader["MaPhongBanCu"].ToString();
phongban.MaChuyenKhoa = DataConverter.StringToInt(dataReader["MaChuyenKhoa"].ToString());
phongban.TuTruc = Convert.ToBoolean(dataReader["TuTruc"].ToString());
phongban.TrongBenhVien = DataConverter.StringToInt(dataReader["TrongBenhVien"].ToString());
phongban.PhuongPhapXuatDuoc = DataConverter.StringToInt(dataReader["PhuongPhapXuatDuoc"].ToString());
phongban.PhuongPhapHuHaoDongY = Convert.ToByte(dataReader["PhuongPhapHuHaoDongY"].ToString());
phongban.DiaChi = dataReader["DiaChi"].ToString();
phongban.MaBenhVien = dataReader["MaBenhVien"].ToString();
phongban.Status = DataConverter.StringToInt(dataReader["Status"].ToString());
dsphongban.Add(phongban);
}
return(dsphongban);
}
catch (Exception e)
{
log.Error("Generate PHONG BAN", e);
return(null);
}
}
public SqlResultType Delete(DIC_PHONGBAN phongban)
{
try
{
this.sqlHelper.CommandType = CommandType.StoredProcedure;
object result = this.sqlHelper.ExecuteScalar("DeletePhongBan", new string[] { "@MaPhongBan" }, new object[] { phongban.MaPhongBan });
int kq = Convert.ToInt32(result);
return(this.GetResult(kq));
}
catch (Exception e)
{
log.Error("Delete PHONG BAN", e);
return(SqlResultType.Exception);
}
}
public SqlResultType Insert(DIC_PHONGBAN phongban)
{
try
{
this.sqlHelper.CommandType = CommandType.StoredProcedure;
object result = this.sqlHelper.ExecuteScalar("InsertPhongBan",
new string[] { "@TenPhongBan", "@NhomPhongBan", "@ChuyenKhoa", "@QuanLy", "@BuongGiuong", "@PhanLoai", "@MaQuyetDinh", "@MaPhongBanCu", "@MaChuyenKhoa", "@TuTruc", "@TrongBenhVien", "@PhuongPhapXuatDuoc", "@PhuongPhapHuHaoDongY", "@DiaChi", "@@MaBenhVien", "@Status" },
new object[] { phongban.TenPhongBan, phongban.NhomPhongBan, phongban.ChuyenKhoa, phongban.QuanLy, phongban.BuongGiuong, phongban.PhanLoai, phongban.MaQuyetDinh, phongban.MaPhongBanCu, phongban.MaChuyenKhoa, phongban.TuTruc, phongban.TrongBenhVien, phongban.PhuongPhapXuatDuoc, phongban.PhuongPhapHuHaoDongY, phongban.DiaChi, phongban.MaBenhVien, phongban.Status });
int kq = Convert.ToInt32(result);
return(this.GetResult(kq));
}
catch (Exception e)
{
log.Error("Insert PHONG BAN", e);
return(SqlResultType.Exception);
}
}
