public void BatTatRadio(DODieuChinhLuong dto, int HinhThuc, string IsThuViec) { if (HinhThuc == 0) { rdToanThoiGian.Checked = true; if (IsThuViec == "Y") { rdThuViec.Checked = true; clLuongTV.Value = dto.MUC_LUONG; clPhanTram.Value = dto.PHAN_TRAM; } else { rdChinhThuc.Checked = true; clLuongCT.Value = dto.MUC_LUONG; } } else if (HinhThuc == 1) { rdBanThoiGian.Checked = true; clLuongBTG.Value = dto.MUC_LUONG; } else if (HinhThuc == 2) { rdKhongLuong.Checked = true; } else { rdTroCap.Checked = true; clLuongTC.Value = dto.MUC_LUONG; } }
public bool CapNhatDong(DODieuChinhLuong dto) { bool Kq = false; try { //if (IsTonTai(dto.NV_ID, dto.TU_NGAY) == null) //{ // HelpMsgBox.ShowNotificationMessage("Điều chỉnh lương của nhân viên này chưa có trong database"); // return false; //} //Sql string Updatesql = ""; if (dto.HINH_THUC == "0") //Toan thoi gian { if (dto.IS_THU_VIEC == "Y") Updatesql = "Update DIEU_CHINH_LUONG set HINH_THUC = @HINH_THUC,IS_THU_VIEC = 'Y',PHAN_TRAM = @PHAN_TRAM,MUC_LUONG = @MUC_LUONG where NV_ID = @NV_ID and TU_NGAY = @TU_NGAY"; else Updatesql = "Update DIEU_CHINH_LUONG set HINH_THUC = @HINH_THUC,IS_THU_VIEC = 'N',MUC_LUONG = @MUC_LUONG,PHAN_TRAM=null where NV_ID = @NV_ID and TU_NGAY = @TU_NGAY"; } else if (dto.HINH_THUC == "1") //Ban thoi gian { Updatesql = "Update DIEU_CHINH_LUONG set HINH_THUC = @HINH_THUC,MUC_LUONG = @MUC_LUONG where NV_ID = @NV_ID and TU_NGAY = @TU_NGAY"; } else if (dto.HINH_THUC == "3") //Tro cap Updatesql = " Update DIEU_CHINH_LUONG set HINH_THUC = @HINH_THUC,MUC_LUONG = @MUC_LUONG where NV_ID = @NV_ID and TU_NGAY = @TU_NGAY"; else //Khong luong Updatesql = " Update DIEU_CHINH_LUONG set HINH_THUC = @HINH_THUC, MUC_LUONG = null ,PHAN_TRAM = null where NV_ID = @NV_ID and TU_NGAY = @TU_NGAY"; //Params DatabaseFB db = HelpDB.getDatabase(); System.Data.Common.DbCommand cmd = db.GetSQLStringCommand( Updatesql); db.AddInParameter(cmd, "@NV_ID", DbType.Int32, dto.NV_ID); db.AddInParameter(cmd, "@TU_NGAY", DbType.DateTime, dto.TU_NGAY); db.AddInParameter(cmd, "@HINH_THUC", DbType.String, dto.HINH_THUC); if (dto.HINH_THUC == "0") //Toan thoi gian { if (dto.IS_THU_VIEC == "Y") //Thu viec { db.AddInParameter(cmd, "@PHAN_TRAM", DbType.Int32, dto.PHAN_TRAM); } db.AddInParameter(cmd, "@MUC_LUONG", DbType.Decimal, dto.MUC_LUONG); } else if (dto.HINH_THUC == "1" || dto.HINH_THUC=="3") //Ban thoi gian,Tro cap { db.AddInParameter(cmd, "@MUC_LUONG", DbType.Decimal, dto.MUC_LUONG); } if (db.ExecuteNonQuery(cmd) > 0) Kq = true; } catch (Exception ex) { PLException.AddException(ex); } return Kq; }
public frmThangBangLuongQL() { InitializeComponent(); IDField = "ID"; DisplayField = "NAME"; that = new PhieuQuanLy10Fix(this);//(this,typeof(frmThangBangLuongQL).FullName,this.UpdateRow()); this.splitContainerControl1.SplitterPosition = 0; doLuong = new DODieuChinhLuong(); this.Text = "Thang bảng lương"; }
private void btLuu_Click(object sender, EventArgs e) { DODieuChinhLuong dto = new DODieuChinhLuong(); dto.NV_ID = TenNhanVien._getSelectedID(); dto.IS_THU_VIEC = "N"; if (this.IsValidate()) { dto.TU_NGAY = DateTuNgay.DateTime; dto.HINH_THUC = getHinhThuc(); dto.IS_THU_VIEC = (rdChinhThuc.Checked) ? "N" : "Y"; dto.PHAN_TRAM = (rdThuViec.Checked) ? (int)clPhanTram.Value : 1; dto.MUC_LUONG = getLuongCoBan(); try { if(this._IsNangLuong) { DADieuChinhLuong.Ins.ThemDong(dto); HelpXtraForm.CloseFormNoConfirm(this); return; } switch(this.IsAdd) { case true : if (DADieuChinhLuong.Ins.ThemDong(dto))HelpXtraForm.CloseFormNoConfirm(this); break; case false : if (DADieuChinhLuong.Ins.CapNhatDong(dto)) { if (_AfterUpdateSuccessfully != null) _AfterUpdateSuccessfully(dto); HelpXtraForm.CloseFormNoConfirm(this); } break; } } catch (Exception ex) { PLException.AddException(ex); } } }
public void InitData() { switch (this.IsAdd) { case true: rdToanThoiGian.Checked = true; rdChinhThuc.Checked = true; HelpDate.SetDateEdit(this.DateTuNgay, HelpDB.getDatabase().GetSystemCurrentDateTime()); break; case null: case false : TenNhanVien._setSelectedID(IDKey); DateTuNgay.DateTime = this.TuNgay; DataSet ThongTin = DADieuChinhLuong.Ins.IsTonTai(IDKey, this.TuNgay); dto = new DODieuChinhLuong(); dto.HINH_THUC = ThongTin.Tables[0].Rows[0]["HINH_THUC"].ToString(); dto.NV_ID = IDKey; dto.TU_NGAY = this.TuNgay; dto.IS_THU_VIEC = ThongTin.Tables[0].Rows[0]["IS_THU_VIEC"].ToString(); dto.PHAN_TRAM = (int) PhanTram_ThuViec(ThongTin.Tables[0].Rows[0]["PHAN_TRAM"], dto.IS_THU_VIEC); if (isNumber(ThongTin.Tables[0].Rows[0]["MUC_LUONG"].ToString())) dto.MUC_LUONG = HelpNumber.ParseDecimal(ThongTin.Tables[0].Rows[0]["MUC_LUONG"].ToString()); BatTatRadio(dto, int.Parse(dto.HINH_THUC), dto.IS_THU_VIEC); break; } //if (this._IsNangLuong) //HelpDate.SetDateEdit(this.DateTuNgay, HelpDB.getDatabase().GetSystemCurrentDateTime()); }
void obj__AfterUpdateSuccessfully(DODieuChinhLuong doLuong) { this.doLuong = doLuong; }
public override void ShowUpdateForm(long id) { IsUpdate = true; doLuong = null; DateTime TuNgay = (DateTime)gridViewMaster.GetDataRow(gridViewMaster.FocusedRowHandle)["TU_NGAY"]; frmDieuChinhLuong obj = new frmDieuChinhLuong(id, TuNgay, false,false); obj._AfterUpdateSuccessfully += new frmDieuChinhLuong.AfterUpdateSuccessfully(obj__AfterUpdateSuccessfully); HelpProtocolForm.ShowModalDialog(this, obj); }
public bool ThemDong(DODieuChinhLuong dto) { bool Kq = false; try { if (IsTonTai(dto.NV_ID, dto.TU_NGAY) != null) { HelpMsgBox.ShowNotificationMessage("Điều chỉnh lương của nhân viên \nnày đã có trong database"); return false; } string Insertsql = ""; if (dto.HINH_THUC == "0") //Toan thoi gian { if (dto.IS_THU_VIEC == "Y") Insertsql = "insert into DIEU_CHINH_LUONG(NV_ID,TU_NGAY,HINH_THUC,IS_THU_VIEC,PHAN_TRAM,MUC_LUONG)" + "values(@NV_ID,@TU_NGAY,@HINH_THUC,'Y',@PHAN_TRAM,@MUC_LUONG)"; else Insertsql = "insert into DIEU_CHINH_LUONG(NV_ID,TU_NGAY,HINH_THUC,IS_THU_VIEC,MUC_LUONG)" + "values(@NV_ID,@TU_NGAY,@HINH_THUC,'N',@MUC_LUONG)"; } else if (dto.HINH_THUC == "1") //Ban thoi gian { Insertsql = "insert into DIEU_CHINH_LUONG(NV_ID,TU_NGAY,HINH_THUC,MUC_LUONG)" + "values(@NV_ID,@TU_NGAY,@HINH_THUC,@MUC_LUONG)"; }else if (dto.HINH_THUC == "3") //Tro cap Insertsql = "insert into DIEU_CHINH_LUONG(NV_ID,TU_NGAY,HINH_THUC,MUC_LUONG) " + "values(@NV_ID,@TU_NGAY,@HINH_THUC,@MUC_LUONG)"; else //Khong luong Insertsql = "insert into DIEU_CHINH_LUONG(NV_ID,TU_NGAY,HINH_THUC) " + "values (@NV_ID,@TU_NGAY,@HINH_THUC)"; //Params DatabaseFB db = HelpDB.getDatabase(); System.Data.Common.DbCommand cmd = db.GetSQLStringCommand(Insertsql); db.AddInParameter(cmd, "@NV_ID", DbType.Int32, dto.NV_ID); db.AddInParameter(cmd, "@TU_NGAY", DbType.DateTime, dto.TU_NGAY); db.AddInParameter(cmd, "@HINH_THUC", DbType.String, dto.HINH_THUC); if (dto.HINH_THUC == "0") //Toan thoi gian { if (dto.IS_THU_VIEC=="Y") //Thu viec { db.AddInParameter(cmd, "@PHAN_TRAM", DbType.Int32, dto.PHAN_TRAM); } db.AddInParameter(cmd, "@MUC_LUONG", DbType.Decimal, dto.MUC_LUONG); } else if (dto.HINH_THUC == "1") //Ban thoi gian { db.AddInParameter(cmd, "@MUC_LUONG", DbType.Decimal, dto.MUC_LUONG); }else if (dto.HINH_THUC == "3") //Tro cap db.AddInParameter(cmd, "@MUC_LUONG", DbType.Decimal, dto.MUC_LUONG); if (db.ExecuteNonQuery(cmd) > 0) Kq = true; } catch (Exception ex) { PLException.AddException(ex); } return Kq; }