protected string bind_plus() { csCMIS ob = new csCMIS(); string text_html = ""; if (Request.QueryString["T"] != null) text_html = Request.QueryString["T"].ToString(); return ob.get_plus(text_html); }
protected string bind_data() { csCMIS ob = new csCMIS(); string source = "CMIS2_BG", dvi = "ALL", name = "Công ty Điện lực Bắc Giang", ok, err; if (Request.QueryString["S"] != null) source = Request.QueryString["S"].ToString(); if (Request.QueryString["D"] != null) dvi = Request.QueryString["D"].ToString(); if (Request.QueryString["N"] != null) name = Request.QueryString["N"].ToString(); ok = ob.get_display(source, dvi, out err); lbError.Text = string.Format("{0}, ngày {1}", name, DateTime.Today.ToString("dd/MM/yyyy")); return ok; }
protected void search_two() { csCMIS ob = new csCMIS(); string str; DataSet ds = ob.search_two(lbSource.Text, tbMaYeuCau.Text, ddDonVi.SelectedValue, out str); if (str == "") { gvKhachHang.Visible = true; gvKhachHang.DataSource = ds; gvKhachHang.DataBind(); if (gvKhachHang.Rows.Count == 0) lbError.Text = "Không tìm thấy thông tin tên khách hàng"; } else lbError.Text = str; }
protected void search_one(string tbMaYC) { csCMIS ob = new csCMIS(); DataSet ds; string ok = ob.get_ycau_knai(lbSource.Text, tbMaYC, out ds); if (ok == "") if (ds.Tables[0].Rows.Count > 0) { pnQuaTrinh.Visible = true; lbTenKH.Text = ds.Tables[0].Rows[0][0].ToString(); lbDiaChi.Text = ds.Tables[0].Rows[0][1].ToString(); foreach (DataRow dr in ds.Tables[0].Rows) { if (dr[2].ToString() == "TN" && dr[3].ToString() == "TH") { lbNgayDK.Text = dr[5].ToString(); if (dr[4].ToString() != "") lbNgayDK.Text = dr[5].ToString() + " : " + dr[4].ToString(); } else if (dr[2].ToString() == "KS" && dr[3].ToString() == "HE") lbHenKS.Text = dr[5].ToString(); else if (dr[2].ToString() == "KS" && dr[3].ToString() == "TH") { lbNgayKS.Text = dr[5].ToString(); if (dr[4].ToString() != "") lbNgayKS.Text = dr[5].ToString() + " : " + dr[4].ToString(); } else if (dr[2].ToString() == "TC" && dr[3].ToString() == "HE") lbHenTC.Text = dr[5].ToString(); else if ((dr[2].ToString() == "TC" || dr[2].ToString() == "TH") && dr[3].ToString() == "TH") { lbNgayTC.Text = dr[5].ToString(); if (dr[4].ToString() != "") lbNgayTC.Text = dr[5].ToString() + " : " + dr[4].ToString(); } else if (dr[2].ToString() == "HD" && dr[3].ToString() == "TH") lbNgayHD.Text = dr[5].ToString(); } } else lbError.Text = "Không tìm thấy thông tin mã yêu cầu"; else lbError.Text = ok; }
protected DataSet get_data(string loai_khang, out DataSet ds_qua) { string source = "CMIS2_BG", ma_dvi = "PA05"; if (Request.QueryString["S"] != null) source = Request.QueryString["S"].ToString().ToUpper(); if (Request.QueryString["D"] != null) ma_dvi = Request.QueryString["D"].ToString().ToUpper(); DataSet ds; csCMIS ob = new csCMIS(); if (loai_khang == "TN") { ds = ob.get_dv(source, ma_dvi, "moi_dk", "01/01/2011", DateTime.Today.ToString("dd/MM/yyyy")); ds_qua = new DataSet(); } else if (loai_khang == "KS") { ds = ob.get_dv(source, ma_dvi, "can_ks", "01/01/2011", DateTime.Today.ToString("dd/MM/yyyy")); ds_qua = ob.get_dv(source, ma_dvi, "chua_ks", "01/01/2011", DateTime.Today.AddDays(-1).ToString("dd/MM/yyyy")); } else { ds = ob.get_dv(source, ma_dvi, "can_tc", "01/01/2011", DateTime.Today.ToString("dd/MM/yyyy")); ds_qua = ob.get_dv(source, ma_dvi, "chua_tc", "01/01/2011", DateTime.Today.AddDays(-1).ToString("dd/MM/yyyy")); } return ds; }
protected void pro_chua_hd() { try { csCMIS ob = new csCMIS(); string xxx; DataSet ds = ob.bg_ks_chua_hd(lbSource.Text, ddDonVi.SelectedValue, out xxx); GridView1.Columns[3].HeaderText = "Ngày hẹn TC"; GridView1.DataSource = ds; GridView1.DataBind(); lbError.Text = string.Format("{0}: Có {1} khách hàng đã khảo sát chưa ký duyệt hợp đồng", ddDonVi.SelectedItem.Text, ds.Tables[0].Rows.Count); lbError.Text += xxx; } catch (Exception ex) { lbError.Text = ex.Message; } }