protected void bt_Decrease_Click(object sender, EventArgs e)
{
int rowindex = ((GridViewRow)((Button)sender).Parent.Parent).RowIndex;
Guid id = (Guid)gv_List.DataKeys[rowindex][0];
Rpt_DataSetFieldsBLL bll = new Rpt_DataSetFieldsBLL(id);
if (bll.Model.ColumnSortID > 0)
{
bll.Model.ColumnSortID--;
}
bll.Update();
IList <Rpt_DataSetFields> fields = new Rpt_DataSetBLL((Guid)ViewState["ID"]).GetFields();
Rpt_DataSetFields pre = fields.FirstOrDefault(p => p.ColumnSortID == bll.Model.ColumnSortID && p.ID != id);
if (pre != null)
{
bll = new Rpt_DataSetFieldsBLL(pre.ID);
if (bll.Model.ColumnSortID > 0)
{
bll.Model.ColumnSortID++;
}
bll.Update();
}
BindGrid();
}
private void BindDataSetFields()
{
Rpt_ReportBLL report = new Rpt_ReportBLL((Guid)ViewState["ID"]);
IList <Rpt_DataSetFields> fields = new Rpt_DataSetBLL((Guid)ViewState["DataSet"]).GetFields();
foreach (Rpt_ReportColumnGroups col in report.GetColumnGroups())
{
Rpt_DataSetFields f = fields.FirstOrDefault(p => p.ID == col.DataSetField);
if (f != null)
{
fields.Remove(f);
}
}
foreach (Rpt_ReportRowGroups col in report.GetRowGroups())
{
Rpt_DataSetFields f = fields.FirstOrDefault(p => p.ID == col.DataSetField);
if (f != null)
{
fields.Remove(f);
}
}
foreach (Rpt_ReportValueGroups col in report.GetValueGroups())
{
Rpt_DataSetFields f = fields.FirstOrDefault(p => p.ID == col.DataSetField);
if (f != null)
{
fields.Remove(f);
}
}
cbxl_Fields.DataSource = fields;
cbxl_Fields.DataBind();
}
/// <summary>
/// 获取数据源
/// </summary>
/// <param name="ParamValue"></param>
/// <param name="CacheTime"></param>
/// <returns></returns>
public DataTable GetData(Dictionary <string, object> ParamValue, bool LoadFromCache, out DateTime CacheTime)
{
DataTable dt = null;
CacheTime = DateTime.Now;
if (LoadFromCache)
{
dt = Rpt_DataSet_DataCacheBLL.LoadDataSetCache(_m.ID, ParamValue, out CacheTime);
}
if (dt == null || dt.Rows.Count == 0)
{
SqlParameter[] param = MakeParams(ParamValue);
Rpt_DataSource source = new Rpt_DataSourceBLL(_m.DataSource).Model;
string conn = "";
if (source.ConnectionString != "")
{
conn = MCSFramework.Common.DataEncrypter.DecryptData(source.ConnectionString);
}
switch (_m.CommandType)
{
case 1:
dt = _dal.GetDataFromSQL(conn, _m.CommandText, param);
break;
case 2:
dt = _dal.GetDataFromStoreProcedure(conn, _m.CommandText, param);
break;
case 3:
Dictionary <string, Rpt_DataSetFields> dicTreeColumnList;
dt = _dal.GetDataFromSQL(conn, GenarateSelectSQL(out dicTreeColumnList), param);
#region 处理树形字段，显示指定层级的内容
for (int i = 0; i < dt.Columns.Count; i++)
{
DataColumn column = dt.Columns[i];
if (!dicTreeColumnList.ContainsKey(column.ColumnName))
{
continue;
}
DataColumn newcolumn = dt.Columns.Add("_" + column.ColumnName, Type.GetType("System.String"));
Rpt_DataSetFields field = dicTreeColumnList[column.ColumnName];
Dictionary <int, string> cachevalue = new Dictionary <int, string>();
foreach (DataRow row in dt.Rows)
{
int value = 0;
if (int.TryParse(row[column].ToString(), out value))
{
if (cachevalue.ContainsKey(value))
{
row[newcolumn] = cachevalue[value];
}
else
{
if (field.TreeLevel == 100)
{
//显示全路径
row[newcolumn] = TreeTableBLL.GetFullPathName(new UD_ModelFieldsBLL(field.FieldID, true).Model.RelationTableName, value);
}
else
{
//显示父级
if (field.DisplayMode == 1)
{
row[newcolumn] = TreeTableBLL.GetSuperIDByLevel(new UD_ModelFieldsBLL(field.FieldID, true).Model.RelationTableName, value, field.TreeLevel).ToString();
}
else
{
row[newcolumn] = TreeTableBLL.GetSuperNameByLevel(new UD_ModelFieldsBLL(field.FieldID, true).Model.RelationTableName, value, field.TreeLevel);
}
}
cachevalue.Add(value, row[newcolumn].ToString());
}
}
}
int order = column.Ordinal;
dt.Columns.Remove(column);
newcolumn.SetOrdinal(order);
newcolumn.ColumnName = newcolumn.ColumnName.Substring(1);
}
#endregion
break;
default:
break;
}
if (_m.CommandType == 1 || _m.CommandType == 2)
{
#region 加入计算列字段
IList <Rpt_DataSetFields> computefields = this.GetFields().Where(p => p.IsComputeField == "Y").ToList();
foreach (Rpt_DataSetFields field in computefields)
{
Type ColumnType;
switch (field.DataType)
{
case 1: //整型(int)
ColumnType = Type.GetType("System.Int32");
break;
case 2: //小数(decimal)
ColumnType = Type.GetType("System.Decimal");
break;
case 3: //字符串(varchar)
case 6: //字符串(nvarchar)
ColumnType = Type.GetType("System.String");
break;
case 4: //日期(datetime)
ColumnType = Type.GetType("System.DateTime");
break;
case 5: //GUID(uniqueidentifier)
ColumnType = Type.GetType("System.Guid");
break;
default:
ColumnType = Type.GetType("System.Decimal");
break;
}
try
{
dt.Columns.Add(field.FieldName, ColumnType, field.Expression);
}
catch { }
}
#endregion
}
if (dt != null && dt.Rows.Count < 200000) //只对20万行以下的数据表进行缓存
{
try
{
Rpt_DataSet_DataCacheBLL.SaveDataSetCache(_m.ID, ParamValue, dt);
CacheTime = DateTime.Now;
}
catch { System.GC.Collect(); }
}
}
return(dt);
}
