protected void Page_Load(object sender, EventArgs e)
{
try
{
//serviceCSKHCMIS.Service_CSKHCMIS ob = new Service_CSKHCMIS();
CSKH_CMIS.Service_CSKHCMIS ob = new CSKH_CMIS.Service_CSKHCMIS();
DataSet ds = ob.find_KHANG("CMIS2_VP", "PA25VY", "chung", "", "");
//DataSet ds = ob.Get_HDONG_by_KHANG("SONLA", "PA15TX", "PA15TX0006309");
GridView1.DataSource = ds;
GridView1.DataBind();
}
catch (Exception ex) { Response.Write(ex.Message); }
}
private void Load_DonVi()
{
try
{
string url = Request.Url.Host;
lbPC.Text = url.Substring(2, url.IndexOf('.') - 2).ToUpper();
CSKH_CMIS.Service_CSKHCMIS ob = new CSKH_CMIS.Service_CSKHCMIS();
DataSet ds = ob.Get_Dienluc(lbPC.Text);
ddDonViQL.DataSource = ds;
ddDonViQL.DataBind();
lbError.Text = "";
}
catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình kết nối đến máy chủ. " + ex.Message; }
}
protected void Show_ThongTin(int rowID)
{
try
{
lbMaKH.Text = gvKhachHang.Rows[rowID].Cells[1].Text;
lbDonVi.Text = gvKhachHang.Rows[rowID].Cells[4].Text;
CSKH_CMIS.Service_CSKHCMIS ob = new CSKH_CMIS.Service_CSKHCMIS();
DataSet ds = ob.Get_HDONG_by_KHANG(lbPC.Text, lbDonVi.Text, lbMaKH.Text);
lbTenKH.Text = ds.Tables[0].Rows[0][2].ToString();
lbDiaChi.Text = ds.Tables[0].Rows[0][3].ToString();
lbHopDong.Text = ds.Tables[0].Rows[0][4].ToString();
lbNgayKy.Text = DateTime.Parse(ds.Tables[0].Rows[0][5].ToString()).ToString("dd/MM/yyyy");
lbGiaHan.Text = ds.Tables[0].Rows[0][6].ToString();
//lbSoHo.Text = ds.Tables[0].Rows[0][7].ToString();
lbDienThoai.Text = ds.Tables[0].Rows[0]["DTHOAI_NR"].ToString();
lbDienThoaiSMS.Text = ds.Tables[0].Rows[0]["DTHOAI_SMS"].ToString();
lbEmail.Text = ds.Tables[0].Rows[0]["EMAIL"].ToString();
//lbDiemDo.Text = ds.Tables[0].Rows[0][10].ToString();
//lbChuoiGia.Text = ds.Tables[0].Rows[0][11].ToString();
//lbTram.Text = ds.Tables[0].Rows[0][12].ToString();
//lbLo.Text = ds.Tables[0].Rows[0][14].ToString();
//lbCot.Text = ds.Tables[0].Rows[0][16].ToString();
gvInfo.DataSource = ds.Tables[0];
gvInfo.DataBind();
lbError.Text = "";
ddNam.SelectedIndex = 0;
Show_TienDien();
pnThongTin.Visible = true;
gvKhachHang.DataSource = null;
gvKhachHang.DataBind();
}
catch (Exception ex)
{
lbTenKH.Text = "";
lbDiaChi.Text = "";
lbHopDong.Text = "";
lbNgayKy.Text = "";
lbGiaHan.Text = "";
lbDienThoai.Text = "";
lbDienThoaiSMS.Text = "";
lbEmail.Text = "";
gvInfo.DataSource = null;
gvInfo.DataBind();
lbError.Text = "Có lỗi trong quá trình đọc dữ liệu. " + ex.Message;
}
}
protected void Tim_Kiem()
{
pnThongTin.Visible = false;
try
{
CSKH_CMIS.Service_CSKHCMIS ob = new CSKH_CMIS.Service_CSKHCMIS();
DataSet ds = ob.find_KHANG(lbPC.Text, ddDonViQL.SelectedValue, tbTenKH.Text, "", tbMaKH.Text);
gvKhachHang.DataSource = ds;
gvKhachHang.DataBind();
if (gvKhachHang.Rows.Count == 0)
lbError.Text = "Không tìm thấy khách hàng";
else
lbError.Text = string.Format("Kết quả tìm kiếm: {0} khách hàng.", ds.Tables[0].Rows.Count);
}
catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình tìm kiếm. " + ex.Message; }
}
protected void gvLichSu_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "XEM")
{
int i = Convert.ToInt32(e.CommandArgument);
CSKH_CMIS.Service_CSKHCMIS ob = new CSKH_CMIS.Service_CSKHCMIS();
DataSet ds;
if (gvLichSu.Rows[i].Cells[0].Text == "TD")
{
ds = ob.Get_Ctiethdon_TD(lbPC.Text, lbDonVi.Text, Int32.Parse(gvLichSu.Rows[i].Cells[8].Text));
Label1.Visible = true;
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
Label2.Visible = true;
GridView2.DataSource = ds.Tables[1];
GridView2.DataBind();
Label3.Visible = false;
GridView3.DataSource = null;
GridView3.DataBind();
}
else
{
ds = ob.Get_Ctiethdon_VC(lbPC.Text, lbDonVi.Text, Int32.Parse(gvLichSu.Rows[i].Cells[8].Text));
Label1.Visible = false;
GridView1.DataSource = null;
GridView1.DataBind();
Label2.Visible = false;
GridView2.DataSource = null;
GridView2.DataBind();
Label3.Visible = true;
GridView3.DataSource = ds.Tables[0];
GridView3.DataBind();
}
pnChiTiet.CssClass = "pnUpdate";
pnBack.CssClass = "pnBack";
}
}
protected void Show_TienDien()
{
try
{
CSKH_CMIS.Service_CSKHCMIS ob = new CSKH_CMIS.Service_CSKHCMIS();
DataSet ds = ob.Get_hdon_by_khang_nam(lbPC.Text, lbDonVi.Text, lbMaKH.Text, short.Parse(ddNam.SelectedValue));
DataView dv = ds.Tables[0].DefaultView;
dv.Sort = "THANG desc, KY desc";
gvLichSu.DataSource = ds.Tables[0];
gvLichSu.DataBind();
}
catch
{
gvLichSu.DataSource = null;
gvLichSu.DataBind();
}
}