public List <NS_QuaTrinhLuanChuyenInfo> GetList(NS_QuaTrinhLuanChuyenInfo pNS_QuaTrinhLuanChuyenInfo)
{
List <NS_QuaTrinhLuanChuyenInfo> oNS_QuaTrinhLuanChuyenInfoList = new List <NS_QuaTrinhLuanChuyenInfo>();
DataTable dtb = Get(pNS_QuaTrinhLuanChuyenInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oNS_QuaTrinhLuanChuyenInfo = new NS_QuaTrinhLuanChuyenInfo();
oNS_QuaTrinhLuanChuyenInfo.NS_QuaTrinhLuanChuyenID = int.Parse(dtb.Rows[i]["NS_QuaTrinhLuanChuyenID"].ToString());
oNS_QuaTrinhLuanChuyenInfo.IDNS_GiaoVien = int.Parse(dtb.Rows[i]["IDNS_GiaoVien"].ToString());
oNS_QuaTrinhLuanChuyenInfo.SoQuyetDinh = dtb.Rows[i]["SoQuyetDinh"].ToString();
oNS_QuaTrinhLuanChuyenInfo.NgayQuyetDinh = DateTime.Parse(dtb.Rows[i]["NgayQuyetDinh"].ToString());
oNS_QuaTrinhLuanChuyenInfo.NgayCoHieuLuc = DateTime.Parse(dtb.Rows[i]["NgayCoHieuLuc"].ToString());
oNS_QuaTrinhLuanChuyenInfo.IDNS_LoaiLuanChuyen = int.Parse(dtb.Rows[i]["IDNS_LoaiLuanChuyen"].ToString());
oNS_QuaTrinhLuanChuyenInfo.IDNS_DonViCu = int.Parse(dtb.Rows[i]["IDNS_DonViCu"].ToString());
oNS_QuaTrinhLuanChuyenInfo.IDNS_DonViMoi = int.Parse(dtb.Rows[i]["IDNS_DonViMoi"].ToString());
oNS_QuaTrinhLuanChuyenInfo.NoiDung = dtb.Rows[i]["NoiDung"].ToString();
oNS_QuaTrinhLuanChuyenInfoList.Add(oNS_QuaTrinhLuanChuyenInfo);
}
}
return(oNS_QuaTrinhLuanChuyenInfoList);
}
public void Delete(NS_QuaTrinhLuanChuyenInfo pNS_QuaTrinhLuanChuyenInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_QuaTrinhLuanChuyenID", SqlDbType.Int, pNS_QuaTrinhLuanChuyenInfo.NS_QuaTrinhLuanChuyenID));
RunProcedure("sp_NS_QuaTrinhLuanChuyen_Delete", colParam);
}
public DataTable Get(NS_QuaTrinhLuanChuyenInfo pNS_QuaTrinhLuanChuyenInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_QuaTrinhLuanChuyenID", SqlDbType.Int, pNS_QuaTrinhLuanChuyenInfo.NS_QuaTrinhLuanChuyenID));
return(RunProcedureGet("sp_NS_QuaTrinhLuanChuyen_Get", colParam));
}
public int Add(NS_QuaTrinhLuanChuyenInfo pNS_QuaTrinhLuanChuyenInfo)
{
int ID = 0;
ID = oDNS_QuaTrinhLuanChuyen.Add(pNS_QuaTrinhLuanChuyenInfo);
mErrorMessage = oDNS_QuaTrinhLuanChuyen.ErrorMessages;
mErrorNumber = oDNS_QuaTrinhLuanChuyen.ErrorNumber;
return(ID);
}
public void ToDataRow(NS_QuaTrinhLuanChuyenInfo pNS_QuaTrinhLuanChuyenInfo, ref DataRow dr)
{
dr[pNS_QuaTrinhLuanChuyenInfo.strNS_QuaTrinhLuanChuyenID] = pNS_QuaTrinhLuanChuyenInfo.NS_QuaTrinhLuanChuyenID;
dr[pNS_QuaTrinhLuanChuyenInfo.strIDNS_GiaoVien] = pNS_QuaTrinhLuanChuyenInfo.IDNS_GiaoVien;
dr[pNS_QuaTrinhLuanChuyenInfo.strSoQuyetDinh] = pNS_QuaTrinhLuanChuyenInfo.SoQuyetDinh;
dr[pNS_QuaTrinhLuanChuyenInfo.strNgayQuyetDinh] = pNS_QuaTrinhLuanChuyenInfo.NgayQuyetDinh;
dr[pNS_QuaTrinhLuanChuyenInfo.strNgayCoHieuLuc] = pNS_QuaTrinhLuanChuyenInfo.NgayCoHieuLuc;
dr[pNS_QuaTrinhLuanChuyenInfo.strIDNS_LoaiLuanChuyen] = pNS_QuaTrinhLuanChuyenInfo.IDNS_LoaiLuanChuyen;
dr[pNS_QuaTrinhLuanChuyenInfo.strIDNS_DonViCu] = pNS_QuaTrinhLuanChuyenInfo.IDNS_DonViCu;
dr[pNS_QuaTrinhLuanChuyenInfo.strIDNS_DonViMoi] = pNS_QuaTrinhLuanChuyenInfo.IDNS_DonViMoi;
dr[pNS_QuaTrinhLuanChuyenInfo.strNoiDung] = pNS_QuaTrinhLuanChuyenInfo.NoiDung;
}
public frmQuaTrinhLuanChuyen()
{
InitializeComponent();
oBGiaoVien = new cBNS_GiaoVien();
pGiaoVienInfo = new NS_GiaoVienInfo();
pDonViInfo = new NS_DonViInfo();
oBQuaTrinhLuanChuyen = new cBNS_QuaTrinhLuanChuyen();
pNS_QuaTrinhLuanChuyenInfo = new NS_QuaTrinhLuanChuyenInfo();
SetButton(false);
btnThem.Enabled = true;
SetControl(true);
dtpNgayQuyetDinh.Enabled = false;
dtpNgayCoHieuLuc.Enabled = false;
btnLuu.Enabled = false;
}
public void Update(NS_QuaTrinhLuanChuyenInfo pNS_QuaTrinhLuanChuyenInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pNS_QuaTrinhLuanChuyenInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@SoQuyetDinh", SqlDbType.NVarChar, pNS_QuaTrinhLuanChuyenInfo.SoQuyetDinh));
colParam.Add(CreateParam("@NgayQuyetDinh", SqlDbType.DateTime, pNS_QuaTrinhLuanChuyenInfo.NgayQuyetDinh));
colParam.Add(CreateParam("@NgayCoHieuLuc", SqlDbType.DateTime, pNS_QuaTrinhLuanChuyenInfo.NgayCoHieuLuc));
colParam.Add(CreateParam("@IDNS_LoaiLuanChuyen", SqlDbType.Int, pNS_QuaTrinhLuanChuyenInfo.IDNS_LoaiLuanChuyen));
colParam.Add(CreateParam("@IDNS_DonViCu", SqlDbType.Int, pNS_QuaTrinhLuanChuyenInfo.IDNS_DonViCu));
colParam.Add(CreateParam("@IDNS_DonViMoi", SqlDbType.Int, pNS_QuaTrinhLuanChuyenInfo.IDNS_DonViMoi));
colParam.Add(CreateParam("@NoiDung", SqlDbType.NVarChar, pNS_QuaTrinhLuanChuyenInfo.NoiDung));
colParam.Add(CreateParam("@NS_QuaTrinhLuanChuyenID", SqlDbType.Int, pNS_QuaTrinhLuanChuyenInfo.NS_QuaTrinhLuanChuyenID));
RunProcedure("sp_NS_QuaTrinhLuanChuyen_Update", colParam);
}
public int Add(NS_QuaTrinhLuanChuyenInfo pNS_QuaTrinhLuanChuyenInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@IDNS_GiaoVien", SqlDbType.Int, pNS_QuaTrinhLuanChuyenInfo.IDNS_GiaoVien));
colParam.Add(CreateParam("@SoQuyetDinh", SqlDbType.NVarChar, pNS_QuaTrinhLuanChuyenInfo.SoQuyetDinh));
colParam.Add(CreateParam("@NgayQuyetDinh", SqlDbType.DateTime, pNS_QuaTrinhLuanChuyenInfo.NgayQuyetDinh));
colParam.Add(CreateParam("@NgayCoHieuLuc", SqlDbType.DateTime, pNS_QuaTrinhLuanChuyenInfo.NgayCoHieuLuc));
colParam.Add(CreateParam("@IDNS_LoaiLuanChuyen", SqlDbType.Int, pNS_QuaTrinhLuanChuyenInfo.IDNS_LoaiLuanChuyen));
colParam.Add(CreateParam("@IDNS_DonViCu", SqlDbType.Int, pNS_QuaTrinhLuanChuyenInfo.IDNS_DonViCu));
colParam.Add(CreateParam("@IDNS_DonViMoi", SqlDbType.Int, pNS_QuaTrinhLuanChuyenInfo.IDNS_DonViMoi));
colParam.Add(CreateParam("@NoiDung", SqlDbType.NVarChar, pNS_QuaTrinhLuanChuyenInfo.NoiDung));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_NS_QuaTrinhLuanChuyen_Add", colParam));
}
public void ToInfo(ref NS_QuaTrinhLuanChuyenInfo pNS_QuaTrinhLuanChuyenInfo, DataRow dr)
{
pNS_QuaTrinhLuanChuyenInfo.NS_QuaTrinhLuanChuyenID = int.Parse(dr[pNS_QuaTrinhLuanChuyenInfo.strNS_QuaTrinhLuanChuyenID].ToString());
pNS_QuaTrinhLuanChuyenInfo.IDNS_GiaoVien = int.Parse("0" + dr[pNS_QuaTrinhLuanChuyenInfo.strIDNS_GiaoVien]);
pNS_QuaTrinhLuanChuyenInfo.SoQuyetDinh = dr[pNS_QuaTrinhLuanChuyenInfo.strSoQuyetDinh].ToString();
if (dr[pNS_QuaTrinhLuanChuyenInfo.strNgayQuyetDinh].ToString() != "")
{
pNS_QuaTrinhLuanChuyenInfo.NgayQuyetDinh = DateTime.Parse(dr[pNS_QuaTrinhLuanChuyenInfo.strNgayQuyetDinh].ToString());
}
if (dr[pNS_QuaTrinhLuanChuyenInfo.strNgayCoHieuLuc].ToString() != "")
{
pNS_QuaTrinhLuanChuyenInfo.NgayCoHieuLuc = DateTime.Parse(dr[pNS_QuaTrinhLuanChuyenInfo.strNgayCoHieuLuc].ToString());
}
pNS_QuaTrinhLuanChuyenInfo.IDNS_LoaiLuanChuyen = int.Parse("0" + dr[pNS_QuaTrinhLuanChuyenInfo.strIDNS_LoaiLuanChuyen]);
pNS_QuaTrinhLuanChuyenInfo.IDNS_DonViCu = int.Parse("0" + dr[pNS_QuaTrinhLuanChuyenInfo.strIDNS_DonViCu]);
pNS_QuaTrinhLuanChuyenInfo.IDNS_DonViMoi = int.Parse("0" + dr[pNS_QuaTrinhLuanChuyenInfo.strIDNS_DonViMoi]);
pNS_QuaTrinhLuanChuyenInfo.NoiDung = dr[pNS_QuaTrinhLuanChuyenInfo.strNoiDung].ToString();
}
public void Delete(NS_QuaTrinhLuanChuyenInfo pNS_QuaTrinhLuanChuyenInfo)
{
oDNS_QuaTrinhLuanChuyen.Delete(pNS_QuaTrinhLuanChuyenInfo);
mErrorMessage = oDNS_QuaTrinhLuanChuyen.ErrorMessages;
mErrorNumber = oDNS_QuaTrinhLuanChuyen.ErrorNumber;
}
public DataTable Get(NS_QuaTrinhLuanChuyenInfo pNS_QuaTrinhLuanChuyenInfo)
{
return(oDNS_QuaTrinhLuanChuyen.Get(pNS_QuaTrinhLuanChuyenInfo));
}