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;
}
