public void Delete(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_QuaTrinhThamGiaLucLuongVuTrangID", SqlDbType.Int, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NS_QuaTrinhThamGiaLucLuongVuTrangID));
RunProcedure("sp_NS_QuaTrinhThamGiaLucLuongVuTrang_Delete", colParam);
}
public DataTable Get(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_QuaTrinhThamGiaLucLuongVuTrangID", SqlDbType.Int, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NS_QuaTrinhThamGiaLucLuongVuTrangID));
return(RunProcedureGet("sp_NS_QuaTrinhThamGiaLucLuongVuTrang_Get", colParam));
}
public int Add(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo)
{
int ID = 0;
ID = oDNS_QuaTrinhThamGiaLucLuongVuTrang.Add(pNS_QuaTrinhThamGiaLucLuongVuTrangInfo);
mErrorMessage = oDNS_QuaTrinhThamGiaLucLuongVuTrang.ErrorMessages;
mErrorNumber = oDNS_QuaTrinhThamGiaLucLuongVuTrang.ErrorNumber;
return(ID);
}
public void ToDataRow(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo, ref DataRow dr)
{
dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strNS_QuaTrinhThamGiaLucLuongVuTrangID] = pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NS_QuaTrinhThamGiaLucLuongVuTrangID;
dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strIDNS_GiaoVien] = pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDNS_GiaoVien;
dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strNgayNhapNgu] = pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayNhapNgu;
dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strNgayXuatNgu] = pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayXuatNgu;
dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strIDDM_QuanHam] = pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDDM_QuanHam;
dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strDonVi] = pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.DonVi;
dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strChucVu] = pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.ChucVu;
}
public void Update(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@NgayNhapNgu", SqlDbType.DateTime, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayNhapNgu));
colParam.Add(CreateParam("@NgayXuatNgu", SqlDbType.DateTime, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayXuatNgu));
colParam.Add(CreateParam("@IDDM_QuanHam", SqlDbType.Int, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDDM_QuanHam));
colParam.Add(CreateParam("@DonVi", SqlDbType.NVarChar, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.DonVi));
colParam.Add(CreateParam("@ChucVu", SqlDbType.NVarChar, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.ChucVu));
colParam.Add(CreateParam("@NS_QuaTrinhThamGiaLucLuongVuTrangID", SqlDbType.Int, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NS_QuaTrinhThamGiaLucLuongVuTrangID));
RunProcedure("sp_NS_QuaTrinhThamGiaLucLuongVuTrang_Update", colParam);
}
public int Add(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@NgayNhapNgu", SqlDbType.DateTime, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayNhapNgu));
colParam.Add(CreateParam("@NgayXuatNgu", SqlDbType.DateTime, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayXuatNgu));
colParam.Add(CreateParam("@IDDM_QuanHam", SqlDbType.Int, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDDM_QuanHam));
colParam.Add(CreateParam("@DonVi", SqlDbType.NVarChar, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.DonVi));
colParam.Add(CreateParam("@ChucVu", SqlDbType.NVarChar, pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.ChucVu));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_NS_QuaTrinhThamGiaLucLuongVuTrang_Add", colParam));
}
public frmQuaTrinhThamGiaLLVT()
{
InitializeComponent();
oBGiaoVien = new cBNS_GiaoVien();
pGiaoVienInfo = new NS_GiaoVienInfo();
pDonViInfo = new NS_DonViInfo();
oBQuaTrinhThamGiaLucLuongVuTrang = new cBNS_QuaTrinhThamGiaLucLuongVuTrang();
pNS_QuaTrinhThamGiaLucLuongVuTrangInfo = new NS_QuaTrinhThamGiaLucLuongVuTrangInfo();
dtpDenNgay.Enabled = false;
SetButton(false);
btnThem.Enabled = true;
SetControl(true);
btnLuu.Enabled = false;
}
public void ToInfo(ref NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo, DataRow dr)
{
pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NS_QuaTrinhThamGiaLucLuongVuTrangID = int.Parse(dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strNS_QuaTrinhThamGiaLucLuongVuTrangID].ToString());
pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDNS_GiaoVien = int.Parse("0" + dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strIDNS_GiaoVien]);
if (dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strNgayNhapNgu].ToString() != "")
{
pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayNhapNgu = DateTime.Parse(dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strNgayNhapNgu].ToString());
}
if (dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strNgayXuatNgu].ToString() != "")
{
pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayXuatNgu = DateTime.Parse(dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strNgayXuatNgu].ToString());
}
pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDDM_QuanHam = int.Parse("0" + dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strIDDM_QuanHam]);
pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.DonVi = dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strDonVi].ToString();
pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.ChucVu = dr[pNS_QuaTrinhThamGiaLucLuongVuTrangInfo.strChucVu].ToString();
}
public List <NS_QuaTrinhThamGiaLucLuongVuTrangInfo> GetList(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo)
{
List <NS_QuaTrinhThamGiaLucLuongVuTrangInfo> oNS_QuaTrinhThamGiaLucLuongVuTrangInfoList = new List <NS_QuaTrinhThamGiaLucLuongVuTrangInfo>();
DataTable dtb = Get(pNS_QuaTrinhThamGiaLucLuongVuTrangInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oNS_QuaTrinhThamGiaLucLuongVuTrangInfo = new NS_QuaTrinhThamGiaLucLuongVuTrangInfo();
oNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NS_QuaTrinhThamGiaLucLuongVuTrangID = int.Parse(dtb.Rows[i]["NS_QuaTrinhThamGiaLucLuongVuTrangID"].ToString());
oNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDNS_GiaoVien = int.Parse(dtb.Rows[i]["IDNS_GiaoVien"].ToString());
oNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayNhapNgu = DateTime.Parse(dtb.Rows[i]["NgayNhapNgu"].ToString());
oNS_QuaTrinhThamGiaLucLuongVuTrangInfo.NgayXuatNgu = DateTime.Parse(dtb.Rows[i]["NgayXuatNgu"].ToString());
oNS_QuaTrinhThamGiaLucLuongVuTrangInfo.IDDM_QuanHam = int.Parse(dtb.Rows[i]["IDDM_QuanHam"].ToString());
oNS_QuaTrinhThamGiaLucLuongVuTrangInfo.DonVi = dtb.Rows[i]["DonVi"].ToString();
oNS_QuaTrinhThamGiaLucLuongVuTrangInfo.ChucVu = dtb.Rows[i]["ChucVu"].ToString();
oNS_QuaTrinhThamGiaLucLuongVuTrangInfoList.Add(oNS_QuaTrinhThamGiaLucLuongVuTrangInfo);
}
}
return(oNS_QuaTrinhThamGiaLucLuongVuTrangInfoList);
}
public void Delete(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo)
{
oDNS_QuaTrinhThamGiaLucLuongVuTrang.Delete(pNS_QuaTrinhThamGiaLucLuongVuTrangInfo);
mErrorMessage = oDNS_QuaTrinhThamGiaLucLuongVuTrang.ErrorMessages;
mErrorNumber = oDNS_QuaTrinhThamGiaLucLuongVuTrang.ErrorNumber;
}
public DataTable Get(NS_QuaTrinhThamGiaLucLuongVuTrangInfo pNS_QuaTrinhThamGiaLucLuongVuTrangInfo)
{
return(oDNS_QuaTrinhThamGiaLucLuongVuTrang.Get(pNS_QuaTrinhThamGiaLucLuongVuTrangInfo));
}
