public void ToDataRow(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo, ref DataRow dr)
{
dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strNS_QuaTrinhThamGiaToChucCTXHID] = pNS_QuaTrinhThamGiaToChucCTXHInfo.NS_QuaTrinhThamGiaToChucCTXHID;
dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strIDNS_GiaoVien] = pNS_QuaTrinhThamGiaToChucCTXHInfo.IDNS_GiaoVien;
dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strNgayThamGia] = pNS_QuaTrinhThamGiaToChucCTXHInfo.NgayThamGia;
dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strTenToChuc] = pNS_QuaTrinhThamGiaToChucCTXHInfo.TenToChuc;
dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strCongViec] = pNS_QuaTrinhThamGiaToChucCTXHInfo.CongViec;
}
public void Delete(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_QuaTrinhThamGiaToChucCTXHID", SqlDbType.Int, pNS_QuaTrinhThamGiaToChucCTXHInfo.NS_QuaTrinhThamGiaToChucCTXHID));
RunProcedure("sp_NS_QuaTrinhThamGiaToChucCTXH_Delete", colParam);
}
public DataTable Get(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_QuaTrinhThamGiaToChucCTXHID", SqlDbType.Int, pNS_QuaTrinhThamGiaToChucCTXHInfo.NS_QuaTrinhThamGiaToChucCTXHID));
return(RunProcedureGet("sp_NS_QuaTrinhThamGiaToChucCTXH_Get", colParam));
}
public int Add(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo)
{
int ID = 0;
ID = oDNS_QuaTrinhThamGiaToChucCTXH.Add(pNS_QuaTrinhThamGiaToChucCTXHInfo);
mErrorMessage = oDNS_QuaTrinhThamGiaToChucCTXH.ErrorMessages;
mErrorNumber = oDNS_QuaTrinhThamGiaToChucCTXH.ErrorNumber;
return(ID);
}
public void ToInfo(ref NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo, DataRow dr)
{
pNS_QuaTrinhThamGiaToChucCTXHInfo.NS_QuaTrinhThamGiaToChucCTXHID = int.Parse(dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strNS_QuaTrinhThamGiaToChucCTXHID].ToString());
pNS_QuaTrinhThamGiaToChucCTXHInfo.IDNS_GiaoVien = int.Parse("0" + dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strIDNS_GiaoVien]);
if (dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strNgayThamGia].ToString() != "")
{
pNS_QuaTrinhThamGiaToChucCTXHInfo.NgayThamGia = DateTime.Parse(dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strNgayThamGia].ToString());
}
pNS_QuaTrinhThamGiaToChucCTXHInfo.TenToChuc = dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strTenToChuc].ToString();
pNS_QuaTrinhThamGiaToChucCTXHInfo.CongViec = dr[pNS_QuaTrinhThamGiaToChucCTXHInfo.strCongViec].ToString();
}
public void Update(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pNS_QuaTrinhThamGiaToChucCTXHInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@NgayThamGia", SqlDbType.DateTime, pNS_QuaTrinhThamGiaToChucCTXHInfo.NgayThamGia));
colParam.Add(CreateParam("@TenToChuc", SqlDbType.NVarChar, pNS_QuaTrinhThamGiaToChucCTXHInfo.TenToChuc));
colParam.Add(CreateParam("@CongViec", SqlDbType.NVarChar, pNS_QuaTrinhThamGiaToChucCTXHInfo.CongViec));
colParam.Add(CreateParam("@NS_QuaTrinhThamGiaToChucCTXHID", SqlDbType.Int, pNS_QuaTrinhThamGiaToChucCTXHInfo.NS_QuaTrinhThamGiaToChucCTXHID));
RunProcedure("sp_NS_QuaTrinhThamGiaToChucCTXH_Update", colParam);
}
public int Add(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pNS_QuaTrinhThamGiaToChucCTXHInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@NgayThamGia", SqlDbType.DateTime, pNS_QuaTrinhThamGiaToChucCTXHInfo.NgayThamGia));
colParam.Add(CreateParam("@TenToChuc", SqlDbType.NVarChar, pNS_QuaTrinhThamGiaToChucCTXHInfo.TenToChuc));
colParam.Add(CreateParam("@CongViec", SqlDbType.NVarChar, pNS_QuaTrinhThamGiaToChucCTXHInfo.CongViec));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_NS_QuaTrinhThamGiaToChucCTXH_Add", colParam));
}
public frmQuaTrinhThamGiaTCCTXH()
{
InitializeComponent();
oBGiaoVien = new cBNS_GiaoVien();
pGiaoVienInfo = new NS_GiaoVienInfo();
pDonViInfo = new NS_DonViInfo();
oBQuaTrinhThamGiaToChucCTXH = new cBNS_QuaTrinhThamGiaToChucCTXH();
pNS_QuaTrinhThamGiaToChucCTXHInfo = new NS_QuaTrinhThamGiaToChucCTXHInfo();
SetButton(false);
btnThem.Enabled = true;
SetControl(true);
btnLuu.Enabled = false;
}
public List <NS_QuaTrinhThamGiaToChucCTXHInfo> GetList(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo)
{
List <NS_QuaTrinhThamGiaToChucCTXHInfo> oNS_QuaTrinhThamGiaToChucCTXHInfoList = new List <NS_QuaTrinhThamGiaToChucCTXHInfo>();
DataTable dtb = Get(pNS_QuaTrinhThamGiaToChucCTXHInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oNS_QuaTrinhThamGiaToChucCTXHInfo = new NS_QuaTrinhThamGiaToChucCTXHInfo();
oNS_QuaTrinhThamGiaToChucCTXHInfo.NS_QuaTrinhThamGiaToChucCTXHID = int.Parse(dtb.Rows[i]["NS_QuaTrinhThamGiaToChucCTXHID"].ToString());
oNS_QuaTrinhThamGiaToChucCTXHInfo.IDNS_GiaoVien = int.Parse(dtb.Rows[i]["IDNS_GiaoVien"].ToString());
oNS_QuaTrinhThamGiaToChucCTXHInfo.NgayThamGia = DateTime.Parse(dtb.Rows[i]["NgayThamGia"].ToString());
oNS_QuaTrinhThamGiaToChucCTXHInfo.TenToChuc = dtb.Rows[i]["TenToChuc"].ToString();
oNS_QuaTrinhThamGiaToChucCTXHInfo.CongViec = dtb.Rows[i]["CongViec"].ToString();
oNS_QuaTrinhThamGiaToChucCTXHInfoList.Add(oNS_QuaTrinhThamGiaToChucCTXHInfo);
}
}
return(oNS_QuaTrinhThamGiaToChucCTXHInfoList);
}
public void Delete(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo)
{
oDNS_QuaTrinhThamGiaToChucCTXH.Delete(pNS_QuaTrinhThamGiaToChucCTXHInfo);
mErrorMessage = oDNS_QuaTrinhThamGiaToChucCTXH.ErrorMessages;
mErrorNumber = oDNS_QuaTrinhThamGiaToChucCTXH.ErrorNumber;
}
public DataTable Get(NS_QuaTrinhThamGiaToChucCTXHInfo pNS_QuaTrinhThamGiaToChucCTXHInfo)
{
return(oDNS_QuaTrinhThamGiaToChucCTXH.Get(pNS_QuaTrinhThamGiaToChucCTXHInfo));
}
