public static BaoBieu getReport(DataRow row) { BaoBieu report = new BaoBieu(); report.id = HelpNumber.ParseInt64(row["ID"]); report.keyid = row["KEYID"].ToString().Trim(); report.reportName = row["NAME"].ToString().Trim(); report.isRead = (row["ISREAD_BIT"].ToString().Equals("Y") ? true : false); return report; }
public List<BaoBieu> getAllReport() { List<BaoBieu> listReport = new List<BaoBieu>(); DatabaseFB db = DABase.getDatabase(); DbCommand dbSelect = db.GetSQLStringCommand("SELECT * FROM REPORT_CAT ORDER BY lower(NAME) ASC WHERE VISIBLE_BIT='Y'"); IDataReader reader = db.ExecuteReader(dbSelect); while (reader.Read()) { BaoBieu report = new BaoBieu(); report.id = HelpNumber.ParseInt64(reader["ID"].ToString()); report.keyid = reader["KEYID"].ToString(); report.reportName = reader["NAME"].ToString(); listReport.Add(report); } reader.Close(); return listReport; }
public BaoBieu load2(string reportKeyID, string username) { try{ DatabaseFB db = DABase.getDatabase(); DbCommand dbSelect = db.GetStoredProcCommand("FW_GET_REPORT"); db.AddInParameter(dbSelect, "@username", DbType.String, username); db.AddInParameter(dbSelect, "@reportkeyid", DbType.String, reportKeyID); IDataReader reader = db.ExecuteReader(dbSelect); //Không tồn tại report đó trong reportcat BaoBieu report = new BaoBieu(); report.id = 0; report.keyid = reportKeyID; if (reader.Read()) { report.id = HelpNumber.ParseInt64(reader["ID"].ToString()); report.reportName = reader["NAME"].ToString(); if (reader["ISREAD_BIT"].ToString().Equals("Y")) report.isRead = true; else report.isRead = false; } reader.Close(); if (report.id > 0 || report.id == -1) return report; } catch { } //Không tồn tại phân quyền trên report này //Xem như là Public Report return null; }
private BaoBieu getReport(DataRow row) { BaoBieu report = new BaoBieu(); report.id = HelpNumber.ParseInt64(row["ID"].ToString().Trim()); report.keyid = row["KEYID"].ToString().Trim(); report.reportName = row["NAME"].ToString().Trim(); report.isRead = (row["isread_bit"].ToString().Equals("Y") ? true : false); return report; }
private void barButtonItemSave_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { List<Feature> features = new List<Feature>(); List<BaoBieu> reports = new List<BaoBieu>(); if (this.xtraTabControlLeft.SelectedTabPage.Name.Equals("xtraTabPageGroup")) { foreach (int j in gridViewGroup.GetSelectedRows()) { DataRow row1 = this.gridViewGroup.GetDataRow(j); long groudId = HelpNumber.ParseInt64(row1["groupid"].ToString()); //for (int i = 0; i < gridViewFeature.RowCount; i++) //{ // Feature feature = new Feature(); // feature = this.getFeature(this.gridViewFeature.GetDataRow(i)); // features.Add(feature); //} //HUNG//treelist DataTable dt = treeListFeature.DataSource as DataTable; foreach (DataRow row in dt.Rows) { //Chi luu child row, khong luu parent row if (row["PARENTID"] != DBNull.Value) { Feature feature = new Feature(); feature = this.getFeature(row); features.Add(feature); } } ///--------------- for (int i = 0; i < gridViewReport.RowCount; i++) { BaoBieu report = new BaoBieu(); report = this.getReport(this.gridViewReport.GetDataRow(i)); reports.Add(report); } Feature.updateGroup(groudId, features); BaoBieu.updateGroup(groudId, reports); } } else { foreach (int j in gridViewUser.GetSelectedRows()) { DataRow row1 = this.gridViewUser.GetDataRow(j); long userID = HelpNumber.ParseInt64(row1["userid"].ToString()); //for (int i = 0; i < gridViewFeature.RowCount; i++) //{ // Feature feature = new Feature(); // feature = this.getFeature(this.gridViewFeature.GetDataRow(i)); // features.Add(feature); //} //HUNG//treelist DataTable dt = treeListFeature.DataSource as DataTable; foreach (DataRow row in dt.Rows) { //Chi luu child row, khong luu parent row if (row["PARENTID"] != DBNull.Value) { Feature feature = new Feature(); feature = this.getFeature(row); features.Add(feature); } } ///--------------- for (int i = 0; i < gridViewReport.RowCount; i++) { BaoBieu report = new BaoBieu(); report = this.getReport(this.gridViewReport.GetDataRow(i)); reports.Add(report); } Feature.updateUser(userID, features); BaoBieu.updateUser(userID, reports); } } if (xtraTabControlLeft.SelectedTabPage.Name.Equals("xtraTabPageGroup")) loadGridViewGroupSelectionChanged(); else loadGridViewUserSelectionChanged(); }