//public void XetRaTruong(int IDSV_SinhVien, string SoBang, int TrangThaiSinhVien)
//{
// var client = new UnimOsServiceClient();
// client.cDSV_SinhVien_XetRaTruong(GlobalVar.MaXacThuc, IDSV_SinhVien, SoBang, TrangThaiSinhVien);
// client.Close();
//}
public DataTable TimKiem(SV_SinhVienInfo pSV_SinhVienInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_SV_SinhVien_TimKiemResult>(client.cDSV_SinhVien_TimKiem(GlobalVar.MaXacThuc, pSV_SinhVienInfo)));
}
}
public frmThongKeSVTheoLop()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_LopInfo = new DM_LopInfo();
pSV_SinhVienInfo = new SV_SinhVienInfo();
oBSV_SinhVien = new cBSV_SinhVien();
oBKQHT_DanhSachNgungHoc = new cBKQHT_DanhSachNgungHoc();
//repositoryItemLookUpEditGioiTinh.DataSource = LoadGioiTinhSV();
//cboDanhSachHienThi.
_grCols = new Dictionary <int, GridColumn>()
{
{ 0, tl },
{ 1, g1 },
{ 2, g2 },
{ 3, g3 },
{ 4, g4 },
{ 5, g5 },
{ 6, g6 },
{ 7, g7 },
{ 8, g8 },
{ 9, g9 },
{ 10, g10 },
{ 11, g11 },
{ 12, g12 }
};
}
//public int Add(SV_SinhVienInfo pSV_SinhVienInfo)
//{
// int ID = 0;
// var client = new UnimOsServiceClient();
// ID = client.cDSV_SinhVien_Add(GlobalVar.MaXacThuc, pSV_SinhVienInfo);
// client.Close();
// mErrorMessage = oDSV_SinhVien.ErrorMessages;
// mErrorNumber = oDSV_SinhVien.ErrorNumber;
// return ID;
//}
//public int AddByPhanLop(int IDSV_SinhVienNhapTruong, int IDDM_Lop)
//{
// int ID = 0;
// var client = new UnimOsServiceClient();
// ID = client.cDSV_SinhVien_AddByPhanLop(GlobalVar.MaXacThuc, IDSV_SinhVienNhapTruong, IDDM_Lop);
// client.Close();
// mErrorMessage = oDSV_SinhVien.ErrorMessages;
// mErrorNumber = oDSV_SinhVien.ErrorNumber;
// return ID;
//}
//public void Update(SV_SinhVienInfo pSV_SinhVienInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDSV_SinhVien_Update(GlobalVar.MaXacThuc, pSV_SinhVienInfo);
// client.Close();
// mErrorMessage = oDSV_SinhVien.ErrorMessages;
// mErrorNumber = oDSV_SinhVien.ErrorNumber;
//}
//public int UpdateMaSinhVien(string MaSinhVien, int SV_SinhVienID)
//{
// using (var client = new UnimOsServiceClient())
// {
// return client.cDSV_SinhVien_UpdateMaSinhVien(GlobalVar.MaXacThuc, MaSinhVien, SV_SinhVienID);
// }
//}
//public void UpdateMaSinhVien(ref DataTable dtSinhVien)
//{
// if (!dtSinhVien.Columns.Contains("GhiChu"))
// dtSinhVien.Columns.Add("GhiChu", typeof(string));
// foreach (DataRow dr in dtSinhVien.Rows)
// {
// if (UpdateMaSinhVien(dr["MaSinhVien"].ToString(), int.Parse(dr["SV_SinhVienID"].ToString())) > 0)
// dr["GhiChu"] = "Mã này đã được sử dụng cho sinh viên khác";
// }
//}
//public void UpdateTaiKhoan(DataTable dtSinhVien)
//{
// foreach (DataRow dr in dtSinhVien.Rows)
// {
// var client = new UnimOsServiceClient();
// client.cDSV_SinhVien_UpdateTaiKhoan(GlobalVar.MaXacThuc, dr["TenDangNhap"].ToString(), dr["MatKhau"].ToString(), int.Parse(dr["SV_SinhVienID"].ToString()));
// client.Close();
// }
//}
//public void UpdateAnhSinhVien(byte[] Anh, int SV_SinhVienID)
//{
// var client = new UnimOsServiceClient();
// client.cDSV_SinhVien_UpdateAnhSinhVien(GlobalVar.MaXacThuc, Anh, SV_SinhVienID);
// client.Close();
//}
//public void UpdateAnhSinhVien(DataTable dtSinhVien, string ThuMucAnh)
//{
// Image img;
// byte[] Anh;
// foreach (DataRow dr in dtSinhVien.Rows)
// {
// if ("" + dr["FileAnh"] != "")
// {
// MemoryStream ms = new MemoryStream();
// img = Image.FromFile(ThuMucAnh + dr["FileAnh"].ToString());
// img.Save(ms, img.RawFormat);
// Anh = ms.GetBuffer();
// UpdateAnhSinhVien(Anh, int.Parse(dr["SV_SinhVienID"].ToString()));
// }
// }
//}
//public void ChuyenLop(int IDSV_SinhVien, int IDDM_Lop_Cu, int IDDM_Lop_Moi, int TrangThaiSinhVien_Chuyen)
//{
// var client = new UnimOsServiceClient();
// client.cDSV_SinhVien_ChuyenLop(GlobalVar.MaXacThuc, IDSV_SinhVien, IDDM_Lop_Cu, IDDM_Lop_Moi, TrangThaiSinhVien_Chuyen);
// client.Close();
//}
//public DataTable GetBangDiemLanCuoi(int IDSV_SinhVien, int IDDM_NamHoc, string TenNamHoc)
//{
// using (var client = new UnimOsServiceClient())
// {
// return ConvertList.ToDataTable<SV_SinhVienInfo>(client.cDSV_SinhVien_GetBangDiemLanCuoi(GlobalVar.MaXacThuc, IDSV_SinhVien, IDDM_NamHoc, TenNamHoc));
// }
//}
//public void Delete(SV_SinhVienInfo pSV_SinhVienInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDSV_SinhVien_Delete(GlobalVar.MaXacThuc, pSV_SinhVienInfo);
// client.Close();
// mErrorMessage = oDSV_SinhVien.ErrorMessages;
// mErrorNumber = oDSV_SinhVien.ErrorNumber;
//}
//public List<SV_SinhVienInfo> GetList(SV_SinhVienInfo pSV_SinhVienInfo)
//{
// List<SV_SinhVienInfo> oSV_SinhVienInfoList = new List<SV_SinhVienInfo>();
// DataTable dtb = Get(pSV_SinhVienInfo);
// if (dtb != null)
// {
// for (int i = 0; i < dtb.Rows.Count; i++)
// {
// oSV_SinhVienInfo = new SV_SinhVienInfo();
// oSV_SinhVienInfo.SV_SinhVienID = int.Parse(dtb.Rows[i]["SV_SinhVienID"].ToString());
// oSV_SinhVienInfo.MaSinhVien = dtb.Rows[i]["MaSinhVien"].ToString();
// oSV_SinhVienInfo.HoVaTen = dtb.Rows[i]["HoVaTen"].ToString();
// oSV_SinhVienInfo.Ten = dtb.Rows[i]["Ten"].ToString();
// oSV_SinhVienInfo.NgaySinh = DateTime.Parse(dtb.Rows[i]["NgaySinh"].ToString());
// oSV_SinhVienInfo.SoCMND = "" + dtb.Rows[i]["SoCMND"];
// oSV_SinhVienInfo.NgayCapCMND = DateTime.Parse(dtb.Rows[i]["NgayCapCMND"].ToString());
// oSV_SinhVienInfo.IDTinhNoiCapCMND = int.Parse(dtb.Rows[i]["IDTinhNoiCapCMND"].ToString());
// oSV_SinhVienInfo.Anh = (byte[])(dtb.Rows[i]["Anh"]);
// oSV_SinhVienInfo.GioiTinh = bool.Parse(dtb.Rows[i]["GioiTinh"].ToString());
// oSV_SinhVienInfo.IDDM_DanToc = int.Parse(dtb.Rows[i]["IDDM_DanToc"].ToString());
// oSV_SinhVienInfo.IDDM_TonGiao = int.Parse(dtb.Rows[i]["IDDM_TonGiao"].ToString());
// oSV_SinhVienInfo.IDDM_QuocTich = int.Parse(dtb.Rows[i]["IDDM_QuocTich"].ToString());
// oSV_SinhVienInfo.NoiSinh = dtb.Rows[i]["NoiSinh"].ToString();
// oSV_SinhVienInfo.IDDM_TinhHuyenXaNoiSinh = int.Parse(dtb.Rows[i]["IDDM_TinhHuyenXaNoiSinh"].ToString());
// oSV_SinhVienInfo.QueQuan = dtb.Rows[i]["QueQuan"].ToString();
// oSV_SinhVienInfo.IDDM_TinhHuyenXaQueQuan = int.Parse(dtb.Rows[i]["IDDM_TinhHuyenXaQueQuan"].ToString());
// oSV_SinhVienInfo.ThuongTru = dtb.Rows[i]["ThuongTru"].ToString();
// oSV_SinhVienInfo.IDDM_TinhHuyenXaThuongTru = int.Parse(dtb.Rows[i]["IDDM_TinhHuyenXaThuongTru"].ToString());
// oSV_SinhVienInfo.NgayVaoDoan = DateTime.Parse(dtb.Rows[i]["NgayVaoDoan"].ToString());
// oSV_SinhVienInfo.NgayVaoDang = DateTime.Parse(dtb.Rows[i]["NgayVaoDang"].ToString());
// oSV_SinhVienInfo.DienThoaiNhaRieng = dtb.Rows[i]["DienThoaiNhaRieng"].ToString();
// oSV_SinhVienInfo.DienThoaiDiDong = dtb.Rows[i]["DienThoaiDiDong"].ToString();
// oSV_SinhVienInfo.Email = dtb.Rows[i]["Email"].ToString();
// oSV_SinhVienInfo.Active = int.Parse(dtb.Rows[i]["Active"].ToString());
// oSV_SinhVienInfo.Xoa = bool.Parse(dtb.Rows[i]["Xoa"].ToString());
// oSV_SinhVienInfoList.Add(oSV_SinhVienInfo);
// }
// }
// return oSV_SinhVienInfoList;
//}
public void ToDataRow(SV_SinhVienInfo pSV_SinhVienInfo, ref DataRow dr)
{
dr[pSV_SinhVienInfo.strSV_SinhVienID] = pSV_SinhVienInfo.SV_SinhVienID;
dr[pSV_SinhVienInfo.strMaSinhVien] = pSV_SinhVienInfo.MaSinhVien;
dr[pSV_SinhVienInfo.strHoVaTen] = pSV_SinhVienInfo.HoVaTen;
dr[pSV_SinhVienInfo.strTen] = pSV_SinhVienInfo.Ten;
dr[pSV_SinhVienInfo.strNgaySinh] = pSV_SinhVienInfo.NgaySinh;
dr[pSV_SinhVienInfo.strSoCMND] = pSV_SinhVienInfo.SoCMND;
dr[pSV_SinhVienInfo.strNgayCapCMND] = pSV_SinhVienInfo.NgayCapCMND;
dr[pSV_SinhVienInfo.strIDTinhNoiCapCMND] = pSV_SinhVienInfo.IDTinhNoiCapCMND;
// dr[pSV_SinhVienInfo.strAnh] = pSV_SinhVienInfo.Anh;
dr[pSV_SinhVienInfo.strGioiTinh] = pSV_SinhVienInfo.GioiTinh;
dr[pSV_SinhVienInfo.strIDDM_DanToc] = pSV_SinhVienInfo.IDDM_DanToc;
dr[pSV_SinhVienInfo.strIDDM_TonGiao] = pSV_SinhVienInfo.IDDM_TonGiao;
dr[pSV_SinhVienInfo.strIDDM_QuocTich] = pSV_SinhVienInfo.IDDM_QuocTich;
dr[pSV_SinhVienInfo.strNoiSinh] = pSV_SinhVienInfo.NoiSinh;
dr[pSV_SinhVienInfo.strIDDM_TinhHuyenXaNoiSinh] = pSV_SinhVienInfo.IDDM_TinhHuyenXaNoiSinh;
dr[pSV_SinhVienInfo.strQueQuan] = pSV_SinhVienInfo.QueQuan;
dr[pSV_SinhVienInfo.strIDDM_TinhHuyenXaQueQuan] = pSV_SinhVienInfo.IDDM_TinhHuyenXaQueQuan;
dr[pSV_SinhVienInfo.strThuongTru] = pSV_SinhVienInfo.ThuongTru;
dr[pSV_SinhVienInfo.strIDDM_TinhHuyenXaThuongTru] = pSV_SinhVienInfo.IDDM_TinhHuyenXaThuongTru;
dr[pSV_SinhVienInfo.strNgayVaoDoan] = pSV_SinhVienInfo.NgayVaoDoan;
dr[pSV_SinhVienInfo.strNgayVaoDang] = pSV_SinhVienInfo.NgayVaoDang;
dr[pSV_SinhVienInfo.strDienThoaiNhaRieng] = pSV_SinhVienInfo.DienThoaiNhaRieng;
dr[pSV_SinhVienInfo.strDienThoaiDiDong] = pSV_SinhVienInfo.DienThoaiDiDong;
dr[pSV_SinhVienInfo.strEmail] = pSV_SinhVienInfo.Email;
dr[pSV_SinhVienInfo.strActive] = pSV_SinhVienInfo.Active;
dr[pSV_SinhVienInfo.strXoa] = pSV_SinhVienInfo.Xoa;
}
public void Delete(SV_SinhVienInfo pSV_SinhVienInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@SV_SinhVienID", SqlDbType.Int, pSV_SinhVienInfo.SV_SinhVienID));
RunProcedure("sp_SV_SinhVien_Delete", colParam);
}
public DataTable Get(SV_SinhVienInfo pSV_SinhVienInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@SV_SinhVienID", SqlDbType.Int, pSV_SinhVienInfo.SV_SinhVienID));
return(RunProcedureGet("sp_SV_SinhVien_Get", colParam));
}
public DataTable TimKiem(SV_SinhVienInfo pSV_SinhVienInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaSinhVien", SqlDbType.NVarChar, pSV_SinhVienInfo.MaSinhVien));
colParam.Add(CreateParam("@HoTen", SqlDbType.NVarChar, pSV_SinhVienInfo.HoVaTen));
return(RunProcedureGet("sp_SV_SinhVien_TimKiem", colParam));
}
public int Add(SV_SinhVienInfo pSV_SinhVienInfo)
{
int ID = 0;
ID = oDSV_SinhVien.Add(pSV_SinhVienInfo);
mErrorMessage = oDSV_SinhVien.ErrorMessages;
mErrorNumber = oDSV_SinhVien.ErrorNumber;
return(ID);
}
public dlgTimKiemSinhVien(DataTable mdtSinhVien, int mIDDM_Lop)
{
InitializeComponent();
pSV_SinhVienInfo = new SV_SinhVienInfo();
oBSV_SinhVien = new cBSV_SinhVien();
IDDM_Lop = mIDDM_Lop;
dtSinhVien = mdtSinhVien;
btnChon.Enabled = false;
this.Tag = "";
}
public frmDanhSachSinhVienLop()
{
InitializeComponent();
oBDM_Lop = new cBDM_Lop();
pDM_LopInfo = new DM_LopInfo();
pSV_SinhVienInfo = new SV_SinhVienInfo();
oBSV_SinhVien = new cBSV_SinhVien();
repositoryItemLookUpEditGioiTinh.DataSource = LoadGioiTinhSV();
//cboDanhSachHienThi.
}
private void dlgLocSinhVien_Load(object sender, EventArgs e)
{
LoadTreeLop(uctrlLop);
uctrlLop.trlLop.FocusedNodeChanged += new DevExpress.XtraTreeList.FocusedNodeChangedEventHandler(trlLop_FocusedNodeChanged);
if (MaSinhVien != "")
{
pSV_SinhVienInfo = new SV_SinhVienInfo();
pSV_SinhVienInfo.MaSinhVien = MaSinhVien;
pSV_SinhVienInfo.HoVaTen = "";
dtSinhVien = oBSV_SinhVien.TimKiem(pSV_SinhVienInfo);
grdSinhVien.DataSource = dtSinhVien;
}
}
public void ToInfo(ref SV_SinhVienInfo pSV_SinhVienInfo, DataRow dr, DataTable dt)
{
if (dt.Columns.Contains(pSV_SinhVienInfo.strMaSinhVien))
{
pSV_SinhVienInfo.MaSinhVien = dr[pSV_SinhVienInfo.strMaSinhVien].ToString();
}
if (dt.Columns.Contains(pSV_SinhVienInfo.strHoVaTen))
{
pSV_SinhVienInfo.HoVaTen = dr[pSV_SinhVienInfo.strHoVaTen].ToString();
pSV_SinhVienInfo.Ten = GetTen(dr[pSV_SinhVienInfo.strHoVaTen].ToString());
}
if (dt.Columns.Contains(pSV_SinhVienInfo.strNgaySinh))
{
if ("" + dr[pSV_SinhVienInfo.strNgaySinh] != "")
{
pSV_SinhVienInfo.NgaySinh = DateTime.Parse(dr[pSV_SinhVienInfo.strNgaySinh].ToString());
}
else
{
pSV_SinhVienInfo.NgaySinh = DateTime.Parse("1/1/1900");
}
}
else
{
pSV_SinhVienInfo.NgaySinh = DateTime.Parse("1/1/1900");
}
if (dt.Columns.Contains(pSV_SinhVienInfo.strGioiTinh))
{
pSV_SinhVienInfo.GioiTinh = "" + dr[pSV_SinhVienInfo.strGioiTinh] == "NAM" ? false : true;
}
if (dt.Columns.Contains(pSV_SinhVienInfo.strIDDM_DanToc))
{
pSV_SinhVienInfo.IDDM_DanToc = int.Parse("0" + dr[pSV_SinhVienInfo.strIDDM_DanToc]);
}
if (dt.Columns.Contains(pSV_SinhVienInfo.strNoiSinh))
{
pSV_SinhVienInfo.NoiSinh = dr[pSV_SinhVienInfo.strNoiSinh].ToString();
}
if (dt.Columns.Contains(pSV_SinhVienInfo.strQueQuan))
{
pSV_SinhVienInfo.QueQuan = dr[pSV_SinhVienInfo.strQueQuan].ToString();
}
if (dt.Columns.Contains(pSV_SinhVienInfo.strThuongTru))
{
pSV_SinhVienInfo.ThuongTru = dr[pSV_SinhVienInfo.strThuongTru].ToString();
}
pSV_SinhVienInfo.NgayCapCMND = DateTime.Parse("1/1/1900");
pSV_SinhVienInfo.NgayVaoDoan = DateTime.Parse("1/1/1900");
pSV_SinhVienInfo.NgayVaoDang = DateTime.Parse("1/1/1900");
pSV_SinhVienInfo.Active = 1;
}
public dlgToChucThi_ThiSinhTuDo(DataTable mdtSinhVien, DataRow mdrSinhVien, int mIDDM_Lop, EDIT_MODE mEditMode)
{
InitializeComponent();
this.Tag = "";
IDDM_Lop = mIDDM_Lop;
dtSinhVien = mdtSinhVien;
edit = mEditMode;
drSinhVien = mdrSinhVien;
pDM_LopInfo = new DM_LopInfo();
oBDM_Lop = new cBDM_Lop();
pSV_SinhVienInfo = new SV_SinhVienInfo();
oBSV_SinhVien = new cBSV_SinhVien();
pSV_SinhVien_LopInfo = new SV_SinhVien_LopInfo();
oBSV_SinhVien_Lop = new cBSV_SinhVien_Lop();
cls = new clsStringHelper();
}
public dlgBienLaiThuTienChiTiet(int _IDTC_BienLaiThuTien, bool mSua, string _MaSinhVien)
{
InitializeComponent();
oBSV_SinhVien = new cBSV_SinhVien();
pTC_BienLaiThuTienInfo = new TC_BienLaiThuTienInfo();
oBTC_BienLaiThuTien = new cBTC_BienLaiThuTien();
pTC_BienLaiThuTien_ChiTietInfo = new TC_BienLaiThuTien_ChiTietInfo();
oBTC_BienLaiThuTien_ChiTiet = new cBTC_BienLaiThuTien_ChiTiet();
oBTC_DinhMucThuSinhVien = new cBTC_DinhMucThuSinhVien();
pSV_SinhVienInfo = new SV_SinhVienInfo();
dtpNgay.EditValue = DateTime.Now;
Sua = mSua;
IDTC_BienLaiThuTien = _IDTC_BienLaiThuTien;
MaSinhVien = _MaSinhVien;
chkInKhiLuu.Checked = Properties.Settings.Default.TC_InKhiLuu;
}
public void ToInfo(ref SV_SinhVienInfo pSV_SinhVienInfo, DataRow dr)
{
pSV_SinhVienInfo.SV_SinhVienID = int.Parse(dr[pSV_SinhVienInfo.strSV_SinhVienID].ToString());
pSV_SinhVienInfo.MaSinhVien = dr[pSV_SinhVienInfo.strMaSinhVien].ToString();
pSV_SinhVienInfo.HoVaTen = dr[pSV_SinhVienInfo.strHoVaTen].ToString();
pSV_SinhVienInfo.Ten = dr[pSV_SinhVienInfo.strTen].ToString();
if (dr[pSV_SinhVienInfo.strNgaySinh].ToString() != "")
{
pSV_SinhVienInfo.NgaySinh = DateTime.Parse(dr[pSV_SinhVienInfo.strNgaySinh].ToString());
}
pSV_SinhVienInfo.SoCMND = "" + dr[pSV_SinhVienInfo.strSoCMND];
if (dr[pSV_SinhVienInfo.strNgayCapCMND].ToString() != "")
{
pSV_SinhVienInfo.NgayCapCMND = DateTime.Parse(dr[pSV_SinhVienInfo.strNgayCapCMND].ToString());
}
if ("" + dr[pSV_SinhVienInfo.strIDTinhNoiCapCMND] != "")
{
pSV_SinhVienInfo.IDTinhNoiCapCMND = int.Parse(dr[pSV_SinhVienInfo.strIDTinhNoiCapCMND].ToString());
}
// if (dr[pSV_SinhVienInfo.strAnh] != null)
// pSV_SinhVienInfo.Anh = (byte[])(dr[pSV_SinhVienInfo.strAnh]);
pSV_SinhVienInfo.GioiTinh = bool.Parse(dr[pSV_SinhVienInfo.strGioiTinh].ToString());
pSV_SinhVienInfo.IDDM_DanToc = int.Parse("0" + dr[pSV_SinhVienInfo.strIDDM_DanToc]);
pSV_SinhVienInfo.IDDM_TonGiao = int.Parse("0" + dr[pSV_SinhVienInfo.strIDDM_TonGiao]);
pSV_SinhVienInfo.IDDM_QuocTich = int.Parse("0" + dr[pSV_SinhVienInfo.strIDDM_QuocTich]);
pSV_SinhVienInfo.NoiSinh = dr[pSV_SinhVienInfo.strNoiSinh].ToString();
pSV_SinhVienInfo.IDDM_TinhHuyenXaNoiSinh = int.Parse("0" + dr[pSV_SinhVienInfo.strIDDM_TinhHuyenXaNoiSinh]);
pSV_SinhVienInfo.QueQuan = "" + dr[pSV_SinhVienInfo.strQueQuan];
pSV_SinhVienInfo.IDDM_TinhHuyenXaQueQuan = int.Parse("0" + dr[pSV_SinhVienInfo.strIDDM_TinhHuyenXaQueQuan]);
pSV_SinhVienInfo.ThuongTru = "" + dr[pSV_SinhVienInfo.strThuongTru];
pSV_SinhVienInfo.IDDM_TinhHuyenXaThuongTru = int.Parse("0" + dr[pSV_SinhVienInfo.strIDDM_TinhHuyenXaThuongTru]);
if (dr[pSV_SinhVienInfo.strNgayVaoDoan].ToString() != "")
{
pSV_SinhVienInfo.NgayVaoDoan = DateTime.Parse(dr[pSV_SinhVienInfo.strNgayVaoDoan].ToString());
}
if (dr[pSV_SinhVienInfo.strNgayVaoDang].ToString() != "")
{
pSV_SinhVienInfo.NgayVaoDang = DateTime.Parse(dr[pSV_SinhVienInfo.strNgayVaoDang].ToString());
}
pSV_SinhVienInfo.DienThoaiNhaRieng = dr[pSV_SinhVienInfo.strDienThoaiNhaRieng].ToString();
pSV_SinhVienInfo.DienThoaiDiDong = dr[pSV_SinhVienInfo.strDienThoaiDiDong].ToString();
pSV_SinhVienInfo.Email = dr[pSV_SinhVienInfo.strEmail].ToString();
pSV_SinhVienInfo.Active = int.Parse(dr[pSV_SinhVienInfo.strActive].ToString());
pSV_SinhVienInfo.Xoa = bool.Parse(dr[pSV_SinhVienInfo.strXoa].ToString());
}
public List <SV_SinhVienInfo> GetList(SV_SinhVienInfo pSV_SinhVienInfo)
{
List <SV_SinhVienInfo> oSV_SinhVienInfoList = new List <SV_SinhVienInfo>();
DataTable dtb = Get(pSV_SinhVienInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oSV_SinhVienInfo = new SV_SinhVienInfo();
oSV_SinhVienInfo.SV_SinhVienID = int.Parse(dtb.Rows[i]["SV_SinhVienID"].ToString());
oSV_SinhVienInfo.MaSinhVien = dtb.Rows[i]["MaSinhVien"].ToString();
oSV_SinhVienInfo.HoVaTen = dtb.Rows[i]["HoVaTen"].ToString();
oSV_SinhVienInfo.Ten = dtb.Rows[i]["Ten"].ToString();
oSV_SinhVienInfo.NgaySinh = DateTime.Parse(dtb.Rows[i]["NgaySinh"].ToString());
oSV_SinhVienInfo.SoCMND = "" + dtb.Rows[i]["SoCMND"];
oSV_SinhVienInfo.NgayCapCMND = DateTime.Parse(dtb.Rows[i]["NgayCapCMND"].ToString());
oSV_SinhVienInfo.IDTinhNoiCapCMND = int.Parse(dtb.Rows[i]["IDTinhNoiCapCMND"].ToString());
oSV_SinhVienInfo.Anh = (byte[])(dtb.Rows[i]["Anh"]);
oSV_SinhVienInfo.GioiTinh = bool.Parse(dtb.Rows[i]["GioiTinh"].ToString());
oSV_SinhVienInfo.IDDM_DanToc = int.Parse(dtb.Rows[i]["IDDM_DanToc"].ToString());
oSV_SinhVienInfo.IDDM_TonGiao = int.Parse(dtb.Rows[i]["IDDM_TonGiao"].ToString());
oSV_SinhVienInfo.IDDM_QuocTich = int.Parse(dtb.Rows[i]["IDDM_QuocTich"].ToString());
oSV_SinhVienInfo.NoiSinh = dtb.Rows[i]["NoiSinh"].ToString();
oSV_SinhVienInfo.IDDM_TinhHuyenXaNoiSinh = int.Parse(dtb.Rows[i]["IDDM_TinhHuyenXaNoiSinh"].ToString());
oSV_SinhVienInfo.QueQuan = dtb.Rows[i]["QueQuan"].ToString();
oSV_SinhVienInfo.IDDM_TinhHuyenXaQueQuan = int.Parse(dtb.Rows[i]["IDDM_TinhHuyenXaQueQuan"].ToString());
oSV_SinhVienInfo.ThuongTru = dtb.Rows[i]["ThuongTru"].ToString();
oSV_SinhVienInfo.IDDM_TinhHuyenXaThuongTru = int.Parse(dtb.Rows[i]["IDDM_TinhHuyenXaThuongTru"].ToString());
oSV_SinhVienInfo.NgayVaoDoan = DateTime.Parse(dtb.Rows[i]["NgayVaoDoan"].ToString());
oSV_SinhVienInfo.NgayVaoDang = DateTime.Parse(dtb.Rows[i]["NgayVaoDang"].ToString());
oSV_SinhVienInfo.DienThoaiNhaRieng = dtb.Rows[i]["DienThoaiNhaRieng"].ToString();
oSV_SinhVienInfo.DienThoaiDiDong = dtb.Rows[i]["DienThoaiDiDong"].ToString();
oSV_SinhVienInfo.Email = dtb.Rows[i]["Email"].ToString();
oSV_SinhVienInfo.Active = int.Parse(dtb.Rows[i]["Active"].ToString());
oSV_SinhVienInfo.Xoa = bool.Parse(dtb.Rows[i]["Xoa"].ToString());
oSV_SinhVienInfoList.Add(oSV_SinhVienInfo);
}
}
return(oSV_SinhVienInfoList);
}
public frmHoSoSinhVien(DataTable _dtSinhVien, ref DataRow _drSinhVien)
{
InitializeComponent();
oBSV_SinhVien = new cBSV_SinhVien();
pSV_SinhVienInfo = new SV_SinhVienInfo();
oBSV_SinhVienNhapTruong = new cBSV_SinhVienNhapTruong();
pSV_SinhVienNhapTruongInfo = new SV_SinhVienNhapTruongInfo();
oBSV_SinhVien_ThongTinKhac = new cBSV_SinhVien_ThongTinKhac();
pSV_SinhVien_ThongTinKhacInfo = new SV_SinhVien_ThongTinKhacInfo();
oBSV_SinhVien_QuanHeGiaDinh = new cBSV_SinhVien_QuanHeGiaDinh();
pSV_SinhVien_QuanHeGiaDinhInfo = new SV_SinhVien_QuanHeGiaDinhInfo();
drSinhVien = _drSinhVien;
dtSinhVien = _dtSinhVien;
LoadDiaChi(ucNoiSinh);
LoadDiaChi(ucThuongTru);
SetControl(false);
SetControlReadOnly(true);
btnLuu.Enabled = false;
}
public dlgQuyetDinh(string mSinhVienIDs, string mTrangThai, string mKQHT_DanhSachNgungHocIDs, DataRow mdr)
{
InitializeComponent();
oBSinhVien = new cBSV_SinhVien();
oBKQHT_DanhSachNgungHoc = new cBKQHT_DanhSachNgungHoc();
pKQHT_DanhSachNgungHocInfo = new KQHT_DanhSachNgungHocInfo();
pSV_SinhVienInfo = new SV_SinhVienInfo();
pKQHT_DanhSachNgungHocInfo = new KQHT_DanhSachNgungHocInfo();
oBKQHT_DanhSachHocTiep = new cBKQHT_DanhSachHocTiep();
pKQHT_DanhSachHocTiepInfo = new KQHT_DanhSachHocTiepInfo();
SinhVienIDs = mSinhVienIDs;
dtNgayQD.EditValue = DateTime.Now;
dr = mdr;
TrangThai = mTrangThai;
KQHT_DanhSachNgungHocIDs = mKQHT_DanhSachNgungHocIDs;
//load combobox
cmbTrangThai.Properties.DataSource = oBSinhVien.CreateTableTrangThai();
cmbLop.Properties.DataSource = LoadLopTheoKhoa(0);
// Sửa quyết định
if (TrangThai == "1")
{
txtSoQuyetDinh.Text = dr["SoQuyetDinh"].ToString();
txtNoiDung.Text = dr["GhiChu"].ToString();
}
else if (TrangThai == "2")
{
// xet hoc tiep
txtSoQuyetDinh.Text = dr["SoQuyetDinh"].ToString();
txtNoiDung.Text = dr["GhiChu"].ToString();
cmbLop.Enabled = true;
cmbLop.EditValue = dr["IDDM_Lop"];
}
}
public void Update(SV_SinhVienInfo pSV_SinhVienInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@MaSinhVien", SqlDbType.NVarChar, pSV_SinhVienInfo.MaSinhVien));
colParam.Add(CreateParam("@HoVaTen", SqlDbType.NVarChar, pSV_SinhVienInfo.HoVaTen));
colParam.Add(CreateParam("@Ten", SqlDbType.NVarChar, pSV_SinhVienInfo.Ten));
colParam.Add(CreateParam("@NgaySinh", SqlDbType.DateTime, pSV_SinhVienInfo.NgaySinh));
colParam.Add(CreateParam("@SoBaoDanh", SqlDbType.NVarChar, pSV_SinhVienInfo.SoBaoDanh));
colParam.Add(CreateParam("@SoCMND", SqlDbType.VarChar, pSV_SinhVienInfo.SoCMND));
colParam.Add(CreateParam("@NgayCapCMND", SqlDbType.DateTime, pSV_SinhVienInfo.NgayCapCMND));
colParam.Add(CreateParam("@IDTinhNoiCapCMND", SqlDbType.Int, pSV_SinhVienInfo.IDTinhNoiCapCMND));
colParam.Add(CreateParam("@Anh", SqlDbType.Image, pSV_SinhVienInfo.Anh));
colParam.Add(CreateParam("@GioiTinh", SqlDbType.Bit, pSV_SinhVienInfo.GioiTinh));
colParam.Add(CreateParam("@ThanhPhanXuatThan", SqlDbType.Int, pSV_SinhVienInfo.ThanhPhanXuatThan));
colParam.Add(CreateParam("@IDDM_DanToc", SqlDbType.Int, pSV_SinhVienInfo.IDDM_DanToc));
colParam.Add(CreateParam("@IDDM_TonGiao", SqlDbType.Int, pSV_SinhVienInfo.IDDM_TonGiao));
colParam.Add(CreateParam("@IDDM_QuocTich", SqlDbType.Int, pSV_SinhVienInfo.IDDM_QuocTich));
colParam.Add(CreateParam("@NoiSinh", SqlDbType.NVarChar, pSV_SinhVienInfo.NoiSinh));
colParam.Add(CreateParam("@IDDM_TinhHuyenXaNoiSinh", SqlDbType.Int, pSV_SinhVienInfo.IDDM_TinhHuyenXaNoiSinh));
colParam.Add(CreateParam("@QueQuan", SqlDbType.NVarChar, pSV_SinhVienInfo.QueQuan));
colParam.Add(CreateParam("@IDDM_TinhHuyenXaQueQuan", SqlDbType.Int, pSV_SinhVienInfo.IDDM_TinhHuyenXaQueQuan));
colParam.Add(CreateParam("@ThuongTru", SqlDbType.NVarChar, pSV_SinhVienInfo.ThuongTru));
colParam.Add(CreateParam("@IDDM_TinhHuyenXaThuongTru", SqlDbType.Int, pSV_SinhVienInfo.IDDM_TinhHuyenXaThuongTru));
colParam.Add(CreateParam("@NgayVaoDoan", SqlDbType.DateTime, pSV_SinhVienInfo.NgayVaoDoan));
colParam.Add(CreateParam("@NgayVaoDang", SqlDbType.DateTime, pSV_SinhVienInfo.NgayVaoDang));
colParam.Add(CreateParam("@DienThoaiNhaRieng", SqlDbType.VarChar, pSV_SinhVienInfo.DienThoaiNhaRieng));
colParam.Add(CreateParam("@DienThoaiDiDong", SqlDbType.VarChar, pSV_SinhVienInfo.DienThoaiDiDong));
colParam.Add(CreateParam("@BaoTinCho", SqlDbType.NVarChar, pSV_SinhVienInfo.BaoTinCho));
colParam.Add(CreateParam("@DiaChiBaoTin", SqlDbType.NVarChar, pSV_SinhVienInfo.DiaChiBaoTin));
colParam.Add(CreateParam("@Email", SqlDbType.NVarChar, pSV_SinhVienInfo.Email));
colParam.Add(CreateParam("@Active", SqlDbType.Int, pSV_SinhVienInfo.Active));
colParam.Add(CreateParam("@Xoa", SqlDbType.Bit, pSV_SinhVienInfo.Xoa));
colParam.Add(CreateParam("@SV_SinhVienID", SqlDbType.Int, pSV_SinhVienInfo.SV_SinhVienID));
RunProcedure("sp_SV_SinhVien_Update", colParam);
}
public DataTable TimKiem(SV_SinhVienInfo pSV_SinhVienInfo)
{
return(oDSV_SinhVien.TimKiem(pSV_SinhVienInfo));
}
public void Delete(SV_SinhVienInfo pSV_SinhVienInfo)
{
oDSV_SinhVien.Delete(pSV_SinhVienInfo);
mErrorMessage = oDSV_SinhVien.ErrorMessages;
mErrorNumber = oDSV_SinhVien.ErrorNumber;
}
public DataTable Get(SV_SinhVienInfo pSV_SinhVienInfo)
{
return(oDSV_SinhVien.Get(pSV_SinhVienInfo));
}
