public List <GG_HeSoLopDongTheoKhoaInfo> GetList(GG_HeSoLopDongTheoKhoaInfo pGG_HeSoLopDongTheoKhoaInfo)
{
List <GG_HeSoLopDongTheoKhoaInfo> oGG_HeSoLopDongTheoKhoaInfoList = new List <GG_HeSoLopDongTheoKhoaInfo>();
DataTable dtb = Get(pGG_HeSoLopDongTheoKhoaInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
pGG_HeSoLopDongTheoKhoaInfo = new GG_HeSoLopDongTheoKhoaInfo();
pGG_HeSoLopDongTheoKhoaInfo.GG_HeSoLopDongTheoKhoaID = int.Parse(dtb.Rows[i][pGG_HeSoLopDongTheoKhoaInfo.strGG_HeSoLopDongTheoKhoaID].ToString());
pGG_HeSoLopDongTheoKhoaInfo.LoaiGiangDay = dtb.Rows[i][pGG_HeSoLopDongTheoKhoaInfo.strLoaiGiangDay].ToString();
pGG_HeSoLopDongTheoKhoaInfo.IDDM_TrinhDo = int.Parse(dtb.Rows[i][pGG_HeSoLopDongTheoKhoaInfo.strIDDM_TrinhDo].ToString());
pGG_HeSoLopDongTheoKhoaInfo.IDDM_Khoa = int.Parse(dtb.Rows[i][pGG_HeSoLopDongTheoKhoaInfo.strIDDM_Khoa].ToString());
pGG_HeSoLopDongTheoKhoaInfo.SoSVToiDa = int.Parse(dtb.Rows[i][pGG_HeSoLopDongTheoKhoaInfo.strSoSVToiDa].ToString());
pGG_HeSoLopDongTheoKhoaInfo.HeSoQuyChuan = double.Parse(dtb.Rows[i][pGG_HeSoLopDongTheoKhoaInfo.strHeSoQuyChuan].ToString());
pGG_HeSoLopDongTheoKhoaInfo.SoCongThem1Tiet = int.Parse(dtb.Rows[i][pGG_HeSoLopDongTheoKhoaInfo.strSoCongThem1Tiet].ToString());
pGG_HeSoLopDongTheoKhoaInfo.SoTietDinhMuc1Tuan = double.Parse(dtb.Rows[i][pGG_HeSoLopDongTheoKhoaInfo.strSoTietDinhMuc1Tuan].ToString());
oGG_HeSoLopDongTheoKhoaInfoList.Add(pGG_HeSoLopDongTheoKhoaInfo);
}
}
return(oGG_HeSoLopDongTheoKhoaInfoList);
}
public DataTable Get(GG_HeSoLopDongTheoKhoaInfo pGG_HeSoLopDongTheoKhoaInfo)
{
using (var client = new UnimOsServiceClient())
{
return(ConvertList.ToDataTable <sp_GG_HeSoLopDongTheoKhoa_GetResult>(client.cDGG_HeSoLopDongTheoKhoa_Get(GlobalVar.MaXacThuc, pGG_HeSoLopDongTheoKhoaInfo)));
}
}
public frmHeSoLopDongTheoKhoa()
{
InitializeComponent();
oBGG_HeSoLopDongTheoKhoa = new cBGG_HeSoLopDongTheoKhoa();
pGG_HeSoLopDongTheoKhoaInfo = new GG_HeSoLopDongTheoKhoaInfo();
groupTop.Visible = false;
SetControl(false);
}
public void Delete(GG_HeSoLopDongTheoKhoaInfo pGG_HeSoLopDongTheoKhoaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@GG_HeSoLopDongTheoKhoaID", SqlDbType.Int, pGG_HeSoLopDongTheoKhoaInfo.GG_HeSoLopDongTheoKhoaID));
RunProcedure("sp_GG_HeSoLopDongTheoKhoa_Delete", colParam);
}
public DataTable Get(GG_HeSoLopDongTheoKhoaInfo pGG_HeSoLopDongTheoKhoaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@GG_HeSoLopDongTheoKhoaID", SqlDbType.Int, pGG_HeSoLopDongTheoKhoaInfo.GG_HeSoLopDongTheoKhoaID));
return(RunProcedureGet("sp_GG_HeSoLopDongTheoKhoa_Get", colParam));
}
public int Add(GG_HeSoLopDongTheoKhoaInfo pGG_HeSoLopDongTheoKhoaInfo)
{
int ID = 0;
ID = oDGG_HeSoLopDongTheoKhoa.Add(pGG_HeSoLopDongTheoKhoaInfo);
mErrorMessage = oDGG_HeSoLopDongTheoKhoa.ErrorMessages;
mErrorNumber = oDGG_HeSoLopDongTheoKhoa.ErrorNumber;
return(ID);
}
public void Delete(GG_HeSoLopDongTheoKhoaInfo pGG_HeSoLopDongTheoKhoaInfo)
{
var client = new UnimOsServiceClient();
client.cDGG_HeSoLopDongTheoKhoa_Delete(GlobalVar.MaXacThuc, pGG_HeSoLopDongTheoKhoaInfo);
client.Close();
mErrorMessage = oDGG_HeSoLopDongTheoKhoa.ErrorMessages;
mErrorNumber = oDGG_HeSoLopDongTheoKhoa.ErrorNumber;
}
public void ToInfo(ref GG_HeSoLopDongTheoKhoaInfo pGG_HeSoLopDongTheoKhoaInfo, DataRow dr)
{
pGG_HeSoLopDongTheoKhoaInfo.GG_HeSoLopDongTheoKhoaID = int.Parse(dr[pGG_HeSoLopDongTheoKhoaInfo.strGG_HeSoLopDongTheoKhoaID].ToString());
pGG_HeSoLopDongTheoKhoaInfo.LoaiGiangDay = dr[pGG_HeSoLopDongTheoKhoaInfo.strLoaiGiangDay].ToString();
pGG_HeSoLopDongTheoKhoaInfo.IDDM_TrinhDo = int.Parse(dr[pGG_HeSoLopDongTheoKhoaInfo.strIDDM_TrinhDo].ToString());
pGG_HeSoLopDongTheoKhoaInfo.IDDM_Khoa = int.Parse(dr[pGG_HeSoLopDongTheoKhoaInfo.strIDDM_Khoa].ToString());
pGG_HeSoLopDongTheoKhoaInfo.SoSVToiDa = int.Parse(dr[pGG_HeSoLopDongTheoKhoaInfo.strSoSVToiDa].ToString());
pGG_HeSoLopDongTheoKhoaInfo.HeSoQuyChuan = double.Parse(dr[pGG_HeSoLopDongTheoKhoaInfo.strHeSoQuyChuan].ToString());
pGG_HeSoLopDongTheoKhoaInfo.SoCongThem1Tiet = int.Parse(dr[pGG_HeSoLopDongTheoKhoaInfo.strSoCongThem1Tiet].ToString());
pGG_HeSoLopDongTheoKhoaInfo.SoTietDinhMuc1Tuan = double.Parse(dr[pGG_HeSoLopDongTheoKhoaInfo.strSoTietDinhMuc1Tuan].ToString());
}
public void ToDataRow(GG_HeSoLopDongTheoKhoaInfo pGG_HeSoLopDongTheoKhoaInfo, ref DataRow dr)
{
dr[pGG_HeSoLopDongTheoKhoaInfo.strGG_HeSoLopDongTheoKhoaID] = pGG_HeSoLopDongTheoKhoaInfo.GG_HeSoLopDongTheoKhoaID;
dr[pGG_HeSoLopDongTheoKhoaInfo.strLoaiGiangDay] = pGG_HeSoLopDongTheoKhoaInfo.LoaiGiangDay;
dr[pGG_HeSoLopDongTheoKhoaInfo.strIDDM_TrinhDo] = pGG_HeSoLopDongTheoKhoaInfo.IDDM_TrinhDo;
dr[pGG_HeSoLopDongTheoKhoaInfo.strIDDM_Khoa] = pGG_HeSoLopDongTheoKhoaInfo.IDDM_Khoa;
dr[pGG_HeSoLopDongTheoKhoaInfo.strSoSVToiDa] = pGG_HeSoLopDongTheoKhoaInfo.SoSVToiDa;
dr[pGG_HeSoLopDongTheoKhoaInfo.strHeSoQuyChuan] = pGG_HeSoLopDongTheoKhoaInfo.HeSoQuyChuan;
dr[pGG_HeSoLopDongTheoKhoaInfo.strSoCongThem1Tiet] = pGG_HeSoLopDongTheoKhoaInfo.SoCongThem1Tiet;
dr[pGG_HeSoLopDongTheoKhoaInfo.strSoTietDinhMuc1Tuan] = pGG_HeSoLopDongTheoKhoaInfo.SoTietDinhMuc1Tuan;
}
public int Add(GG_HeSoLopDongTheoKhoaInfo pGG_HeSoLopDongTheoKhoaInfo)
{
int ID = 0;
var client = new UnimOsServiceClient();
ID = client.cDGG_HeSoLopDongTheoKhoa_Add(GlobalVar.MaXacThuc, pGG_HeSoLopDongTheoKhoaInfo);
client.Close();
mErrorMessage = oDGG_HeSoLopDongTheoKhoa.ErrorMessages;
mErrorNumber = oDGG_HeSoLopDongTheoKhoa.ErrorNumber;
return(ID);
}
public void Update(GG_HeSoLopDongTheoKhoaInfo pGG_HeSoLopDongTheoKhoaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@LoaiGiangDay", SqlDbType.NVarChar, pGG_HeSoLopDongTheoKhoaInfo.LoaiGiangDay));
colParam.Add(CreateParam("@IDDM_TrinhDo", SqlDbType.Int, pGG_HeSoLopDongTheoKhoaInfo.IDDM_TrinhDo));
colParam.Add(CreateParam("@IDDM_Khoa", SqlDbType.Int, pGG_HeSoLopDongTheoKhoaInfo.IDDM_Khoa));
colParam.Add(CreateParam("@SoSVToiDa", SqlDbType.Int, pGG_HeSoLopDongTheoKhoaInfo.SoSVToiDa));
colParam.Add(CreateParam("@HeSoQuyChuan", SqlDbType.Float, pGG_HeSoLopDongTheoKhoaInfo.HeSoQuyChuan));
colParam.Add(CreateParam("@SoCongThem1Tiet", SqlDbType.Int, pGG_HeSoLopDongTheoKhoaInfo.SoCongThem1Tiet));
colParam.Add(CreateParam("@SoTietDinhMuc1Tuan", SqlDbType.Float, pGG_HeSoLopDongTheoKhoaInfo.SoTietDinhMuc1Tuan));
colParam.Add(CreateParam("@GG_HeSoLopDongTheoKhoaID", SqlDbType.Int, pGG_HeSoLopDongTheoKhoaInfo.GG_HeSoLopDongTheoKhoaID));
RunProcedure("sp_GG_HeSoLopDongTheoKhoa_Update", colParam);
}
public int Add(GG_HeSoLopDongTheoKhoaInfo pGG_HeSoLopDongTheoKhoaInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@LoaiGiangDay", SqlDbType.NVarChar, pGG_HeSoLopDongTheoKhoaInfo.LoaiGiangDay));
colParam.Add(CreateParam("@IDDM_TrinhDo", SqlDbType.Int, pGG_HeSoLopDongTheoKhoaInfo.IDDM_TrinhDo));
colParam.Add(CreateParam("@IDDM_Khoa", SqlDbType.Int, pGG_HeSoLopDongTheoKhoaInfo.IDDM_Khoa));
colParam.Add(CreateParam("@SoSVToiDa", SqlDbType.Int, pGG_HeSoLopDongTheoKhoaInfo.SoSVToiDa));
colParam.Add(CreateParam("@HeSoQuyChuan", SqlDbType.Float, pGG_HeSoLopDongTheoKhoaInfo.HeSoQuyChuan));
colParam.Add(CreateParam("@SoCongThem1Tiet", SqlDbType.Int, pGG_HeSoLopDongTheoKhoaInfo.SoCongThem1Tiet));
colParam.Add(CreateParam("@SoTietDinhMuc1Tuan", SqlDbType.Float, pGG_HeSoLopDongTheoKhoaInfo.SoTietDinhMuc1Tuan));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_GG_HeSoLopDongTheoKhoa_Add", colParam));
}
public void Delete(GG_HeSoLopDongTheoKhoaInfo pGG_HeSoLopDongTheoKhoaInfo)
{
oDGG_HeSoLopDongTheoKhoa.Delete(pGG_HeSoLopDongTheoKhoaInfo);
mErrorMessage = oDGG_HeSoLopDongTheoKhoa.ErrorMessages;
mErrorNumber = oDGG_HeSoLopDongTheoKhoa.ErrorNumber;
}
public DataTable Get(GG_HeSoLopDongTheoKhoaInfo pGG_HeSoLopDongTheoKhoaInfo)
{
return(oDGG_HeSoLopDongTheoKhoa.Get(pGG_HeSoLopDongTheoKhoaInfo));
}
