private SimpleView GetSimpleViewFrom(DataRow dr) { SimpleView view = new SimpleView(); view.ID = SqlHelper.GetStringFrom(dr["ViewID"]); view.Name = SqlHelper.GetStringFrom(dr["Name"]); view.LocaleID = SqlHelper.GetStringFrom(dr["LocaleID"]); view.ViewType = SqlHelper.GetIntFrom(dr["ViewType"], 0); view.bSystem = SqlHelper.GetBooleanFrom(dr["bSystem"], false); view.ViewClass = SqlHelper.GetStringFrom(dr["ViewClass"]); view.RowsCount = SqlHelper.GetIntFrom(dr["RowsCount"], 40); view.bShowDetail = SqlHelper.GetBooleanFrom(dr["bShowDetail"], true); view.FontColorStyleId = SqlHelper.GetStringFrom(dr["FontColorStyleId"], string.Empty); return(view); }
private void FillSimpleViewCollection(DataTable table, string defaultViewID) { bool HasDefault = false; for (int i = 0; i < table.Rows.Count; i++) { SimpleView view = GetSimpleViewFrom(table.Rows[i]); if (view.ID == defaultViewID) { view.IsDefault = true; HasDefault = true; } view.State = PersistentObjectState.View; _SimpleViews.Add(view); } if (!HasDefault && _SimpleViews.Count > 0) { _SimpleViews[0].IsDefault = true; } }
internal void Remove(SimpleView item) { this.List.Remove(item); }
public void Add(SimpleView item) { item.Parent = this; this.List.Add(item); }
internal void Retrieve() { CheckDbCnnString(); SqlCommand cmd = new SqlCommand("UAP_Report_RuntimeExihibitonGetReportRelateInfor"); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(SqlHelper.GetParameter("@ID", SqlDbType.NVarChar, 100, _InputID)); cmd.Parameters.Add(SqlHelper.GetParameter("@cAccId", SqlDbType.Char, 3, _cAccId)); cmd.Parameters.Add(SqlHelper.GetParameter("@cYear", SqlDbType.Char, 4, _cYear)); cmd.Parameters.Add(SqlHelper.GetParameter("@cUser", SqlDbType.NVarChar, 20, _UserID)); cmd.Parameters.Add(SqlHelper.GetParameter("@LocaleID", SqlDbType.NVarChar, 10, _LocaleID)); cmd.Parameters.Add(SqlHelper.GetParameter("@DefaultViewID", SqlDbType.NVarChar, 100)); cmd.Parameters.Add(SqlHelper.GetParameter("@ReportID", SqlDbType.NVarChar, 100)); DataSet ds = SqlHelper.ExecuteDataSet(_DbConnString, cmd); if (ds.Tables.Count > 1) { string defaultviewid = cmd.Parameters["@DefaultViewID"].Value.ToString(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { SimpleView view = new SimpleView(); view.ID = ds.Tables[0].Rows[i]["ViewGuid"].ToString(); view.Name = ds.Tables[0].Rows[i]["Name"].ToString(); view.ViewType = Convert.ToInt32(ds.Tables[0].Rows[i]["ViewType"]); view.ViewClass = SqlHelper.GetStringFrom(ds.Tables[0].Rows[i]["ViewClass"]); view.ReportMergeCell = SqlHelper.GetBooleanFrom(ds.Tables[0].Rows[i]["ReportMergeCell"], false); view.RowsCount = SqlHelper.GetIntFrom(ds.Tables[0].Rows[i]["RowsCount"], 40); view.bShowDetail = SqlHelper.GetBooleanFrom(ds.Tables[0].Rows[i]["bShowDetail"], false); if (view.ID.ToLower() == defaultviewid.ToLower()) { view.IsDefault = true; } _Views.Add(view); } DataRow dr = ds.Tables[1].Rows[0]; _ReportID = cmd.Parameters["@ReportID"].Value.ToString(); _ClassName = SqlHelper.GetStringFrom(dr["ClassName"]); _FilterId = SqlHelper.GetStringFrom(dr["FilterId"]); _FilterClass = SqlHelper.GetStringFrom(dr["FilterClass"]); _rootReportId = SqlHelper.GetStringFrom(dr["RootReportId"]); _bVB = SqlHelper.GetBooleanFrom(dr["bVB"], true); if (defaultviewid == string.Empty) { if (_Views.Count <= 0) { throw new ResourceReportException(String4Report.GetString("操作员没有查询权限或视图权限!", _LocaleID)); } _DefaultViewID = _Views[0].ID; } else { _DefaultViewID = defaultviewid; } } }