void ViewClaim(string idclaim) { DataTable dt = new DataTable(); ClaimDAO cl = new ClaimDAO(); dt = cl.ViewSiteSurveyRecord(idclaim); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; lblNgayThucHien.Text = DateTime.Today.ToShortDateString(); lblThamChieu.Text = dr[1].ToString(); lblGDV.Text = dr[2].ToString(); lblInsurer.Text = dr[3].ToString(); lblSubsidiary.Text = dr[4].ToString(); lblSoHDBH.Text = dr[5].ToString(); lblEffective.Text = dr[6].ToString(); lblInsured.Text = dr[7].ToString(); lblFax.Text = dr[8].ToString(); lblAddress.Text = dr[9].ToString(); lblContectPerson.Text = dr[10].ToString(); lblPhone.Text = dr[11].ToString(); lblEmail.Text = dr[12].ToString(); lblPremises.Text = dr[13].ToString(); lblDateofloss.Text = dr[14].ToString(); lblTypeofloss.Text = dr[15].ToString(); lblCircumstances.Text = dr[16].ToString(); lblTBCQCN.Text = dr[17].ToString(); lblFurtherNotes.Text = dr[18].ToString(); lblExtentOfloss.Text = dr[19].ToString(); lblInitialReserve.Text = dr[20].ToString(); lblAppendixAttached.Text = dr[21].ToString(); lblKhuyenCao.Text = dr[22].ToString(); lblYKien.Text = dr[23].ToString(); lblNgayGioKetThuc.Text = dr[24].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { string mathamchieu = Session["ThamChieu"].ToString(); DataTable dt = new DataTable(); ClaimDAO cl = new ClaimDAO(); dt = cl.TomTat(mathamchieu); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; lblThamChieu.Text = dr[0].ToString(); lblGDV1.Text = dr[1].ToString(); lblDonVi.Text = dr[2].ToString(); lblNDBH.Text = dr[3].ToString(); lblDiaChi.Text = dr[4].ToString(); lblNguoiLienHe.Text = dr[5].ToString(); lblSoHDBH.Text = dr[6].ToString(); lblHieuLuc.Text = dr[7].ToString(); lblFax.Text = dr[8].ToString(); lblSoDienThoai.Text = dr[9].ToString(); lblEmail.Text = dr[10].ToString(); lblDiaDiemTT.Text = dr[11].ToString(); lblLoaiHinhTonThat.Text = dr[12].ToString(); lblNgayTonThat.Text = dr[13].ToString(); lblDienBienTonThat.Text = dr[14].ToString(); lblThongBaoCQChucNang.Text = dr[15].ToString(); lblNguyenNhanTT.Text = dr[16].ToString(); lblPhamViBH.Text = dr[17].ToString(); lblDienBienKhieuNai.Text = dr[18].ToString(); lblMoTaPhamViThietHai.Text = dr[19].ToString(); lblGiaTriDeXuat.Text = dr[20].ToString(); lblGiaTriThuHoi.Text = dr[21].ToString(); lblKetLuan.Text = dr[22].ToString(); } }
public static void fixBugValueClaim(String idClaim) { //Add colums update //String[]colums = { "DienBienTonThat", "PhamViTonThat", "DePhongVaKhuyenCao", "YKienGDV", "GioiThieu" }; String sql = "SELECT * FROM CLAIM WHERE ID_CLAIM = " + idClaim; DataTable dt = SqlDataAcessHelper.exQuery(sql); if (dt.Rows.Count == 1) { DataRow row = dt.Rows[0]; ClaimDAO claimDao = new ClaimDAO(); foreach (DataColumn c in dt.Columns) { String key = c.ColumnName; if (key!= "ID_Claim" && row[key] != null) { String valueOld = row[key].ToString(); if (valueOld.StartsWith("<!DOCTYPE html>\r\n<html>\r\n<head>\r\n</head>\r\n<body>\r\n")) { String valueNew = valueOld.Replace("<!DOCTYPE html>\r\n<html>\r\n<head>\r\n</head>\r\n<body>\r\n", "").Replace("\r\n</body>\r\n</html>", ""); claimDao.updateClaimField(idClaim, key, valueNew); } } } } }
protected void Page_Load(object sender, EventArgs e) { string id = ""; if(Session["ThamChieu"]!= null) id = Session["ThamChieu"].ToString(); HttpCookie ck = Request.Cookies["MaGDV"]; if (ck == null) { linklogin.Visible = true; } else { DataTable dt = new DataTable(); int idgdv = int.Parse(Request.Cookies["MaGDV"].Value); dt = gdvdao.LayTenvaChucVu(idgdv); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; string name = dr[0].ToString(); lblName.Text = name; string chucvu = dr[1].ToString(); lblChucVu.Text = chucvu; } linklogin.Visible = false; ClaimDAO dao = new ClaimDAO(); claimName = dao.getClaimField(id, "TenClaim").ToString(); } }
void ViewClaim(string idclaim) { ClaimDAO cl = new ClaimDAO(); DataTable dt = new DataTable(); dt = cl.ViewSiteSurveyRecord(idclaim); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; lblNgayThucHien.Text = dr[0].ToString(); } }
protected void btnHoanTat_Click(object sender, EventArgs e) { string mcl = null; if (Session["ThamChieu"] != null) { mcl = Session["ThamChieu"].ToString(); mathamchieu = thamchieu; } else { mcl = Request.QueryString["IDClaim"]; } //string mcl = Request.QueryString["IDClaim"]; Response.Redirect("~/Pages/SiteSurveyRecordView.aspx?IDClaim=" + mcl); ClaimDAO cldao = new ClaimDAO(); // quay tro lại trang form //string ma = cldao.LayMaTheoTen(thamchieu); //Response.Redirect("~Pages/InformationForm.aspx?Reference=" + mcl); }
void loadinfo(string id) { DataTable dt = new DataTable(); ClaimDAO cl = new ClaimDAO(); dt = cl.ClaimMaster(id); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; lblThamChieuHead.Text = dr[0].ToString(); lblinsured.Text = dr[1].ToString(); txtbrief.Text = dr[2].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["claimID"] != null) mClaimID = Request.QueryString["claimID"]; if (mClaimID.Trim() != "") { if (!IsPostBack) { //mClaimID = Session["ThamChieu"].ToString(); string done = dailyDao.KiemTraTinhTrang(mClaimID, "PR"); if (done != null && done.ToLower() == "yes") { isLock = true; } loadData(); ClaimDAO dao = new ClaimDAO(); claimName = dao.getClaimField(mClaimID, "TenClaim").ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { if(!this.IsPostBack) { HttpCookie ck = Request.Cookies["MaGDV"]; if (ck == null) Response.Redirect("~/Pages/Login.aspx"); else { load_DropDownlist(); ClaimDAO cldao = new ClaimDAO(); string ma = cldao.LayMa(); lblSTT.Text = ma; int maNhaBH = int.Parse(drNBH.SelectedItem.Value.ToString()); load_DonViBaoHiem(maNhaBH); load_SLGDV(); } //ThemQLHutThuoc(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["ThamChieu"] != null) { mClaimID = Session["ThamChieu"].ToString(); loadData(); ClaimDAO dao = new ClaimDAO(); claimName = dao.getClaimField(mClaimID, "TenClaim").ToString(); } }
void LoadInfor(string maclaim) { ClaimDAO cl= new ClaimDAO(); DataTable dt = new DataTable(); dt = cl.GetBasicInfor(maclaim); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; txtNBH.Text = dr[2].ToString(); txtDonVi.Text=dr[3].ToString(); txtTenKhachHang.Text=dr[4].ToString(); txtDiaChi.Text=dr[5].ToString(); txtNguoiDaiDien.Text=dr[6].ToString(); txtPhone.Text=dr[7].ToString(); txtFax.Text=dr[8].ToString(); txtEmail.Text=dr[9].ToString(); txtKinhDoanh.Text=dr[10].ToString(); txtPolicyNo.Text=dr[11].ToString(); txtPeriodfrom.Text=dr[12].ToString(); txtPremises.Text=dr[13].ToString(); txtDateofloss.Text=dr[14].ToString(); txttenloaihinhtt.Text=dr["LoaiHinhTonThat"].ToString(); maLHTT=int.Parse(dr["ID_LoaiHinhTonThat"].ToString()); } }
protected void loadTheoThamChieu(string thamchieu) { ClaimDAO cdao = new ClaimDAO(); DataTable dt2 = new DataTable(); dt2 = tsdao.TimeSheetTheoThamChieu(thamchieu); gvDSTimeSheet.DataSource = dt2; gvDSTimeSheet.DataBind(); if (dt2.Rows.Count > 0) { gvDSTimeSheet.Visible = true; //ddlFile.Visible = true; //btnSave.Visible = true; } else { //ddlFile.Visible = false; //btnSave.Visible = false; } }
protected void loadDSTimeSheet(int idgdv, string thamchieu) { ClaimDAO cdao = new ClaimDAO(); DataTable dt2 = new DataTable(); //dt = cdao.ClaimTheoTen(thamchieu); //DataRow dr = dt.Rows[0]; //string maclaim = dr[0].ToString(); TimeSheetDAO tsdao = new TimeSheetDAO(); dt2 = tsdao.DSTimeSheet(idgdv, thamchieu); gvDSTimeSheet.DataSource = dt2; gvDSTimeSheet.DataBind(); if (dt2.Rows.Count > 0) { gvDSTimeSheet.Visible = true; //ddlFile.Visible = true; //btnSave.Visible = true; } else { //ddlFile.Visible = false; //btnSave.Visible = false; } }
protected void btnTim_Click(object sender, EventArgs e) { int magdv = int.Parse(drGDV0.SelectedItem.Value.ToString()); //GiamDinhVienDAO gdvdao = new GiamDinhVienDAO(); //DataTable dtgdv = gdvdao.MaGiamDinhVienTheoTen(tengdv); //int idgdv = 0; //if (dtgdv.Rows.Count > 0) //{ // DataRow dr = dtgdv.Rows[0]; // idgdv = int.Parse(dr[0].ToString()); //} ClaimDAO cdao = new ClaimDAO(); string matc= txtMaThamChieuT.Text; string thamchieu = cdao.TenClaim(matc); //DataTable dtc = cdao.ClaimTheoTen(thamchieu); if (matc!="" ) { bool kt = cl.KiemTraThamChieu(matc); if (kt == true) { loadDSTimeSheet(magdv, matc); gvDSTimeSheet.Visible = true; } } //if (matc == "") //{ // LoadTSTheoThamchieu(matc); //} if (matc == "") { loadTheoGDV(magdv); } //if (dtgdv.Rows.Count == 0) //{ // loadTheoThamChieu(matc); //} }