protected void m_grid_RowCommand(object sender, GridViewCommandEventArgs e) { try { string commandName = e.CommandName; GridViewRow row = m_grid.FooterRow; if (commandName == "Insert") { cls_Catalog_Report objReport = new cls_Catalog_Report(); string eName = ((TextBox)row.FindControl("txtIName")).Text; string eFilePath = ((TextBox)row.FindControl("txtIFilePath")).Text; string eSP = ((TextBox)row.FindControl("txtISP")).Text; string eDetail = ((TextBox)row.FindControl("txtIDetail")).Text; objReport.ID_Module = Convert.ToInt32(cboModule.SelectedValue); objReport.Report_Name = eName; objReport.File_Path = eFilePath; objReport.SPName = eSP; objReport.Note = eDetail; int _result = objReport.Insert(); if (_result >= 1) { ltlAnnouncement.Text = "Thêm mới báo cáo '" + eName + "' thành công!"; } if (_result == -1) { ltlAnnouncement.Text = "báo cáo '" + eName + "' đã tồn tại, bạn nên kiểm tra lại!"; } if (_result == 0) { ltlAnnouncement.Text = "Có lỗi trong quá trình thêm mới!"; } bindData(-1); } } catch (Exception ex) { ltlAnnouncement.Text = "Khong them moi duoc du lieu. Vui long lien he voi quan tri<br>" + ex.Message; } }
protected void m_grid_RowDeleting(object sender, GridViewDeleteEventArgs e) { try { int id = e.RowIndex; m_grid.EditIndex = id; int delId =Convert.ToInt32(m_grid.DataKeys[e.RowIndex].Value); if (delId != 0) { cls_Catalog_Report objReport = new cls_Catalog_Report(); objReport.ID_Report = delId; int status_Delete = objReport.Delete(); if (status_Delete == 1) { ltlAnnouncement.Text = "Xóa thành công báo cáo!"; } if (status_Delete <= 0) { ltlAnnouncement.Text = "Không xóa được báo cáo đã chọn."; } } } catch (Exception ex) { ltlAnnouncement.Text = "Lỗi trong quá trình xóa báo cáo: " + ex.ToString(); } bindData(-1); }
private void bindData(int index) { try { //LAY DANH SACH CAC QUOC GIA RA cls_Catalog_Report objReport = new cls_Catalog_Report(); dsReport = objReport.GetData( cboModule.SelectedValue); objReport.ID_Report =0; m_grid.EditIndex = index; m_grid.DataSource = dsReport; bool add = false; if (dsReport.Rows.Count <= 0) { dsReport.Rows.Add(dsReport.NewRow()); add = true; } // m_grid.DataBind(); if(add) m_grid.Rows[0].Visible = false; if (m_grid.Rows.Count > 0) { string confirm = "return confirm('Bạn thật sự muốn xóa row này?')"; for (int i = 0; i < m_grid.Rows.Count; i++) { GridViewRow row = m_grid.Rows[i]; LinkButton lbutton1 = (LinkButton)row.FindControl("cmdDelete"); if (lbutton1 != null) { lbutton1.Visible = D_Option; lbutton1.Attributes.Add("onclick", confirm); //lbutton1.Enabled = D_Option; } LinkButton lbutton2 = (LinkButton)row.FindControl("cmdEdit"); if (lbutton2 != null) lbutton2.Visible = U_Option; } } //XET QUYETN CHO CHUC NANG INSERT GridViewRow row1 = m_grid.FooterRow; if (row1 != null) { row1.Visible = I_Option; } } catch (Exception ex) { } }
protected void m_grid_RowUpdating(object sender, GridViewUpdateEventArgs e) { try { int id = e.RowIndex; m_grid.EditIndex = id; GridViewRow row = m_grid.Rows[id]; string eName = ((TextBox)row.FindControl("txtUName")).Text; string eFilePath = ((TextBox)row.FindControl("txtUFilePath")).Text; string eSP = ((TextBox)row.FindControl("txtUSP")).Text; string eDetail = ((TextBox)row.FindControl("txtUDetail")).Text; short updateId = Int16.Parse(m_grid.DataKeys[id].Value.ToString()); if (updateId > 0) { cls_Catalog_Report objReport = new cls_Catalog_Report(); objReport.ID_Report = updateId; objReport.ID_Module = Convert.ToInt32(cboModule.SelectedValue); objReport.Report_Name = eName; objReport.File_Path = eFilePath; objReport.SPName = eSP; objReport.Note = eDetail; int _result = objReport.Update(); if (_result == 1) { ltlAnnouncement.Text = "Sửa báo cáo '" + eName + "' thành công!"; } if (_result < 0) { ltlAnnouncement.Text = "Có lỗi trong quá trình sửa dữ liệu!"; } } } catch (Exception ex) { ltlAnnouncement.Text = "Khong cap nhat duoc du lieu. Vui long lien he voi quan tri<br>" + ex.Message; } bindData(-1); }
private void LoadListReport() { DataTable _dt = new cls_Catalog_Report().SelectByModuleCode(ConfigurationSettings.AppSettings["Emp_Module"]); gridReport.DataSource = _dt; gridReport.DataBind(); }
private void LoadReport() { cls_Catalog_Report objRe = new cls_Catalog_Report(); DataTable _dt = objRe.GetData( cboModule.SelectedValue); cboReport.DataSource = _dt; cboReport.DataValueField = "ID_Report"; cboReport.DataTextField = "Report_Name"; cboReport.DataBind(); if (cboReport.Items.Count > 0) { cboReport.SelectedIndex = 0; LoadParameter(cboReport.SelectedValue); } }
private void ViewReport() { try { ReportDocument reportDocument = new ReportDocument(); string sReportID = Request.QueryString["ID_Report"].ToString(); cls_Catalog_Report objRe = new cls_Catalog_Report(); DataTable _dtRe = objRe.GetReport(sReportID); DataTable _dtPara = Session["ReportPara"] == null ? null : (DataTable)(Session["ReportPara"]); DataTable _dtP = _dtPara.Clone(); DataTable _dtPReport = _dtPara.Clone(); DataTable _dtSource; string[] sArr = _dtRe.Rows[0]["SPName"].ToString().Split('@'); cls_Report_User objUser = new cls_Report_User(); if (sArr.Length > 1) { for (int i = 0; i < _dtPara.Rows.Count; i++) { bool Exist = false; for (int k = 1; k < sArr.Length; k++) if (_dtPara.Rows[i]["ParaName"].ToString().ToUpper() == sArr[k].ToUpper()) { Exist = true; break; } if (Exist) { _dtP.ImportRow(_dtPara.Rows[i]); } else _dtPReport.ImportRow(_dtPara.Rows[i]); } _dtSource = objUser.GetDataSourceReport(_dtP, sArr[0]); } else _dtSource = objUser.GetSP(sArr[0]); // if (sArr.Length >= 1 && sArr[0].Length <= 0) _dtPReport = _dtPara; string sPath = ConfigurationManager.AppSettings["Report_File"].ToString() + _dtRe.Rows[0]["File_Path"].ToString(); reportDocument.Load(sPath); //tham so bao cao if (_dtSource != null) reportDocument.SetDataSource(_dtSource); for (int k = 0; k < _dtP.Rows.Count; k++) { for (int i = 0; i < reportDocument.ParameterFields.Count; i++) { if (reportDocument.ParameterFields[i].Name.ToUpper() == _dtP.Rows[k]["ParaName"].ToString().ToUpper()) reportDocument.SetParameterValue(reportDocument.ParameterFields[i].Name, _dtP.Rows[k]["ParaValue"]); } } if (_dtPReport.Rows.Count > 0) for (int i = 0; i < _dtPReport.Rows.Count; i++) reportDocument.SetParameterValue(_dtPReport.Rows[i]["ParaName"].ToString(), _dtPReport.Rows[i]["ParaValue"]); CrystalReportViewer.ReportSource = reportDocument; CrystalReportViewer.DataBind(); } catch (Exception ex) { } }