public void Delete(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_SoQuyetDinhID", SqlDbType.Int, pNS_SoQuyetDinhInfo.NS_SoQuyetDinhID));
RunProcedure("sp_NS_SoQuyetDinh_Delete", colParam);
}
public DataTable Get(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_SoQuyetDinhID", SqlDbType.Int, pNS_SoQuyetDinhInfo.NS_SoQuyetDinhID));
return(RunProcedureGet("sp_NS_SoQuyetDinh_Get", colParam));
}
public int Add(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo)
{
int ID = 0;
ID = oDNS_SoQuyetDinh.Add(pNS_SoQuyetDinhInfo);
mErrorMessage = oDNS_SoQuyetDinh.ErrorMessages;
mErrorNumber = oDNS_SoQuyetDinh.ErrorNumber;
return(ID);
}
public void Update(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@SoQuyetDinh", SqlDbType.NVarChar, pNS_SoQuyetDinhInfo.SoQuyetDinh));
colParam.Add(CreateParam("@NgayQuyetDinh", SqlDbType.DateTime, pNS_SoQuyetDinhInfo.NgayQuyetDinh));
colParam.Add(CreateParam("@NS_SoQuyetDinhID", SqlDbType.Int, pNS_SoQuyetDinhInfo.NS_SoQuyetDinhID));
RunProcedure("sp_NS_SoQuyetDinh_Update", colParam);
}
public int Add(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@SoQuyetDinh", SqlDbType.NVarChar, pNS_SoQuyetDinhInfo.SoQuyetDinh));
colParam.Add(CreateParam("@NgayQuyetDinh", SqlDbType.DateTime, pNS_SoQuyetDinhInfo.NgayQuyetDinh));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_NS_SoQuyetDinh_Add", colParam));
}
public frmNangBacChuyenNgach()
{
InitializeComponent();
oBGiaoVien = new cBNS_GiaoVien();
pGiaoVienInfo = new NS_GiaoVienInfo();
pDonViInfo = new NS_DonViInfo();
oBSoQuyetDinh = new cBNS_SoQuyetDinh();
pSoQuyetDinhInfo = new NS_SoQuyetDinhInfo();
oBLuong = new cBNS_Luong();
pNS_LuongInfo = new NS_LuongInfo();
oBNS_NhomNgach = new cBNS_NhomNgach();
pNS_NhomNgachInfo = new NS_NhomNgachInfo();
dtNangBacChuyenNgach = new DataTable();
cmbBacLuong_SelectedIndexChanged(null, null);
CreateTable();
}
public frmLuong()
{
InitializeComponent();
oBGiaoVien = new cBNS_GiaoVien();
pGiaoVienInfo = new NS_GiaoVienInfo();
pDonViInfo = new NS_DonViInfo();
oBSoQuyetDinh = new cBNS_SoQuyetDinh();
pSoQuyetDinhInfo = new NS_SoQuyetDinhInfo();
oBLuong = new cBNS_Luong();
pNS_LuongInfo = new NS_LuongInfo();
oBNS_NhomNgach = new cBNS_NhomNgach();
pNS_NhomNgachInfo = new NS_NhomNgachInfo();
SetButton(false);
btnThem.Enabled = true;
SetControl(true);
dtpDenNgay.Enabled = false;
btnLuu.Enabled = false;
cmbBacLuong_SelectedIndexChanged(null, null);
}
public List <NS_SoQuyetDinhInfo> GetList(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo)
{
List <NS_SoQuyetDinhInfo> oNS_SoQuyetDinhInfoList = new List <NS_SoQuyetDinhInfo>();
DataTable dtb = Get(pNS_SoQuyetDinhInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oNS_SoQuyetDinhInfo = new NS_SoQuyetDinhInfo();
oNS_SoQuyetDinhInfo.NS_SoQuyetDinhID = int.Parse(dtb.Rows[i]["NS_SoQuyetDinhID"].ToString());
oNS_SoQuyetDinhInfo.SoQuyetDinh = dtb.Rows[i]["SoQuyetDinh"].ToString();
oNS_SoQuyetDinhInfo.NgayQuyetDinh = DateTime.Parse(dtb.Rows[i]["NgayQuyetDinh"].ToString());
oNS_SoQuyetDinhInfoList.Add(oNS_SoQuyetDinhInfo);
}
}
return(oNS_SoQuyetDinhInfoList);
}
public void ToInfo(ref NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo, DataRow dr)
{
pNS_SoQuyetDinhInfo.NS_SoQuyetDinhID = int.Parse(dr[pNS_SoQuyetDinhInfo.strNS_SoQuyetDinhID].ToString());
pNS_SoQuyetDinhInfo.SoQuyetDinh = dr[pNS_SoQuyetDinhInfo.strSoQuyetDinh].ToString();
pNS_SoQuyetDinhInfo.NgayQuyetDinh = DateTime.Parse(dr[pNS_SoQuyetDinhInfo.strNgayQuyetDinh].ToString());
}
public void ToDataRow(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo, ref DataRow dr)
{
dr[pNS_SoQuyetDinhInfo.strNS_SoQuyetDinhID] = pNS_SoQuyetDinhInfo.NS_SoQuyetDinhID;
dr[pNS_SoQuyetDinhInfo.strSoQuyetDinh] = pNS_SoQuyetDinhInfo.SoQuyetDinh;
dr[pNS_SoQuyetDinhInfo.strNgayQuyetDinh] = pNS_SoQuyetDinhInfo.NgayQuyetDinh;
}
public void Delete(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo)
{
oDNS_SoQuyetDinh.Delete(pNS_SoQuyetDinhInfo);
mErrorMessage = oDNS_SoQuyetDinh.ErrorMessages;
mErrorNumber = oDNS_SoQuyetDinh.ErrorNumber;
}
public DataTable Get(NS_SoQuyetDinhInfo pNS_SoQuyetDinhInfo)
{
return(oDNS_SoQuyetDinh.Get(pNS_SoQuyetDinhInfo));
}
