public void ToInfo(ref NS_NhomNgachInfo pNS_NhomNgachInfo, DataRow dr)
{
pNS_NhomNgachInfo.NS_NhomNgachID = int.Parse(dr[pNS_NhomNgachInfo.strNS_NhomNgachID].ToString());
pNS_NhomNgachInfo.KyHieu = dr[pNS_NhomNgachInfo.strKyHieu].ToString();
pNS_NhomNgachInfo.TenNhomNgach = dr[pNS_NhomNgachInfo.strTenNhomNgach].ToString();
pNS_NhomNgachInfo.LoaiCongChuc = dr[pNS_NhomNgachInfo.strLoaiCongChuc].ToString();
pNS_NhomNgachInfo.IDNS_LinhVucCongTac = int.Parse("0" + dr[pNS_NhomNgachInfo.strIDNS_LinhVucCongTac]);
pNS_NhomNgachInfo.MoTa = dr[pNS_NhomNgachInfo.strMoTa].ToString();
pNS_NhomNgachInfo.SoNamNangBac = double.Parse(dr[pNS_NhomNgachInfo.strSoNamNangBac].ToString());
pNS_NhomNgachInfo.BacCaoNhat = int.Parse(dr[pNS_NhomNgachInfo.strBacCaoNhat].ToString());
pNS_NhomNgachInfo.HeSoLuongBac_1 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_1].ToString());
pNS_NhomNgachInfo.HeSoLuongBac_2 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_2].ToString());
pNS_NhomNgachInfo.HeSoLuongBac_3 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_3].ToString());
pNS_NhomNgachInfo.HeSoLuongBac_4 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_4].ToString());
pNS_NhomNgachInfo.HeSoLuongBac_5 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_5].ToString());
pNS_NhomNgachInfo.HeSoLuongBac_6 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_6].ToString());
pNS_NhomNgachInfo.HeSoLuongBac_7 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_7].ToString());
pNS_NhomNgachInfo.HeSoLuongBac_8 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_8].ToString());
pNS_NhomNgachInfo.HeSoLuongBac_9 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_9].ToString());
pNS_NhomNgachInfo.HeSoLuongBac_10 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_10].ToString());
pNS_NhomNgachInfo.HeSoLuongBac_11 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_11].ToString());
pNS_NhomNgachInfo.HeSoLuongBac_12 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_12].ToString());
pNS_NhomNgachInfo.HeSoLuongBac_13 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_13].ToString());
pNS_NhomNgachInfo.HeSoLuongBac_14 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_14].ToString());
pNS_NhomNgachInfo.HeSoLuongBac_15 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_15].ToString());
pNS_NhomNgachInfo.HeSoLuongBac_16 = double.Parse(dr[pNS_NhomNgachInfo.strHeSoLuongBac_16].ToString());
}
public void Update(NS_NhomNgachInfo pNS_NhomNgachInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KyHieu", SqlDbType.NVarChar, pNS_NhomNgachInfo.KyHieu));
colParam.Add(CreateParam("@TenNhomNgach", SqlDbType.NVarChar, pNS_NhomNgachInfo.TenNhomNgach));
colParam.Add(CreateParam("@LoaiCongChuc", SqlDbType.NVarChar, pNS_NhomNgachInfo.LoaiCongChuc));
colParam.Add(CreateParam("@IDNS_LinhVucCongTac", SqlDbType.Int, pNS_NhomNgachInfo.IDNS_LinhVucCongTac));
colParam.Add(CreateParam("@MoTa", SqlDbType.NVarChar, pNS_NhomNgachInfo.MoTa));
colParam.Add(CreateParam("@SoNamNangBac", SqlDbType.Float, pNS_NhomNgachInfo.SoNamNangBac));
colParam.Add(CreateParam("@BacCaoNhat", SqlDbType.Int, pNS_NhomNgachInfo.BacCaoNhat));
colParam.Add(CreateParam("@HeSoLuongBac_1", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_1));
colParam.Add(CreateParam("@HeSoLuongBac_2", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_2));
colParam.Add(CreateParam("@HeSoLuongBac_3", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_3));
colParam.Add(CreateParam("@HeSoLuongBac_4", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_4));
colParam.Add(CreateParam("@HeSoLuongBac_5", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_5));
colParam.Add(CreateParam("@HeSoLuongBac_6", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_6));
colParam.Add(CreateParam("@HeSoLuongBac_7", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_7));
colParam.Add(CreateParam("@HeSoLuongBac_8", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_8));
colParam.Add(CreateParam("@HeSoLuongBac_9", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_9));
colParam.Add(CreateParam("@HeSoLuongBac_10", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_10));
colParam.Add(CreateParam("@HeSoLuongBac_11", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_11));
colParam.Add(CreateParam("@HeSoLuongBac_12", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_12));
colParam.Add(CreateParam("@HeSoLuongBac_13", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_13));
colParam.Add(CreateParam("@HeSoLuongBac_14", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_14));
colParam.Add(CreateParam("@HeSoLuongBac_15", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_15));
colParam.Add(CreateParam("@HeSoLuongBac_16", SqlDbType.Float, pNS_NhomNgachInfo.HeSoLuongBac_16));
colParam.Add(CreateParam("@NS_NhomNgachID", SqlDbType.Int, pNS_NhomNgachInfo.NS_NhomNgachID));
RunProcedure("sp_NS_NhomNgach_Update", colParam);
}
//public int Add(NS_NhomNgachInfo pNS_NhomNgachInfo)
//{
// int ID = 0;
// var client = new UnimOsServiceClient();
// ID = client.cDNS_NhomNgach_Add(GlobalVar.MaXacThuc, pNS_NhomNgachInfo);
// client.Close();
// mErrorMessage = oDNS_NhomNgach.ErrorMessages;
// mErrorNumber = oDNS_NhomNgach.ErrorNumber;
// return ID;
//}
//public void Update(NS_NhomNgachInfo pNS_NhomNgachInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDNS_NhomNgach_Update(GlobalVar.MaXacThuc, pNS_NhomNgachInfo);
// client.Close();
// mErrorMessage = oDNS_NhomNgach.ErrorMessages;
// mErrorNumber = oDNS_NhomNgach.ErrorNumber;
//}
//public void Delete(NS_NhomNgachInfo pNS_NhomNgachInfo)
//{
// var client = new UnimOsServiceClient();
// client.cDNS_NhomNgach_Delete(GlobalVar.MaXacThuc, pNS_NhomNgachInfo);
// client.Close();
// mErrorMessage = oDNS_NhomNgach.ErrorMessages;
// mErrorNumber = oDNS_NhomNgach.ErrorNumber;
//}
//public List<NS_NhomNgachInfo> GetList(NS_NhomNgachInfo pNS_NhomNgachInfo)
//{
// List<NS_NhomNgachInfo> oNS_NhomNgachInfoList = new List<NS_NhomNgachInfo>();
// DataTable dtb = Get(pNS_NhomNgachInfo);
// if (dtb != null)
// {
// for (int i = 0; i < dtb.Rows.Count; i++)
// {
// oNS_NhomNgachInfo = new NS_NhomNgachInfo();
// oNS_NhomNgachInfo.NS_NhomNgachID = int.Parse(dtb.Rows[i]["NS_NhomNgachID"].ToString());
// oNS_NhomNgachInfo.KyHieu = dtb.Rows[i]["KyHieu"].ToString();
// oNS_NhomNgachInfo.TenNhomNgach = dtb.Rows[i]["TenNhomNgach"].ToString();
// oNS_NhomNgachInfo.LoaiCongChuc = dtb.Rows[i]["LoaiCongChuc"].ToString();
// oNS_NhomNgachInfo.MoTa = dtb.Rows[i]["MoTa"].ToString();
// oNS_NhomNgachInfo.SoNamNangBac = double.Parse(dtb.Rows[i]["SoNamNangBac"].ToString());
// oNS_NhomNgachInfo.BacCaoNhat = int.Parse(dtb.Rows[i]["BacCaoNhat"].ToString());
// oNS_NhomNgachInfo.HeSoLuongBac_1 = double.Parse(dtb.Rows[i]["HeSoLuongBac_1"].ToString());
// oNS_NhomNgachInfo.HeSoLuongBac_2 = double.Parse(dtb.Rows[i]["HeSoLuongBac_2"].ToString());
// oNS_NhomNgachInfo.HeSoLuongBac_3 = double.Parse(dtb.Rows[i]["HeSoLuongBac_3"].ToString());
// oNS_NhomNgachInfo.HeSoLuongBac_4 = double.Parse(dtb.Rows[i]["HeSoLuongBac_4"].ToString());
// oNS_NhomNgachInfo.HeSoLuongBac_5 = double.Parse(dtb.Rows[i]["HeSoLuongBac_5"].ToString());
// oNS_NhomNgachInfo.HeSoLuongBac_6 = double.Parse(dtb.Rows[i]["HeSoLuongBac_6"].ToString());
// oNS_NhomNgachInfo.HeSoLuongBac_7 = double.Parse(dtb.Rows[i]["HeSoLuongBac_7"].ToString());
// oNS_NhomNgachInfo.HeSoLuongBac_8 = double.Parse(dtb.Rows[i]["HeSoLuongBac_8"].ToString());
// oNS_NhomNgachInfo.HeSoLuongBac_9 = double.Parse(dtb.Rows[i]["HeSoLuongBac_9"].ToString());
// oNS_NhomNgachInfo.HeSoLuongBac_10 = double.Parse(dtb.Rows[i]["HeSoLuongBac_10"].ToString());
// oNS_NhomNgachInfo.HeSoLuongBac_11 = double.Parse(dtb.Rows[i]["HeSoLuongBac_11"].ToString());
// oNS_NhomNgachInfo.HeSoLuongBac_12 = double.Parse(dtb.Rows[i]["HeSoLuongBac_12"].ToString());
// oNS_NhomNgachInfo.HeSoLuongBac_13 = double.Parse(dtb.Rows[i]["HeSoLuongBac_13"].ToString());
// oNS_NhomNgachInfo.HeSoLuongBac_14 = double.Parse(dtb.Rows[i]["HeSoLuongBac_14"].ToString());
// oNS_NhomNgachInfo.HeSoLuongBac_15 = double.Parse(dtb.Rows[i]["HeSoLuongBac_15"].ToString());
// oNS_NhomNgachInfo.HeSoLuongBac_16 = double.Parse(dtb.Rows[i]["HeSoLuongBac_16"].ToString());
// oNS_NhomNgachInfoList.Add(oNS_NhomNgachInfo);
// }
// }
// return oNS_NhomNgachInfoList;
//}
public void ToDataRow(NS_NhomNgachInfo pNS_NhomNgachInfo, ref DataRow dr)
{
dr[pNS_NhomNgachInfo.strNS_NhomNgachID] = pNS_NhomNgachInfo.NS_NhomNgachID;
dr[pNS_NhomNgachInfo.strKyHieu] = pNS_NhomNgachInfo.KyHieu;
dr[pNS_NhomNgachInfo.strTenNhomNgach] = pNS_NhomNgachInfo.TenNhomNgach;
dr[pNS_NhomNgachInfo.strLoaiCongChuc] = pNS_NhomNgachInfo.LoaiCongChuc;
dr[pNS_NhomNgachInfo.strIDNS_LinhVucCongTac] = pNS_NhomNgachInfo.IDNS_LinhVucCongTac;
dr[pNS_NhomNgachInfo.strMoTa] = pNS_NhomNgachInfo.MoTa;
dr[pNS_NhomNgachInfo.strSoNamNangBac] = pNS_NhomNgachInfo.SoNamNangBac;
dr[pNS_NhomNgachInfo.strBacCaoNhat] = pNS_NhomNgachInfo.BacCaoNhat;
dr[pNS_NhomNgachInfo.strHeSoLuongBac_1] = pNS_NhomNgachInfo.HeSoLuongBac_1;
dr[pNS_NhomNgachInfo.strHeSoLuongBac_2] = pNS_NhomNgachInfo.HeSoLuongBac_2;
dr[pNS_NhomNgachInfo.strHeSoLuongBac_3] = pNS_NhomNgachInfo.HeSoLuongBac_3;
dr[pNS_NhomNgachInfo.strHeSoLuongBac_4] = pNS_NhomNgachInfo.HeSoLuongBac_4;
dr[pNS_NhomNgachInfo.strHeSoLuongBac_5] = pNS_NhomNgachInfo.HeSoLuongBac_5;
dr[pNS_NhomNgachInfo.strHeSoLuongBac_6] = pNS_NhomNgachInfo.HeSoLuongBac_6;
dr[pNS_NhomNgachInfo.strHeSoLuongBac_7] = pNS_NhomNgachInfo.HeSoLuongBac_7;
dr[pNS_NhomNgachInfo.strHeSoLuongBac_8] = pNS_NhomNgachInfo.HeSoLuongBac_8;
dr[pNS_NhomNgachInfo.strHeSoLuongBac_9] = pNS_NhomNgachInfo.HeSoLuongBac_9;
dr[pNS_NhomNgachInfo.strHeSoLuongBac_10] = pNS_NhomNgachInfo.HeSoLuongBac_10;
dr[pNS_NhomNgachInfo.strHeSoLuongBac_11] = pNS_NhomNgachInfo.HeSoLuongBac_11;
dr[pNS_NhomNgachInfo.strHeSoLuongBac_12] = pNS_NhomNgachInfo.HeSoLuongBac_12;
dr[pNS_NhomNgachInfo.strHeSoLuongBac_13] = pNS_NhomNgachInfo.HeSoLuongBac_13;
dr[pNS_NhomNgachInfo.strHeSoLuongBac_14] = pNS_NhomNgachInfo.HeSoLuongBac_14;
dr[pNS_NhomNgachInfo.strHeSoLuongBac_15] = pNS_NhomNgachInfo.HeSoLuongBac_15;
dr[pNS_NhomNgachInfo.strHeSoLuongBac_16] = pNS_NhomNgachInfo.HeSoLuongBac_16;
}
public void Delete(NS_NhomNgachInfo pNS_NhomNgachInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_NhomNgachID", SqlDbType.Int, pNS_NhomNgachInfo.NS_NhomNgachID));
RunProcedure("sp_NS_NhomNgach_Delete", colParam);
}
public DataTable Get(NS_NhomNgachInfo pNS_NhomNgachInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_NhomNgachID", SqlDbType.Int, pNS_NhomNgachInfo.NS_NhomNgachID));
return(RunProcedureGet("sp_NS_NhomNgach_Get", colParam));
}
public int Add(NS_NhomNgachInfo pNS_NhomNgachInfo)
{
int ID = 0;
ID = oDNS_NhomNgach.Add(pNS_NhomNgachInfo);
mErrorMessage = oDNS_NhomNgach.ErrorMessages;
mErrorNumber = oDNS_NhomNgach.ErrorNumber;
return(ID);
}
public frmDM_NhomNgach(frmDM_NgachCongChuc _frmDM_NgachCongChuc)
{
InitializeComponent();
oBNS_NhomNgach = new cBNS_NhomNgach();
pNS_NhomNgachInfo = new NS_NhomNgachInfo();
cmbLinhVucCongTac.Properties.DataSource = (new cBNS_LinhVucCongTac()).Get(new NS_LinhVucCongTacInfo());
SetControl(false);
SetTxtRerdOnly(true);
ofrmDM_NgachCongChuc = _frmDM_NgachCongChuc;
}
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_NhomNgachInfo> GetList(NS_NhomNgachInfo pNS_NhomNgachInfo)
{
List <NS_NhomNgachInfo> oNS_NhomNgachInfoList = new List <NS_NhomNgachInfo>();
DataTable dtb = Get(pNS_NhomNgachInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oNS_NhomNgachInfo = new NS_NhomNgachInfo();
oNS_NhomNgachInfo.NS_NhomNgachID = int.Parse(dtb.Rows[i]["NS_NhomNgachID"].ToString());
oNS_NhomNgachInfo.KyHieu = dtb.Rows[i]["KyHieu"].ToString();
oNS_NhomNgachInfo.TenNhomNgach = dtb.Rows[i]["TenNhomNgach"].ToString();
oNS_NhomNgachInfo.LoaiCongChuc = dtb.Rows[i]["LoaiCongChuc"].ToString();
oNS_NhomNgachInfo.MoTa = dtb.Rows[i]["MoTa"].ToString();
oNS_NhomNgachInfo.SoNamNangBac = double.Parse(dtb.Rows[i]["SoNamNangBac"].ToString());
oNS_NhomNgachInfo.BacCaoNhat = int.Parse(dtb.Rows[i]["BacCaoNhat"].ToString());
oNS_NhomNgachInfo.HeSoLuongBac_1 = double.Parse(dtb.Rows[i]["HeSoLuongBac_1"].ToString());
oNS_NhomNgachInfo.HeSoLuongBac_2 = double.Parse(dtb.Rows[i]["HeSoLuongBac_2"].ToString());
oNS_NhomNgachInfo.HeSoLuongBac_3 = double.Parse(dtb.Rows[i]["HeSoLuongBac_3"].ToString());
oNS_NhomNgachInfo.HeSoLuongBac_4 = double.Parse(dtb.Rows[i]["HeSoLuongBac_4"].ToString());
oNS_NhomNgachInfo.HeSoLuongBac_5 = double.Parse(dtb.Rows[i]["HeSoLuongBac_5"].ToString());
oNS_NhomNgachInfo.HeSoLuongBac_6 = double.Parse(dtb.Rows[i]["HeSoLuongBac_6"].ToString());
oNS_NhomNgachInfo.HeSoLuongBac_7 = double.Parse(dtb.Rows[i]["HeSoLuongBac_7"].ToString());
oNS_NhomNgachInfo.HeSoLuongBac_8 = double.Parse(dtb.Rows[i]["HeSoLuongBac_8"].ToString());
oNS_NhomNgachInfo.HeSoLuongBac_9 = double.Parse(dtb.Rows[i]["HeSoLuongBac_9"].ToString());
oNS_NhomNgachInfo.HeSoLuongBac_10 = double.Parse(dtb.Rows[i]["HeSoLuongBac_10"].ToString());
oNS_NhomNgachInfo.HeSoLuongBac_11 = double.Parse(dtb.Rows[i]["HeSoLuongBac_11"].ToString());
oNS_NhomNgachInfo.HeSoLuongBac_12 = double.Parse(dtb.Rows[i]["HeSoLuongBac_12"].ToString());
oNS_NhomNgachInfo.HeSoLuongBac_13 = double.Parse(dtb.Rows[i]["HeSoLuongBac_13"].ToString());
oNS_NhomNgachInfo.HeSoLuongBac_14 = double.Parse(dtb.Rows[i]["HeSoLuongBac_14"].ToString());
oNS_NhomNgachInfo.HeSoLuongBac_15 = double.Parse(dtb.Rows[i]["HeSoLuongBac_15"].ToString());
oNS_NhomNgachInfo.HeSoLuongBac_16 = double.Parse(dtb.Rows[i]["HeSoLuongBac_16"].ToString());
oNS_NhomNgachInfoList.Add(oNS_NhomNgachInfo);
}
}
return(oNS_NhomNgachInfoList);
}
public void Delete(NS_NhomNgachInfo pNS_NhomNgachInfo)
{
oDNS_NhomNgach.Delete(pNS_NhomNgachInfo);
mErrorMessage = oDNS_NhomNgach.ErrorMessages;
mErrorNumber = oDNS_NhomNgach.ErrorNumber;
}
public DataTable Get(NS_NhomNgachInfo pNS_NhomNgachInfo)
{
return(oDNS_NhomNgach.Get(pNS_NhomNgachInfo));
}