public List <GG_DinhMucGioDayInfo> GetList(GG_DinhMucGioDayInfo pGG_DinhMucGioDayInfo)
{
List <GG_DinhMucGioDayInfo> oGG_DinhMucGioDayInfoList = new List <GG_DinhMucGioDayInfo>();
DataTable dtb = Get(pGG_DinhMucGioDayInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
pGG_DinhMucGioDayInfo = new GG_DinhMucGioDayInfo();
pGG_DinhMucGioDayInfo.GG_DinhMucGioDayID = int.Parse(dtb.Rows[i][pGG_DinhMucGioDayInfo.strGG_DinhMucGioDayID].ToString());
pGG_DinhMucGioDayInfo.IDNS_GiaoVien = int.Parse(dtb.Rows[i][pGG_DinhMucGioDayInfo.strIDNS_GiaoVien].ToString());
if ("" + dtb.Rows[i][pGG_DinhMucGioDayInfo.strSoGioGiam] != "")
{
pGG_DinhMucGioDayInfo.SoGioGiam = double.Parse(dtb.Rows[i][pGG_DinhMucGioDayInfo.strSoGioGiam].ToString());
}
if ("" + dtb.Rows[i][pGG_DinhMucGioDayInfo.strSoGioDinhMuc] != "")
{
pGG_DinhMucGioDayInfo.SoGioDinhMuc = double.Parse(dtb.Rows[i][pGG_DinhMucGioDayInfo.strSoGioDinhMuc].ToString());
}
pGG_DinhMucGioDayInfo.IDDM_NamHoc = int.Parse(dtb.Rows[i][pGG_DinhMucGioDayInfo.strIDDM_NamHoc].ToString());
if ("" + dtb.Rows[i][pGG_DinhMucGioDayInfo.strHocKy] != "")
{
pGG_DinhMucGioDayInfo.HocKy = int.Parse(dtb.Rows[i][pGG_DinhMucGioDayInfo.strHocKy].ToString());
}
oGG_DinhMucGioDayInfoList.Add(pGG_DinhMucGioDayInfo);
}
}
return(oGG_DinhMucGioDayInfoList);
}
public DataTable Get(GG_DinhMucGioDayInfo pGG_DinhMucGioDayInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_GG_DinhMucGioDay_GetResult>(client.cDGG_DinhMucGioDay_Get(GlobalVar.MaXacThuc, pGG_DinhMucGioDayInfo)));
}
}
public DataTable Get(GG_DinhMucGioDayInfo pGG_DinhMucGioDayInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@GG_DinhMucGioDayID", SqlDbType.Int, pGG_DinhMucGioDayInfo.GG_DinhMucGioDayID));
return(RunProcedureGet("sp_GG_DinhMucGioDay_Get", colParam));
}
public void Delete(GG_DinhMucGioDayInfo pGG_DinhMucGioDayInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@GG_DinhMucGioDayID", SqlDbType.Int, pGG_DinhMucGioDayInfo.GG_DinhMucGioDayID));
RunProcedure("sp_GG_DinhMucGioDay_Delete", colParam);
}
public void Delete(GG_DinhMucGioDayInfo pGG_DinhMucGioDayInfo)
{
var client = new UnimOsServiceClient();
client.cDGG_DinhMucGioDay_Delete(GlobalVar.MaXacThuc, pGG_DinhMucGioDayInfo);
client.Close();
mErrorMessage = oDGG_DinhMucGioDay.ErrorMessages;
mErrorNumber = oDGG_DinhMucGioDay.ErrorNumber;
}
public void ToDataRow(GG_DinhMucGioDayInfo pGG_DinhMucGioDayInfo, ref DataRow dr)
{
dr[pGG_DinhMucGioDayInfo.strGG_DinhMucGioDayID] = pGG_DinhMucGioDayInfo.GG_DinhMucGioDayID;
dr[pGG_DinhMucGioDayInfo.strIDNS_GiaoVien] = pGG_DinhMucGioDayInfo.IDNS_GiaoVien;
dr[pGG_DinhMucGioDayInfo.strSoGioGiam] = pGG_DinhMucGioDayInfo.SoGioGiam;
dr[pGG_DinhMucGioDayInfo.strSoGioDinhMuc] = pGG_DinhMucGioDayInfo.SoGioDinhMuc;
dr[pGG_DinhMucGioDayInfo.strIDDM_NamHoc] = pGG_DinhMucGioDayInfo.IDDM_NamHoc;
dr[pGG_DinhMucGioDayInfo.strHocKy] = pGG_DinhMucGioDayInfo.HocKy;
}
public int Add(GG_DinhMucGioDayInfo pGG_DinhMucGioDayInfo)
{
int ID = 0;
ID = oDGG_DinhMucGioDay.Add(pGG_DinhMucGioDayInfo);
mErrorMessage = oDGG_DinhMucGioDay.ErrorMessages;
mErrorNumber = oDGG_DinhMucGioDay.ErrorNumber;
return(ID);
}
public int Add(GG_DinhMucGioDayInfo pGG_DinhMucGioDayInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDGG_DinhMucGioDay_Add(GlobalVar.MaXacThuc, pGG_DinhMucGioDayInfo);
client.Close();
mErrorMessage = oDGG_DinhMucGioDay.ErrorMessages;
mErrorNumber = oDGG_DinhMucGioDay.ErrorNumber;
return(ID);
}
public void Update(GG_DinhMucGioDayInfo pGG_DinhMucGioDayInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pGG_DinhMucGioDayInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@SoGioGiam", SqlDbType.Float, pGG_DinhMucGioDayInfo.SoGioGiam));
colParam.Add(CreateParam("@SoGioDinhMuc", SqlDbType.Float, pGG_DinhMucGioDayInfo.SoGioDinhMuc));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pGG_DinhMucGioDayInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pGG_DinhMucGioDayInfo.HocKy));
colParam.Add(CreateParam("@GG_DinhMucGioDayID", SqlDbType.Int, pGG_DinhMucGioDayInfo.GG_DinhMucGioDayID));
RunProcedure("sp_GG_DinhMucGioDay_Update", colParam);
}
public int Add(GG_DinhMucGioDayInfo pGG_DinhMucGioDayInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pGG_DinhMucGioDayInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@SoGioGiam", SqlDbType.Float, pGG_DinhMucGioDayInfo.SoGioGiam));
colParam.Add(CreateParam("@SoGioDinhMuc", SqlDbType.Float, pGG_DinhMucGioDayInfo.SoGioDinhMuc));
colParam.Add(CreateParam("@IDDM_NamHoc", SqlDbType.Int, pGG_DinhMucGioDayInfo.IDDM_NamHoc));
colParam.Add(CreateParam("@HocKy", SqlDbType.Int, pGG_DinhMucGioDayInfo.HocKy));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_GG_DinhMucGioDay_Add", colParam));
}
public void ToInfo(ref GG_DinhMucGioDayInfo pGG_DinhMucGioDayInfo, DataRow dr)
{
pGG_DinhMucGioDayInfo.GG_DinhMucGioDayID = int.Parse(dr[pGG_DinhMucGioDayInfo.strGG_DinhMucGioDayID].ToString());
pGG_DinhMucGioDayInfo.IDNS_GiaoVien = int.Parse(dr[pGG_DinhMucGioDayInfo.strIDNS_GiaoVien].ToString());
if ("" + dr[pGG_DinhMucGioDayInfo.strSoGioGiam] != "")
{
pGG_DinhMucGioDayInfo.SoGioGiam = double.Parse(dr[pGG_DinhMucGioDayInfo.strSoGioGiam].ToString());
}
if ("" + dr[pGG_DinhMucGioDayInfo.strSoGioDinhMuc] != "")
{
pGG_DinhMucGioDayInfo.SoGioDinhMuc = double.Parse(dr[pGG_DinhMucGioDayInfo.strSoGioDinhMuc].ToString());
}
pGG_DinhMucGioDayInfo.IDDM_NamHoc = int.Parse(dr[pGG_DinhMucGioDayInfo.strIDDM_NamHoc].ToString());
if ("" + dr[pGG_DinhMucGioDayInfo.strHocKy] != "")
{
pGG_DinhMucGioDayInfo.HocKy = int.Parse(dr[pGG_DinhMucGioDayInfo.strHocKy].ToString());
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (dtGiaoVien.Rows.Count == 0)
{
return;
}
DataTable dtChange = dtGiaoVien.GetChanges();
if (dtChange != null)
{
oBGGDinhMucGioDay = new cBGG_DinhMucGioDay();
pDinhMucGioDayInfo = new GG_DinhMucGioDayInfo();
for (int i = 0; i < dtChange.Rows.Count; i++)
{
pDinhMucGioDayInfo.IDNS_GiaoVien = int.Parse(dtChange.Rows[i]["NS_GiaoVienID"].ToString());
pDinhMucGioDayInfo.IDDM_NamHoc = Program.IDNamHoc;
pDinhMucGioDayInfo.HocKy = Program.HocKy;
if (dtChange.Rows[i]["SoGioDinhMuc"] + "" != "")
{
pDinhMucGioDayInfo.SoGioDinhMuc = double.Parse(dtChange.Rows[i]["SoGioDinhMuc"].ToString());
}
if (dtChange.Rows[i]["SoGioGiam"] + "" != "")
{
pDinhMucGioDayInfo.SoGioGiam = double.Parse(dtChange.Rows[i]["SoGioGiam"].ToString());
}
if (dtChange.Rows[i]["GG_DinhMucGioDayID"] + "" != "")
{
pDinhMucGioDayInfo.GG_DinhMucGioDayID = int.Parse(dtChange.Rows[i]["GG_DinhMucGioDayID"].ToString());
oBGGDinhMucGioDay.Update(pDinhMucGioDayInfo);
}
else
{
oBGGDinhMucGioDay.Add(pDinhMucGioDayInfo);
}
}
trvDonVi_FocusedNodeChanged(null, null);
}
}
public void Delete(GG_DinhMucGioDayInfo pGG_DinhMucGioDayInfo)
{
oDGG_DinhMucGioDay.Delete(pGG_DinhMucGioDayInfo);
mErrorMessage = oDGG_DinhMucGioDay.ErrorMessages;
mErrorNumber = oDGG_DinhMucGioDay.ErrorNumber;
}
public DataTable Get(GG_DinhMucGioDayInfo pGG_DinhMucGioDayInfo)
{
return(oDGG_DinhMucGioDay.Get(pGG_DinhMucGioDayInfo));
}
