public void Delete(NS_QuaTrinhMienNhiemTuChucInfo pNS_QuaTrinhMienNhiemTuChucInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_QuaTrinhMienNhiemTuChucID", SqlDbType.Int, pNS_QuaTrinhMienNhiemTuChucInfo.NS_QuaTrinhMienNhiemTuChucID));
RunProcedure("sp_NS_QuaTrinhMienNhiemTuChuc_Delete", colParam);
}
public DataTable Get(NS_QuaTrinhMienNhiemTuChucInfo pNS_QuaTrinhMienNhiemTuChucInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_QuaTrinhMienNhiemTuChucID", SqlDbType.Int, pNS_QuaTrinhMienNhiemTuChucInfo.NS_QuaTrinhMienNhiemTuChucID));
return(RunProcedureGet("sp_NS_QuaTrinhMienNhiemTuChuc_Get", colParam));
}
public int Add(NS_QuaTrinhMienNhiemTuChucInfo pNS_QuaTrinhMienNhiemTuChucInfo)
{
int ID = 0;
ID = oDNS_QuaTrinhMienNhiemTuChuc.Add(pNS_QuaTrinhMienNhiemTuChucInfo);
mErrorMessage = oDNS_QuaTrinhMienNhiemTuChuc.ErrorMessages;
mErrorNumber = oDNS_QuaTrinhMienNhiemTuChuc.ErrorNumber;
return(ID);
}
public int Add_QuaTrinhBoNhiemChucVu(NS_QuaTrinhMienNhiemTuChucInfo pNS_QuaTrinhMienNhiemTuChucInfo, int NS_QuaTrinhBoNhiemChucVuID1)
{
int ID = 0;
ID = oDNS_QuaTrinhMienNhiemTuChuc.Add_QuaTrinhBoNhiemChucVu(pNS_QuaTrinhMienNhiemTuChucInfo, NS_QuaTrinhBoNhiemChucVuID1);
mErrorMessage = oDNS_QuaTrinhMienNhiemTuChuc.ErrorMessages;
mErrorNumber = oDNS_QuaTrinhMienNhiemTuChuc.ErrorNumber;
return(ID);
}
public void ToInfo(ref NS_QuaTrinhMienNhiemTuChucInfo pNS_QuaTrinhMienNhiemTuChucInfo, DataRow dr)
{
pNS_QuaTrinhMienNhiemTuChucInfo.NS_QuaTrinhMienNhiemTuChucID = int.Parse(dr[pNS_QuaTrinhMienNhiemTuChucInfo.strNS_QuaTrinhMienNhiemTuChucID].ToString());
pNS_QuaTrinhMienNhiemTuChucInfo.IDNS_GiaoVien = int.Parse(dr[pNS_QuaTrinhMienNhiemTuChucInfo.strIDNS_GiaoVien].ToString());
pNS_QuaTrinhMienNhiemTuChucInfo.SoQuyetDinh = dr[pNS_QuaTrinhMienNhiemTuChucInfo.strSoQuyetDinh].ToString();
pNS_QuaTrinhMienNhiemTuChucInfo.NgayRaQuyetDinh = DateTime.Parse(dr[pNS_QuaTrinhMienNhiemTuChucInfo.strNgayRaQuyetDinh].ToString());
pNS_QuaTrinhMienNhiemTuChucInfo.NgayCoHieuLuc = DateTime.Parse(dr[pNS_QuaTrinhMienNhiemTuChucInfo.strNgayCoHieuLuc].ToString());
pNS_QuaTrinhMienNhiemTuChucInfo.IDDM_CapQuyetDinh = int.Parse(dr[pNS_QuaTrinhMienNhiemTuChucInfo.strIDDM_CapQuyetDinh].ToString());
}
public void ToDataRow(NS_QuaTrinhMienNhiemTuChucInfo pNS_QuaTrinhMienNhiemTuChucInfo, ref DataRow dr)
{
dr[pNS_QuaTrinhMienNhiemTuChucInfo.strNS_QuaTrinhMienNhiemTuChucID] = pNS_QuaTrinhMienNhiemTuChucInfo.NS_QuaTrinhMienNhiemTuChucID;
dr[pNS_QuaTrinhMienNhiemTuChucInfo.strIDNS_GiaoVien] = pNS_QuaTrinhMienNhiemTuChucInfo.IDNS_GiaoVien;
dr[pNS_QuaTrinhMienNhiemTuChucInfo.strSoQuyetDinh] = pNS_QuaTrinhMienNhiemTuChucInfo.SoQuyetDinh;
dr[pNS_QuaTrinhMienNhiemTuChucInfo.strNgayRaQuyetDinh] = pNS_QuaTrinhMienNhiemTuChucInfo.NgayRaQuyetDinh;
dr[pNS_QuaTrinhMienNhiemTuChucInfo.strNgayCoHieuLuc] = pNS_QuaTrinhMienNhiemTuChucInfo.NgayCoHieuLuc;
dr[pNS_QuaTrinhMienNhiemTuChucInfo.strIDDM_CapQuyetDinh] = pNS_QuaTrinhMienNhiemTuChucInfo.IDDM_CapQuyetDinh;
}
public void Update(NS_QuaTrinhMienNhiemTuChucInfo pNS_QuaTrinhMienNhiemTuChucInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pNS_QuaTrinhMienNhiemTuChucInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@SoQuyetDinh", SqlDbType.NVarChar, pNS_QuaTrinhMienNhiemTuChucInfo.SoQuyetDinh));
colParam.Add(CreateParam("@NgayRaQuyetDinh", SqlDbType.DateTime, pNS_QuaTrinhMienNhiemTuChucInfo.NgayRaQuyetDinh));
colParam.Add(CreateParam("@NgayCoHieuLuc", SqlDbType.DateTime, pNS_QuaTrinhMienNhiemTuChucInfo.NgayCoHieuLuc));
colParam.Add(CreateParam("@IDDM_CapQuyetDinh", SqlDbType.Int, pNS_QuaTrinhMienNhiemTuChucInfo.IDDM_CapQuyetDinh));
colParam.Add(CreateParam("@NS_QuaTrinhMienNhiemTuChucID", SqlDbType.Int, pNS_QuaTrinhMienNhiemTuChucInfo.NS_QuaTrinhMienNhiemTuChucID));
RunProcedure("sp_NS_QuaTrinhMienNhiemTuChuc_Update", colParam);
}
public int Add(NS_QuaTrinhMienNhiemTuChucInfo pNS_QuaTrinhMienNhiemTuChucInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pNS_QuaTrinhMienNhiemTuChucInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@SoQuyetDinh", SqlDbType.NVarChar, pNS_QuaTrinhMienNhiemTuChucInfo.SoQuyetDinh));
colParam.Add(CreateParam("@NgayRaQuyetDinh", SqlDbType.DateTime, pNS_QuaTrinhMienNhiemTuChucInfo.NgayRaQuyetDinh));
colParam.Add(CreateParam("@NgayCoHieuLuc", SqlDbType.DateTime, pNS_QuaTrinhMienNhiemTuChucInfo.NgayCoHieuLuc));
colParam.Add(CreateParam("@IDDM_CapQuyetDinh", SqlDbType.Int, pNS_QuaTrinhMienNhiemTuChucInfo.IDDM_CapQuyetDinh));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_NS_QuaTrinhMienNhiemTuChuc_Add", colParam));
}
public frmQuaTrinhMienNhiemTuChuc()
{
InitializeComponent();
oBGiaoVien = new cBNS_GiaoVien();
pGiaoVienInfo = new NS_GiaoVienInfo();
pDonViInfo = new NS_DonViInfo();
oBDM_ChucVu = new cBDM_ChucVu();
oBQuaTrinhMienNhiemTuChuc = new cBNS_QuaTrinhMienNhiemTuChuc();
pNS_QuaTrinhMienNhiemTuChucInfo = new NS_QuaTrinhMienNhiemTuChucInfo();
SetButton(false);
btnThem.Enabled = true;
SetControl(true);
btnLuu.Enabled = false;
}
public List <NS_QuaTrinhMienNhiemTuChucInfo> GetList(NS_QuaTrinhMienNhiemTuChucInfo pNS_QuaTrinhMienNhiemTuChucInfo)
{
List <NS_QuaTrinhMienNhiemTuChucInfo> oNS_QuaTrinhMienNhiemTuChucInfoList = new List <NS_QuaTrinhMienNhiemTuChucInfo>();
DataTable dtb = Get(pNS_QuaTrinhMienNhiemTuChucInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oNS_QuaTrinhMienNhiemTuChucInfo = new NS_QuaTrinhMienNhiemTuChucInfo();
oNS_QuaTrinhMienNhiemTuChucInfo.NS_QuaTrinhMienNhiemTuChucID = int.Parse(dtb.Rows[i]["NS_QuaTrinhMienNhiemTuChucID"].ToString());
oNS_QuaTrinhMienNhiemTuChucInfo.IDNS_GiaoVien = int.Parse(dtb.Rows[i]["IDNS_GiaoVien"].ToString());
oNS_QuaTrinhMienNhiemTuChucInfo.SoQuyetDinh = dtb.Rows[i]["SoQuyetDinh"].ToString();
oNS_QuaTrinhMienNhiemTuChucInfo.NgayRaQuyetDinh = DateTime.Parse(dtb.Rows[i]["NgayRaQuyetDinh"].ToString());
oNS_QuaTrinhMienNhiemTuChucInfo.NgayCoHieuLuc = DateTime.Parse(dtb.Rows[i]["NgayCoHieuLuc"].ToString());
oNS_QuaTrinhMienNhiemTuChucInfo.IDDM_CapQuyetDinh = int.Parse(dtb.Rows[i]["IDDM_CapQuyetDinh"].ToString());
oNS_QuaTrinhMienNhiemTuChucInfoList.Add(oNS_QuaTrinhMienNhiemTuChucInfo);
}
}
return(oNS_QuaTrinhMienNhiemTuChucInfoList);
}
public void Delete(NS_QuaTrinhMienNhiemTuChucInfo pNS_QuaTrinhMienNhiemTuChucInfo)
{
oDNS_QuaTrinhMienNhiemTuChuc.Delete(pNS_QuaTrinhMienNhiemTuChucInfo);
mErrorMessage = oDNS_QuaTrinhMienNhiemTuChuc.ErrorMessages;
mErrorNumber = oDNS_QuaTrinhMienNhiemTuChuc.ErrorNumber;
}
public void Delete_QuaTrinhBoNhiemChucVu(NS_QuaTrinhMienNhiemTuChucInfo pNS_QuaTrinhMienNhiemTuChucInfo, int NS_QuaTrinhBoNhiemChucVuID)
{
oDNS_QuaTrinhMienNhiemTuChuc.Delete_QuaTrinhBoNhiemChucVu(pNS_QuaTrinhMienNhiemTuChucInfo, NS_QuaTrinhBoNhiemChucVuID);
mErrorMessage = oDNS_QuaTrinhMienNhiemTuChuc.ErrorMessages;
mErrorNumber = oDNS_QuaTrinhMienNhiemTuChuc.ErrorNumber;
}
public void Update_QuaTrinhBoNhiem(NS_QuaTrinhMienNhiemTuChucInfo pNS_QuaTrinhMienNhiemTuChucInfo, int NS_QuaTrinhBoNhiemChucVuID, int NS_QuaTrinhBoNhiemChucVuID1)
{
oDNS_QuaTrinhMienNhiemTuChuc.Update_QuaTrinhBoNhiem(pNS_QuaTrinhMienNhiemTuChucInfo, NS_QuaTrinhBoNhiemChucVuID, NS_QuaTrinhBoNhiemChucVuID1);
mErrorMessage = oDNS_QuaTrinhMienNhiemTuChuc.ErrorMessages;
mErrorNumber = oDNS_QuaTrinhMienNhiemTuChuc.ErrorNumber;
}
public DataTable Get(NS_QuaTrinhMienNhiemTuChucInfo pNS_QuaTrinhMienNhiemTuChucInfo)
{
return(oDNS_QuaTrinhMienNhiemTuChuc.Get(pNS_QuaTrinhMienNhiemTuChucInfo));
}
