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