public void DeleteRecord(string pr_key) { try { DataTable dt = new BHCHEDOBAOHIEMController().GetByParentId(Convert.ToInt32(pr_key)); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["ParentID"].ToString() == pr_key) { new BHCHEDOBAOHIEMController().DeleteByPrkey(Convert.ToInt32(dt.Rows[i]["IDCheDoBaoHiem"])); } } } else { new BHCHEDOBAOHIEMController().DeleteByPrkey(Convert.ToInt32(pr_key)); hdfRecordID.Text = ""; } } catch { X.MessageBox.Alert("Thông báo", "Mã chế độ bảo hiểm đang được sử dụng").Show(); } GridPanel1.Reload(); }
protected void btnOK_Click(object sender, DirectEventArgs e) { try { DataTable record = new BHCHEDOBAOHIEMController().GetByPrkey(Convert.ToInt32(txtmaloaihdcoppy.Text)); if (record.Rows.Count > 0) { Dialog.ShowNotification("Mã đã tồn tại"); } else { record = new BHCHEDOBAOHIEMController().GetByPrkey(Convert.ToInt32(hdfRecordID.Text)); record.Rows[0]["IDCheDoBaoHiem"] = int.Parse(txtmaloaihdcoppy.Text); BHCHEDOBAOHIEMInfo item = new BHCHEDOBAOHIEMInfo() { IDCheDoBaoHiem = int.Parse(record.Rows[0]["IDCheDoBaoHiem"].ToString()), ParentID = int.Parse(record.Rows[0]["ParentID"].ToString()), MaCheDoBaohiem = record.Rows[0]["MaCheDoBaohiem"].ToString(), TenCheDoBaoHiem = record.Rows[0]["TenCheDoBaoHiem"].ToString(), UserID = int.Parse(record.Rows[0]["UserID"].ToString()), DateCreate = DateTime.Parse(record.Rows[0]["DateCreate"].ToString()), MaDonVi = record.Rows[0]["MaDonVi"].ToString(), }; new BHCHEDOBAOHIEMController().Insert(item); } GridPanel1.Reload(); wdInputNewPrimaryKey.Hide(); } catch (Exception ex) { Dialog.ShowError(ex.Message.ToString()); } }
private List <object> LoadMenuCon(List <object> obj, int menuID, int k, int idchedobh) { List <CheDoBaoHiemInfo> lists = new CheDoBaoHiemController().GetbyParentID(menuID, -1); foreach (var item in lists) { string tmp = ""; for (int i = 0; i < k; i++) { //tmp += "- "; // obj.Add(new { IDCheDoBaoHiem = item.IDCheDoBaoHiem, TenCheDoBaoHiem = tmp + item.TenCheDoBaoHiem }); if (idchedobh == item.IDCheDoBaoHiem) { DataTable list1 = new BHCHEDOBAOHIEMController().GetByPrkey(item.ParentID); for (int h = 0; h < list1.Rows.Count; h++) { cboCheDoBH.SelectedItem.Text = list1.Rows[h]["TenCheDoBaoHiem"].ToString(); cboCheDoBH.SelectedItem.Value = item.IDCheDoBaoHiem.ToString(); } break; } } obj = LoadMenuCon(obj, item.IDCheDoBaoHiem, k + 1, idchedobh); } return(obj); }
public void TuDongTinhNgayTien() { SoNgayNghi = (dfNgayKetThuc1.SelectedDate - dfNgayBatDau1.SelectedDate).Days + 1; txtSoNgayNghi1.Text = SoNgayNghi.ToString(); DAL.BHBANGTINHCHEDOBAOHIEM btcdbh = new BangTinhCheDoBaoHiemController().GetByPrKey(int.Parse("0" + hdfDieuKienHuong.Text)); if (SoNgayNghi + int.Parse(txtLuyKe1.Text) > btcdbh.DKThoiGianToiDaHuongCheDo) { txtSoNgayNghi1.StyleSpec = "color:red"; Dialog.ShowNotification("Nhân viên có thời gian nghỉ lớn hơn thời gian cho phép"); } else { txtSoNgayNghi1.StyleSpec = "color:black"; } int congchuan = 24;// int.Parse("0" + new HeThongController().GetValueByName("CONG_CHUAN", Session["MaDonVi"].ToString())); //if (congchuan == 0) DateTime.DaysInMonth(dfNgayBatDau1.SelectedDate.Year, dfNgayBatDau1.SelectedDate.Month); string congthucdathay = ""; new BHCHEDOBAOHIEMController().TinhChiTieu(dfNgayBatDau1.SelectedDate, int.Parse("0" + hdfIDNhanVienBaoHiem.Text), out LuongDongBHThangLienKe, out LuongToiThieuChung, out LuongBHBQ6Thang); switch (int.Parse(cbbCheDo1.Value.ToString())) { case 23: case 24: case 76: txtChiTieuLuong1.FieldLabel = "Lương đóng BH tháng liền kề"; txtChiTieuLuong1.Text = LuongDongBHThangLienKe.ToString("n0"); break; case 20: case 21: case 22: txtChiTieuLuong1.FieldLabel = "Lương tối thiểu chung"; txtChiTieuLuong1.Text = LuongToiThieuChung.ToString("n0"); break; case 26: case 27: case 28: case 29: case 75: txtChiTieuLuong1.FieldLabel = "Lương đóng BH bình quân 6 tháng"; txtChiTieuLuong1.Text = LuongBHBQ6Thang.ToString("n0"); break; } decimal sotien = new BHCHEDOBAOHIEMController().XuLyCongThuc(btcdbh.CongThuc, LuongToiThieuChung, LuongDongBHThangLienKe, LuongBHBQ6Thang, SoNgayNghi, congchuan, out congthucdathay); txtSoTienDeNghi1.Text = ((long)sotien / 1000 * 1000).ToString("0"); tipSoTienDeNghi.Html = btcdbh.CongThuc + "\n =" + congthucdathay; }
protected void btnCapNhat_Click(object sender, DirectEventArgs e) { BHCHEDOBAOHIEMInfo obj = new BHCHEDOBAOHIEMInfo(); BHCHEDOBAOHIEMController ctr = new BHCHEDOBAOHIEMController(); if (!string.IsNullOrEmpty(cboCheDoBH.Text)) { obj.ParentID = Convert.ToInt32(cboCheDoBH.Value); } obj.MaCheDoBaohiem = txtMaCheDoBaohiem.Text; obj.TenCheDoBaoHiem = txtTenCheDoBaoHiem.Text; obj.UserID = CurrentUser.ID; obj.DateCreate = DateTime.Now; obj.MaDonVi = Session["MaDonVi"].ToString(); if (e.ExtraParams["Command"] == "Edit") { obj.IDCheDoBaoHiem = Convert.ToInt32(hdfRecordID.Text); //obj.IDCheDoBaoHiem = Convert.ToInt32(hdfIdcha_edit.Text); ctr.Update(obj); wdAddWindow.Hide(); hdfIdcha_edit.Text = ""; } else { if (cboCheDoBH.Value.ToString() == "0") { obj.ParentID = 0; } DataTable dt = DataController.DataHandler.GetInstance().ExecuteDataTable("GetCheDoBaoHiem_MaCheDoBaoHiem", "@MaCheDoBaoHiem", txtMaCheDoBaohiem.Text); if (dt.Rows.Count > 0) { X.MessageBox.Alert("Thông báo", "Mã chế độ bảo hiểm đã tồn tại").Show(); txtMaCheDoBaohiem.Focus(); return; } else { ctr.Insert(obj); cboCheDoBH.Reset(); txtMaCheDoBaohiem.Reset(); txtTenCheDoBaoHiem.Reset(); } if (e.ExtraParams["Close"] == "True") { wdAddWindow.Hide(); } } GridPanel1.Reload(); }
protected void btnEditCha_Click(object sender, DirectEventArgs e) { try { wdNhomCheDoBH.Show(); wdNhomCheDoBH.Title = "Sửa nhóm chế độ bảo hiểm"; wdNhomCheDoBH.Icon = Icon.Pencil; if (!string.IsNullOrEmpty(hdfNhomCha.Text)) { DataTable dt = new BHCHEDOBAOHIEMController().GetByPrkey(Convert.ToInt32(hdfNhomCha.Text)); txtcha_machedobh.Text = dt.Rows[0]["MaCheDoBaohiem"].ToString(); txtcha_tenchedobh.Text = dt.Rows[0]["TenCheDoBaoHiem"].ToString(); } } catch { } }
protected void btnCapNhat_Click_Cha(object sender, DirectEventArgs e) { BHCHEDOBAOHIEMInfo obj = new BHCHEDOBAOHIEMInfo(); BHCHEDOBAOHIEMController ctr = new BHCHEDOBAOHIEMController(); obj.ParentID = 0; obj.MaCheDoBaohiem = txtcha_machedobh.Text; obj.TenCheDoBaoHiem = txtcha_tenchedobh.Text; obj.UserID = CurrentUser.ID; obj.DateCreate = DateTime.Now; obj.MaDonVi = Session["MaDonVi"].ToString(); if (e.ExtraParams["Command"] == "Edit") { obj.IDCheDoBaoHiem = Convert.ToInt32(hdfNhomCha.Text); ctr.Update(obj); wdNhomCheDoBH.Hide(); } else { DataTable dt = DataController.DataHandler.GetInstance().ExecuteDataTable("GetCheDoBaoHiem_MaCheDoBaoHiem", "@MaCheDoBaoHiem", txtcha_machedobh.Text); if (dt.Rows.Count > 0) { X.MessageBox.Alert("Thông báo", "Mã chế độ bảo hiểm đã tồn tại").Show(); txtcha_machedobh.Focus(); return; } else { ctr.Insert(obj); txtcha_machedobh.Reset(); txtcha_tenchedobh.Reset(); } } if (e.ExtraParams["Close"] == "True") { wdNhomCheDoBH.Hide(); } grp_nhombhdcd.Reload(); }
protected void btnEdit_Click(object sender, DirectEventArgs e) { try { wdAddWindow.Show(); wdAddWindow.Title = "Sửa chế độ bảo hiểm"; wdAddWindow.Icon = Icon.Pencil; if (!string.IsNullOrEmpty("hdfRecordID")) { DataTable dt = new BHCHEDOBAOHIEMController().GetByPrkey(Convert.ToInt32(hdfRecordID.Text)); //hdfIdcha_edit.Text = dt.Rows[0]["IDCheDoBaohiem"].ToString(); txtTenCheDoBaoHiem.Text = dt.Rows[0]["TenCheDoBaoHiem"].ToString(); txtMaCheDoBaohiem.Text = dt.Rows[0]["MaCheDoBaohiem"].ToString(); //cboCheDoBH.Text = dt.Rows[0]["TenCheDoBaoHiem"].ToString(); //cboCheDoBH.Value = dt.Rows[0]["IDCheDoBaohiem"].ToString(); cboCheDoBH.SetValue(dt.Rows[0]["ParentId"].ToString()); // LoadCha(Convert.ToInt32(dt.Rows[0]["IDCheDoBaoHiem"])); } } catch { } }