public void AlterField(int fieldId)
{
DataTable uitype = new DataTable();
uitype.Columns.Add("id");
uitype.Columns.Add("name");
uitype.Rows.Add(0, "hidden");
uitype.Rows.Add(1, "Text");
uitype.Rows.Add(2, "DateTime");
uitype.Rows.Add(3, "Int");
uitype.Rows.Add(4, "Double");
uitype.Rows.Add(5, "combobox");
uitype.Rows.Add(6, "checkbox");
((IfrmEditField)frmeditField).loadUitype(uitype);
List <BaseGeneralDataUnit> unitList = NewObject <BaseGeneralDataUnit>().getlist <BaseGeneralDataUnit>();
((IfrmEditField)frmeditField).loadUnitType(unitList);
BaseReportField field = NewObject <BaseReportField>().getmodel(fieldId) as BaseReportField;
frmeditField.currField = field;
((Form)frmeditField).Text = "修改参数";
((Form)frmeditField).ShowDialog();
}
public void SaveField()
{
BaseReportField field = frmeditField.currField;
field.save();
LoadFieldList(1, field.TitleId);
}
public List <object> GetReportParamsValue()
{
List <object> paramList = new List <object>();
foreach (Control val in panelQueryControl.Controls)
{
if (val.Tag != null && val.Tag.GetType() == typeof(BaseReportField))
{
BaseReportField field = val.Tag as BaseReportField;
if (field.UiType == 1)
{
paramList.Add(val.Text);
}
else if (field.UiType == 2)
{
paramList.Add((val as DateTimePicker).Value);
}
else if (field.UiType == 3)
{
paramList.Add((val as IntegerInput).Value);
}
else if (field.UiType == 4)
{
paramList.Add((val as DoubleInput).Value);
}
else if (field.UiType == 5)
{
paramList.Add((val as ComboBox).SelectedValue);
}
else if (field.UiType == 6)
{
paramList.Add((val as CheckBox).Checked?1:0);
}
}
}
return(paramList);
}
//[AOP(typeof(AopTransaction))]
public void InitFields(int titleId)
{
BaseReportTitle title = NewObject <BaseReportTitle>().getmodel(titleId) as BaseReportTitle;
DataTable dt = NewDao <ReportDao>().GetProFields(title.ProName);
List <BaseReportField> fields = new List <BaseReportField>();
try
{
//先删除原来数据
NewDao <ReportDao>().DeleteField(titleId);
//循环添加字段
for (int i = 0; i < dt.Rows.Count; i++)
{
BaseReportField field = NewObject <BaseReportField>();
field.FieldId = 0;
field.TitleId = titleId;
field.Name = dt.Rows[i]["parmname"].ToString();
field.ColName = dt.Rows[i]["parmname"].ToString();
field.ColLength = Convert.ToInt32(dt.Rows[i]["length"]);
field.DataType = dt.Rows[i]["typename"].ToString();
field.UiType = 0;
field.DynamicSQL = "";
field.DataUnitId = "-1";
field.IsMust = dt.Rows[i]["rowtype"].ToString() == "P" ? 0 : 1;
field.MatchRegular = "";
field.SortId = i;
field.save();
}
}
catch (Exception e)
{
throw e;
}
}
