public Boolean SuaLuongNV(LuongNV tv)
{
SqlConnection conn = getConnection();
conn.Open();
try
{
string sqlSua = "DECLARE @dem int select @dem = COUNT(MaNV) FROM BangCongNV WHERE MaNV = @MaNV IF @dem != 0 UPDATE BangCongNV " +
"SET Thuong = @Thuong ,KyLuat = @KyLuat ,Thang = @Thang , Nam = @Nam , " +
"SoGioLamThem = @SoGioLamThem , SoNgayCong = @SoNgayCong , Luong = @TongLuong WHERE MaNV = @MaNV else raiserror('', 16, 1)";
SqlCommand cmd = new SqlCommand(sqlSua, conn);
cmd.Parameters.AddWithValue("MaNV", tv.MaNV);
cmd.Parameters.AddWithValue("Thuong", tv.Thuong);
cmd.Parameters.AddWithValue("KyLuat", tv.KyLuat);
cmd.Parameters.AddWithValue("Thang", tv.Thang);
cmd.Parameters.AddWithValue("Nam", tv.Nam);
cmd.Parameters.AddWithValue("SoGioLamThem", tv.SoGioLamThem);
cmd.Parameters.AddWithValue("SoNgayCong", tv.SoNgayCong);
cmd.Parameters.AddWithValue("TongLuong", tv.TongLuong);
cmd.ExecuteNonQuery();
}
catch (Exception)
{
return(false);
}
finally
{
conn.Close();
}
return(true);
}
public Boolean ThemLuongNV(LuongNV tv)
{
SqlConnection conn = getConnection();
conn.Open();
try
{
string sqlThem = "INSERT INTO BangCongNV VALUES(@MaPB , @MaNV , @MaLuong , @LCB , @PhuCap , @Thuong , @KyLuat , @Thang ,@Nam ,@SoGioLamThem ,@SoNgayCong ,@TongLuong)";
SqlCommand cmd = new SqlCommand(sqlThem, conn);
cmd.Parameters.AddWithValue("MaPB", tv.MaPB);
cmd.Parameters.AddWithValue("MaNV", tv.MaNV);
cmd.Parameters.AddWithValue("MaLuong", tv.MaLuong);
cmd.Parameters.AddWithValue("LCB", tv.LCB);
cmd.Parameters.AddWithValue("PhuCap", tv.PhuCap);
cmd.Parameters.AddWithValue("Thuong", tv.Thuong);
cmd.Parameters.AddWithValue("KyLuat", tv.KyLuat);
cmd.Parameters.AddWithValue("Thang", tv.Thang);
cmd.Parameters.AddWithValue("Nam", tv.Nam);
cmd.Parameters.AddWithValue("SoGioLamThem", tv.SoGioLamThem);
cmd.Parameters.AddWithValue("SoNgayCong", tv.SoNgayCong);
cmd.Parameters.AddWithValue("TongLuong", tv.TongLuong);
cmd.ExecuteNonQuery();
}
catch (Exception)
{
return(false);
}
finally
{
conn.Close();
}
return(true);
}
public void Edit_ChamCong()
{
bool t = false;
List <LuongNV> luongNVs = LuongNVDAO.Instance.GetLuongs();
foreach (LuongNV data in luongNVs)
{
for (int i = 0; i < lv_nv.SelectedItems.Count; i++)
{
if (data.IDChamCong1 == lv_nv.SelectedItems[i].SubItems[0].Text)
{
t = LuongNVDAO.Instance.Update(data.IDChamCong1, tb_sc.Text);
if (t)
{
LuongNV luong = new LuongNV();
lv_nv.Items.Clear();
loadNhanVien();
lb_sc.Text = tb_sc.Text;
lb_l.Text = data.Luong1.ToString();
// lb_l.Text = lv_nv.SelectedItems[i].SubItems[5].Text
; MessageBox.Show("Sửa thành công");
}
}
}
}
}
public void Show()
{
Console.WriteLine("TenNV\tLuong T1 T2 T3 T4 T5 T6 T7 T8 T9 T10 T11 T12");
for (int i = 0; i < MangNV.Count; i++)
{
NhanVien nv = MangNV[i];
Console.Write("{0}\t\t", nv.TenNV);
for (int j = i * 12; j < (i + 1) * 12; j++)
{
LuongNV lgNv = MangLuongNV[j];
Console.Write(String.Format("{0:#.##} ", lgNv.LuongNhVien));
}
Console.WriteLine();
}
Console.WriteLine("------------");
for (int m = 0; m < MangGiaDinhNV.Count; m++)
{
Console.WriteLine("Thong tin nguoi than : ");
Console.WriteLine("MaNV\tTen\tQuanHe\tNamSinh");
GiaDinhNV NgThanNv = MangGiaDinhNV[m];
Console.WriteLine("{0}\t{1}\t{2}\t{3}", NgThanNv.MaNV, NgThanNv.TenNgThan, NgThanNv.QuHe, NgThanNv.NamSinh);
}
//foreach (LuongNV lg in MangLuongNV)
//{
// Console.WriteLine("thang {0}, luong {1}",lg.Thang, lg.LuongNhVien);
//}
Console.ReadLine();
}
public Boolean UpdateLuongNV(string MaPB, string MaNV, string MaLuong, long LCB, long PhuCap, long Thuong, long KyLuat, int Thang, int Nam, int SoGioLamThem, int SoNgayCong)
{
DataProviderLuongNV dp = new DataProviderLuongNV();
LuongNV bh = new LuongNV(MaPB, MaNV, MaLuong, LCB, PhuCap, Thuong, KyLuat, Thang, Nam, SoGioLamThem, SoNgayCong, TinhLuong(LCB, PhuCap, Thuong, KyLuat, SoGioLamThem, SoNgayCong));
return(dp.SuaLuongNV(bh));
}
public List <LuongNV> GetLuongs()
{
List <LuongNV> luongs = new List <LuongNV>();
DataTable data = DataProvider.Instance.ExecuteQuery("TinhLuong");
foreach (DataRow item in data.Rows)
{
LuongNV luong = new LuongNV(item);
luongs.Add(luong);
}
return(luongs);
}
public ActionResult XuatBangLuong(int id)
{
Luong lg = data.Luongs.SingleOrDefault(n => n.MaLuong == id);
NhanVien nv = data.NhanViens.SingleOrDefault(n => n.MaNV == lg.MaNV);
QuyetDinhTD qd = data.QuyetDinhTDs.SingleOrDefault(n => n.MaQD == nv.MaQD);
ChucVu cv = data.ChucVus.SingleOrDefault(n => n.MaCV == qd.MaCV);
decimal mucLuong = 0;
decimal giatringaycong = 0;
decimal giatritresom = 0;
decimal giatringaynghicop = 0;
decimal giatringaynghikp = 0;
decimal giatriphutroi = 0;
if (nv.TinhTrang == "Thử việc")
{
mucLuong = cv.MucLuongThuViec;
giatringaycong = Convert.ToDecimal(mucLuong * lg.Songaycong);
giatritresom = Convert.ToDecimal(mucLuong * lg.Solantresom);
giatringaynghicop = Convert.ToDecimal(mucLuong * lg.Songaynghicop);
giatringaynghikp = Convert.ToDecimal(mucLuong * lg.Songaynghikp);
giatriphutroi = Convert.ToDecimal(mucLuong * lg.Sogiopt);
}
else
{
mucLuong = cv.MucLuongCT;
giatringaycong = Convert.ToDecimal(mucLuong * lg.Songaycong);
giatritresom = Convert.ToDecimal(mucLuong * lg.Solantresom);
giatringaynghicop = Convert.ToDecimal(mucLuong * lg.Songaynghicop);
giatringaynghikp = Convert.ToDecimal(mucLuong * lg.Songaynghikp);
giatriphutroi = Convert.ToDecimal(mucLuong * lg.Sogiopt);
}
LuongNV db = new LuongNV();
db.DataTable1.AddDataTable1Row(lg.MaLuong, lg.MaNV, nv.HoTen, lg.Thang, lg.Nam, Convert.ToInt32(lg.Songaycong), Convert.ToInt32(lg.Solantresom), Convert.ToInt32(lg.Songaynghicop), Convert.ToInt32(lg.Songaynghikp), Convert.ToDecimal(lg.Khenthuong), Convert.ToDecimal(lg.Kyluat), lg.GiaTri, mucLuong, Convert.ToInt32(lg.Sogiopt), giatringaycong, giatritresom, giatringaynghicop, giatringaynghikp, giatriphutroi);
ReportDocument rd = new ReportDocument();
rd.Load(Path.Combine(Server.MapPath("~/Report/BangLuong.rpt")));
rd.SetDataSource(db);
Response.Buffer = false;
Response.ClearContent();
Response.ClearHeaders();
Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
stream.Seek(0, SeekOrigin.Begin);
return(File(stream, "application/pdf", "Bangluong.pdf"));
}
public void ThemNV()
{
Console.Write("Nhap so Nhan vien can them : ");
short SoNv = Convert.ToInt16(Console.ReadLine());
Console.WriteLine("----------------");
for (int i = 0; i < SoNv; i++)
{
Console.WriteLine("Nhap ID NhanVien :");
short MaNV = Convert.ToInt16(Console.ReadLine());
Console.WriteLine("Nhap Ten NhanVien :");
string TenNV = Convert.ToString(Console.ReadLine());
NhanVien Nvien = new NhanVien(MaNV, TenNV);
MangNV.Add(Nvien);
Console.WriteLine("----------------");
for (int j = 0; j < 12; j++)
{
int Thang = j + 1;
double luong = (double)(i + j + 1) * 11;
LuongNV Luongnvien = new LuongNV(MaNV, Thang, luong);
MangLuongNV.Add(Luongnvien);
}
}
}
