private void Load_KiemSoat()
{
connectionBN ob = new connectionBN();
DataSet ds = ob.YCAU_GDOAN_FULL_TBA(ddDonVi.SelectedValue);
DataColumn dc = new DataColumn("COLOR");
ds.Tables[0].Columns.Add(dc);
ds.Tables[0].AcceptChanges();
int ok, ngayQH;
foreach (DataRow dr in ds.Tables[0].Rows)
{
ok = Check_TH(1, dr[3].ToString(), dr[4].ToString(), out ngayQH);
ok = ok * Check_TH(2, dr[5].ToString(), dr[6].ToString(), out ngayQH);
ok = ok * Check_TH(3, dr[7].ToString(), dr[8].ToString(), out ngayQH);
ok = ok * Check_TH(4, dr[9].ToString(), dr[10].ToString(), out ngayQH);
ok = ok * Check_TH(5, dr[11].ToString(), dr[12].ToString(), out ngayQH);
dr.BeginEdit();
if (ok == 0)
dr["COLOR"] = "QUA";
else if (ok == 1)
dr["COLOR"] = "DAT";
else
dr["COLOR"] = "DANG";
dr.EndEdit();
}
gvKhachHang.DataSource = ds.Tables[0];
gvKhachHang.DataBind();
foreach (GridViewRow dr in gvKhachHang.Rows)
dr.CssClass = dr.Cells[4].Text;
gvKetQua.DataSource = null;
gvKetQua.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack) return;
hlKiemSoat.Visible = UserInfo.IsInRole("admin") || UserInfo.IsInRole("GiaoDichVien");
hlKiemSoat.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId, "KIEMSOAT", "mid/" + ModuleId);
connectionBN ob = new connectionBN();
ddDonVi.DataSource = ob.DVI_QLY();
ddDonVi.DataBind();
}
private void Load_Data()
{
string nextCV, firstCV, firstTC, lastCV, lastTC;
int ngayTH;
switch (dlGiaiDoan.SelectedValue)
{
case "1":
nextCV = "KS";
firstCV = "TN"; firstTC = "TH";
lastCV = "TN"; lastTC = "CH";
ngayTH = 1;
break;
case "2":
nextCV = "DDN";
firstCV = "KS"; firstTC = "TH";
lastCV = "KS"; lastTC = "CH";
ngayTH = 2;
break;
case "3":
nextCV = "TTK";
firstCV = "DDN"; firstTC = "TH";
lastCV = "DN"; lastTC = "CH";
ngayTH = 3;
break;
case "4":
nextCV = "TVB";
firstCV = "TTK"; firstTC = "TH";
lastCV = "GTK"; lastTC = "CH";
ngayTH = 3;
break;
case "5":
nextCV = "KT";
firstCV = "TVB"; firstTC = "TH";
lastCV = "TT"; lastTC = "CH";
ngayTH = 10;
break;
default: // 0
nextCV = "KT";
firstCV = "TN"; firstTC = "TH";
lastCV = "TT"; lastTC = "CH";
ngayTH = 10000;
break;
}
connectionBN ob = new connectionBN();
gvKhachHang.DataSource = ob.YCAU_GDOAN(ddDonVi.SelectedValue, nextCV, firstCV, firstTC, lastCV, lastTC, ngayTH);
gvKhachHang.DataBind();
gvKetQua.DataSource = null;
gvKetQua.DataBind();
foreach (GridViewRow dr in gvKhachHang.Rows)
dr.CssClass = dr.Cells[6].Text;
}
protected void gvKhachHang_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "XEM")
try
{
int i = Convert.ToInt32(e.CommandArgument);
foreach (GridViewRow dr in gvKhachHang.Rows) dr.CssClass = "none";
gvKhachHang.Rows[i].CssClass = "show";
string cmd = string.Format(@"select KQUA_ID, MA_CVIEC, NDUNG_XLY, NGAY_THIEN
from CMIS01.DV_KQUA_XLY kq
inner join (select MAX(KQUA_ID) MAX_ID from CMIS01.DV_KQUA_XLY where MA_YCAU_KNAI='{0}' group by MA_CVIEC) gr on gr.MAX_ID=kq.KQUA_ID
order by kq.KQUA_ID", gvKhachHang.Rows[i].Cells[0].Text);
connectionBN ob = new connectionBN();
gvKetQua.DataSource = ob.fillDataset(cmd);
gvKetQua.DataBind();
lbError.Text = "Kết quả thực hiện: <b>" + gvKetQua.Rows.Count + "</b> bước";
}
catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình đọc dữ liệu. " + ex.Message; }
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack) return;
if (UserInfo.IsInRole("admin") || UserInfo.IsInRole("GiaoDichVien"))
{
hlBack.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(TabId);
connectionBN ob = new connectionBN();
DataSet ds = ob.DVI_QLY();
DataRow dr = ds.Tables[0].NewRow();
dr[0] = "PA22";
dr[1] = "--";
ds.Tables[0].Rows.InsertAt(dr, 0);
ddDonVi.DataSource = ds.Tables[0];
ddDonVi.DataBind();
//Load_Data();
Load_KiemSoat();
}
else Response.Redirect(DotNetNuke.Common.Globals.NavigateURL("Login"));
}
protected void btTimKiem_Click(object sender, EventArgs e)
{
if (tbMaYC.Text.Length == 0 && tbTenKH.Text.Length == 0)
{
lbError.Text = "Chưa nhập thông tin khách hàng";
return;
}
else try
{
string cmd = string.Format(@"select MA_YCAU_KNAI, TEN_NGUOIYCAU, DCHI_NGUOIYCAU, NGAY_TNHAN, NOI_DUNG_YCAU
from CMIS01.DV_YCAU_KNAI
where (substr(MA_YCAU_KNAI, 0, 2)='GK' and MA_YCAU_KNAI='{0}')
or (substr(MA_YCAU_KNAI, 0, 2)='GK' and MA_DVIQLY='{1}' and upper(TEN_NGUOIYCAU) like upper('%{2}%'))", tbMaYC.Text, ddDonVi.SelectedValue, tbTenKH.Text);
connectionBN ob = new connectionBN();
gvKhachHang.DataSource = ob.fillDataset(cmd);
gvKhachHang.DataBind();
gvKetQua.DataSource = null;
gvKetQua.DataBind();
lbError.Text = "Kết quả tìm kiếm: <b>" + gvKhachHang.Rows.Count + "</b> khách hàng";
}
catch (Exception ex) { lbError.Text = "Có lỗi trong quá trình đọc dữ liệu. " + ex.Message; }
}
protected void gvKhachHang_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "XEM")
try
{
int i = Convert.ToInt32(e.CommandArgument);
foreach (GridViewRow dr in gvKhachHang.Rows) dr.CssClass = "none";
gvKhachHang.Rows[i].CssClass = "show";
connectionBN ob = new connectionBN();
DataSet ds = ob.YCAU_CTIET(gvKhachHang.Rows[i].Cells[1].Text);
DataColumn dc = new DataColumn("QuaHan");
ds.Tables[0].Columns.Add(dc);
ds.Tables[0].AcceptChanges();
foreach (DataRow dr in ds.Tables[0].Rows)
{
int step = Convert.ToInt32(dr[0].ToString().Substring(0, 1));
int ngayQH;
int ok = Check_TH(step, dr[1].ToString(), dr[2].ToString(), out ngayQH);
dr.BeginEdit();
if (ok == 0)
{
dr[4] = "QUA";
dr["QuaHan"] = ngayQH;
}
else if (ok == 1)
dr[4] = "DAT";
else
dr[4] = "DANG";
dr.EndEdit();
}
gvKetQua.DataSource = ds.Tables[0];
gvKetQua.DataBind();
foreach (GridViewRow dr in gvKetQua.Rows) dr.CssClass = dr.Cells[4].Text;
}
catch { }
}
