public void ToInfo(ref NS_LoaiPhuCapInfo pNS_LoaiPhuCapInfo, DataRow dr)
{
pNS_LoaiPhuCapInfo.NS_LoaiPhuCapID = int.Parse(dr[pNS_LoaiPhuCapInfo.strNS_LoaiPhuCapID].ToString());
pNS_LoaiPhuCapInfo.KyHieu = dr[pNS_LoaiPhuCapInfo.strKyHieu].ToString();
pNS_LoaiPhuCapInfo.TenLoaiPhuCap = dr[pNS_LoaiPhuCapInfo.strTenLoaiPhuCap].ToString();
pNS_LoaiPhuCapInfo.LaPhuCapChucVu = bool.Parse(dr[pNS_LoaiPhuCapInfo.strLaPhuCapChucVu].ToString());
pNS_LoaiPhuCapInfo.BHXH = bool.Parse(dr[pNS_LoaiPhuCapInfo.strBHXH].ToString());
}
public frmDM_LoaiPhuCap(frmPhuCap _frmPhuCap)
{
InitializeComponent();
cBNS_LoaiPhuCap = new cBNS_LoaiPhuCap();
pNS_LoaiPhuCapInfo = new NS_LoaiPhuCapInfo();
SetControl(false);
ofrmPhuCap = _frmPhuCap;
}
public void ToDataRow(NS_LoaiPhuCapInfo pNS_LoaiPhuCapInfo, ref DataRow dr)
{
dr[pNS_LoaiPhuCapInfo.strNS_LoaiPhuCapID] = pNS_LoaiPhuCapInfo.NS_LoaiPhuCapID;
dr[pNS_LoaiPhuCapInfo.strKyHieu] = pNS_LoaiPhuCapInfo.KyHieu;
dr[pNS_LoaiPhuCapInfo.strTenLoaiPhuCap] = pNS_LoaiPhuCapInfo.TenLoaiPhuCap;
dr[pNS_LoaiPhuCapInfo.strLaPhuCapChucVu] = pNS_LoaiPhuCapInfo.LaPhuCapChucVu;
dr[pNS_LoaiPhuCapInfo.strBHXH] = pNS_LoaiPhuCapInfo.BHXH;
}
public void Delete(NS_LoaiPhuCapInfo pNS_LoaiPhuCapInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_LoaiPhuCapID", SqlDbType.Int, pNS_LoaiPhuCapInfo.NS_LoaiPhuCapID));
RunProcedure("sp_NS_LoaiPhuCap_Delete", colParam);
}
public DataTable Get(NS_LoaiPhuCapInfo pNS_LoaiPhuCapInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@NS_LoaiPhuCapID", SqlDbType.Int, pNS_LoaiPhuCapInfo.NS_LoaiPhuCapID));
return(RunProcedureGet("sp_NS_LoaiPhuCap_Get", colParam));
}
public int Add(NS_LoaiPhuCapInfo pNS_LoaiPhuCapInfo)
{
int ID = 0;
ID = oDNS_LoaiPhuCap.Add(pNS_LoaiPhuCapInfo);
mErrorMessage = oDNS_LoaiPhuCap.ErrorMessages;
mErrorNumber = oDNS_LoaiPhuCap.ErrorNumber;
return(ID);
}
public void Update(NS_LoaiPhuCapInfo pNS_LoaiPhuCapInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KyHieu", SqlDbType.NVarChar, pNS_LoaiPhuCapInfo.KyHieu));
colParam.Add(CreateParam("@TenLoaiPhuCap", SqlDbType.NVarChar, pNS_LoaiPhuCapInfo.TenLoaiPhuCap));
colParam.Add(CreateParam("@LaPhuCapChucVu", SqlDbType.Bit, pNS_LoaiPhuCapInfo.LaPhuCapChucVu));
colParam.Add(CreateParam("@BHXH", SqlDbType.Bit, pNS_LoaiPhuCapInfo.BHXH));
colParam.Add(CreateParam("@NS_LoaiPhuCapID", SqlDbType.Int, pNS_LoaiPhuCapInfo.NS_LoaiPhuCapID));
RunProcedure("sp_NS_LoaiPhuCap_Update", colParam);
}
public int Add(NS_LoaiPhuCapInfo pNS_LoaiPhuCapInfo)
{
ArrayList colParam = new ArrayList();
colParam.Add(CreateParam("@KyHieu", SqlDbType.NVarChar, pNS_LoaiPhuCapInfo.KyHieu));
colParam.Add(CreateParam("@TenLoaiPhuCap", SqlDbType.NVarChar, pNS_LoaiPhuCapInfo.TenLoaiPhuCap));
colParam.Add(CreateParam("@LaPhuCapChucVu", SqlDbType.Bit, pNS_LoaiPhuCapInfo.LaPhuCapChucVu));
colParam.Add(CreateParam("@BHXH", SqlDbType.Bit, pNS_LoaiPhuCapInfo.BHXH));
colParam.Add(CreateParamOut("@ID", SqlDbType.Int));
return((int)RunProcedureOut("sp_NS_LoaiPhuCap_Add", colParam));
}
private void AddBand()
{
BandedGridColumn bgc;
NS_LoaiPhuCapInfo pNS_LoaiPhuCapInfo = new NS_LoaiPhuCapInfo();
cBNS_LoaiPhuCap oBNS_LoaiPhuCap = new cBNS_LoaiPhuCap();
dtLoaiPhuCap = oBNS_LoaiPhuCap.Get(pNS_LoaiPhuCapInfo);
grbPhuCap.Columns.Clear();
if ((dtLoaiPhuCap != null) && (dtLoaiPhuCap.Rows.Count > 0))
{
foreach (DataRow dr in dtLoaiPhuCap.Rows)
{
if ("" + dr["KyHieu"] == "PCGV&YT")
{
IDPhuCapGV_YT = int.Parse(dr["NS_LoaiPhuCapID"].ToString());
}
dtGiaoVien.Columns.Add(dr["NS_LoaiPhuCapID"].ToString(), typeof(double));
bgc = new BandedGridColumn();
grbPhuCap.Columns.Add(bgc);
SetColumnBandCaption(bgc, dr["TenLoaiPhuCap"].ToString(), dr["NS_LoaiPhuCapID"].ToString(), 130, DevExpress.Utils.HorzAlignment.Default, false);
bgc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bgc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
bgc.DisplayFormat.FormatString = "n2";
bgc.AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
bgc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
bgvBangLuong.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgc });
}
bgc = new BandedGridColumn();
grbPhuCap.Columns.Add(bgc);
SetColumnBandCaption(bgc, "Tổng hệ số phụ cấp", "TongHeSoPhuCap", 120, DevExpress.Utils.HorzAlignment.Default, false);
bgc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bgc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
bgc.DisplayFormat.FormatString = "n2";
bgc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
bgvBangLuong.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgc });
bgc = new BandedGridColumn();
grbPhuCap.Columns.Add(bgc);
SetColumnBandCaption(bgc, "Thành tiền", "ThanhTienPhuCap", 120, DevExpress.Utils.HorzAlignment.Default, false);
bgc.OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False;
bgc.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
bgc.DisplayFormat.FormatString = "n2";
bgc.SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
bgvBangLuong.Columns.AddRange(new DevExpress.XtraGrid.Views.BandedGrid.BandedGridColumn[] { bgc });
}
}
public List <NS_LoaiPhuCapInfo> GetList(NS_LoaiPhuCapInfo pNS_LoaiPhuCapInfo)
{
List <NS_LoaiPhuCapInfo> oNS_LoaiPhuCapInfoList = new List <NS_LoaiPhuCapInfo>();
DataTable dtb = Get(pNS_LoaiPhuCapInfo);
if (dtb != null)
{
for (int i = 0; i < dtb.Rows.Count; i++)
{
oNS_LoaiPhuCapInfo = new NS_LoaiPhuCapInfo();
oNS_LoaiPhuCapInfo.NS_LoaiPhuCapID = int.Parse(dtb.Rows[i]["NS_LoaiPhuCapID"].ToString());
oNS_LoaiPhuCapInfo.KyHieu = dtb.Rows[i]["KyHieu"].ToString();
oNS_LoaiPhuCapInfo.TenLoaiPhuCap = dtb.Rows[i]["TenLoaiPhuCap"].ToString();
oNS_LoaiPhuCapInfo.LaPhuCapChucVu = bool.Parse(dtb.Rows[i]["LaPhuCapChucVu"].ToString());
oNS_LoaiPhuCapInfo.BHXH = bool.Parse(dtb.Rows[i]["BHXH"].ToString());
oNS_LoaiPhuCapInfoList.Add(oNS_LoaiPhuCapInfo);
}
}
return(oNS_LoaiPhuCapInfoList);
}
public void Delete(NS_LoaiPhuCapInfo pNS_LoaiPhuCapInfo)
{
oDNS_LoaiPhuCap.Delete(pNS_LoaiPhuCapInfo);
mErrorMessage = oDNS_LoaiPhuCap.ErrorMessages;
mErrorNumber = oDNS_LoaiPhuCap.ErrorNumber;
}
public DataTable Get(NS_LoaiPhuCapInfo pNS_LoaiPhuCapInfo)
{
return(oDNS_LoaiPhuCap.Get(pNS_LoaiPhuCapInfo));
}
