public frmNamHoc()
{
InitializeComponent();
oBNamHoc = new cBDM_NamHoc();
pNamHocInfo = new DM_NamHocInfo();
lstNamHoc = new List <DM_NamHocInfo>();
}
public int GetKy2(DM_NamHocInfo pNamHocInfo)
{
using (var client = new UnimOsServiceClient())
{
return(client.cDDM_NamHoc_GetKy2(GlobalVar.MaXacThuc, pNamHocInfo));
}
}
public frmChonNamHoc()
{
InitializeComponent();
oBNamHoc = new cBDM_NamHoc();
pNamHocInfo = new DM_NamHocInfo();
DataTable dtNamHoc = new DataTable();
dtNamHoc = oBNamHoc.Get(pNamHocInfo);
cmbNamHoc.Properties.ValueMember = "DM_NamHocID";
cmbNamHoc.Properties.DisplayMember = "TenNamHoc";
cmbNamHoc.Properties.DataSource = dtNamHoc;
if (dtNamHoc != null)
{
cmbNamHoc.EditValue = dtNamHoc.Rows[0]["DM_NamHocID"];
}
DataTable dt = new DataTable();
dt.Columns.Add("HocKy", typeof(int));
DataRow dr = dt.NewRow();
dr["HocKy"] = 1;
dt.Rows.Add(dr);
dr = dt.NewRow();
dr["HocKy"] = 2;
dt.Rows.Add(dr);
cmbHocKy.Properties.ValueMember = "HocKy";
cmbHocKy.Properties.DisplayMember = "HocKy";
cmbHocKy.Properties.DataSource = dt;
cmbHocKy.EditValue = dt.Rows[0]["HocKy"];
}
public DataTable Get(DM_NamHocInfo pDM_NamHocInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_DM_NamHoc_GetResult>(client.cDDM_NamHoc_Get(GlobalVar.MaXacThuc, pDM_NamHocInfo)));
}
}
public void Delete(DM_NamHocInfo pDM_NamHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_NamHocID", SqlDbType.Int, pDM_NamHocInfo.DM_NamHocID));
RunProcedure("sp_DM_NamHoc_Delete", colParam);
}
public DataTable Get(DM_NamHocInfo pDM_NamHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@DM_NamHocID", SqlDbType.Int, pDM_NamHocInfo.DM_NamHocID));
return(RunProcedureGet("sp_DM_NamHoc_Get", colParam));
}
public frmBienLaiThuTien()
{
InitializeComponent();
pTC_BienLaiThuTienInfo = new TC_BienLaiThuTienInfo();
oBTC_BienLaiThuTien = new cBTC_BienLaiThuTien();
oBNamHoc = new cBDM_NamHoc();
pNamHocInfo = new DM_NamHocInfo();
oBDM_Lop = new cBDM_Lop();
}
public int Add(DM_NamHocInfo pDM_NamHocInfo)
{
int ID = 0;
ID = oDDM_NamHoc.Add(pDM_NamHocInfo);
mErrorMessage = oDDM_NamHoc.ErrorMessages;
mErrorNumber = oDDM_NamHoc.ErrorNumber;
return(ID);
}
public void Update(DM_NamHocInfo pDM_NamHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenNamHoc", SqlDbType.NVarChar, pDM_NamHocInfo.TenNamHoc));
colParam.Add(CreateParam("@TuNgay", SqlDbType.DateTime, pDM_NamHocInfo.TuNgay));
colParam.Add(CreateParam("@DenNgay", SqlDbType.DateTime, pDM_NamHocInfo.DenNgay));
colParam.Add(CreateParam("@DM_NamHocID", SqlDbType.Int, pDM_NamHocInfo.DM_NamHocID));
RunProcedure("sp_DM_NamHoc_Update", colParam);
}
public int Add(DM_NamHocInfo pDM_NamHocInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@TenNamHoc", SqlDbType.NVarChar, pDM_NamHocInfo.TenNamHoc));
colParam.Add(CreateParam("@TuNgay", SqlDbType.DateTime, pDM_NamHocInfo.TuNgay));
colParam.Add(CreateParam("@DenNgay", SqlDbType.DateTime, pDM_NamHocInfo.DenNgay));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_DM_NamHoc_Add", colParam));
}
public frmBienLaiThuTien_Tree()
{
InitializeComponent();
oBTC_BienLaiThuTien = new cBTC_BienLaiThuTien();
pTC_BienLaiThuTienInfo = new TC_BienLaiThuTienInfo();
oBTC_BienLaiThuTien_ChiTiet = new cBTC_BienLaiThuTien_ChiTiet();
oBSV_SinhVien_Lop = new cBSV_SinhVien_Lop();
oBTC_DinhMuc = new cBTC_DinhMucThuSinhVien();
clsStrHelper = new Lib.clsStringHelper();
oBNamHoc = new cBDM_NamHoc();
pNamHocInfo = new DM_NamHocInfo();
oBDM_Lop = new cBDM_Lop();
}
private void grvNamHoc_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
try
{
SetControl(true);
pNamHocInfo = (DM_NamHocInfo)grvNamHoc.GetRow(grvNamHoc.FocusedRowHandle);
IndexList = lstNamHoc.IndexOf(pNamHocInfo);
}
catch (Exception ex)
{
XtraMessageBox.Show(ex.Message);
}
}
public int GetKy2(DM_NamHocInfo pNamHocInfo)
{
DataTable dt;
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NamHocID", SqlDbType.Int, pNamHocInfo.DM_NamHocID));
dt = RunProcedureGet("sp_DM_NamHoc_GetKy2", colParam);
if (dt.Rows.Count > 0)
{
return((int)dt.Rows[0]["TuanThu"]);
}
else
{
return(0);
}
}
//public int Add(DM_NamHocInfo pDM_NamHocInfo)
//{
// int ID = 0;
// var client = new UnimOsServiceClient();
// ID = client.cDDM_NamHoc_Add(GlobalVar.MaXacThuc, pDM_NamHocInfo);
// client.Close();
// mErrorMessage = oDDM_NamHoc.ErrorMessages;
// mErrorNumber = oDDM_NamHoc.ErrorNumber;
// return ID;
//}
//public void Update(DM_NamHocInfo pDM_NamHocInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDDM_NamHoc_Update(GlobalVar.MaXacThuc, pDM_NamHocInfo);
// client.Close();
// mErrorMessage = oDDM_NamHoc.ErrorMessages;
// mErrorNumber = oDDM_NamHoc.ErrorNumber;
//}
//public void Delete(DM_NamHocInfo pDM_NamHocInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDDM_NamHoc_Delete(GlobalVar.MaXacThuc, pDM_NamHocInfo);
// client.Close();
// mErrorMessage = oDDM_NamHoc.ErrorMessages;
// mErrorNumber = oDDM_NamHoc.ErrorNumber;
//}
public List <DM_NamHocInfo> GetList(DM_NamHocInfo pDM_NamHocInfo)
{
List <DM_NamHocInfo> oDM_NamHocInfoList = new List <DM_NamHocInfo>();
pDM_NamHocInfo.DM_NamHocID = 0;
DataTable dtb = Get(pDM_NamHocInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oDM_NamHocInfo = new DM_NamHocInfo();
oDM_NamHocInfo.DM_NamHocID = int.Parse(dtb.Rows[i]["DM_NamHocID"].ToString());
oDM_NamHocInfo.TenNamHoc = dtb.Rows[i]["TenNamHoc"].ToString();
oDM_NamHocInfo.TuNgay = DateTime.Parse(dtb.Rows[i]["TuNgay"].ToString());
oDM_NamHocInfo.DenNgay = DateTime.Parse(dtb.Rows[i]["DenNgay"].ToString());
oDM_NamHocInfoList.Add(oDM_NamHocInfo);
}
}
return(oDM_NamHocInfoList);
}
public DataTable Get(DM_NamHocInfo pDM_NamHocInfo)
{
return(oDDM_NamHoc.Get(pDM_NamHocInfo));
}
public int GetKy2(DM_NamHocInfo pNamHocInfo)
{
return(oDDM_NamHoc.GetKy2(pNamHocInfo));
}
public void Delete(DM_NamHocInfo pDM_NamHocInfo)
{
oDDM_NamHoc.Delete(pDM_NamHocInfo);
mErrorMessage = oDDM_NamHoc.ErrorMessages;
mErrorNumber = oDDM_NamHoc.ErrorNumber;
}
