");
sb.Append("");
}
else
{
s = StringHelper.GetXmlValue(xml,"外键") + "='"+ recordId+ "'";
s2 = row["gltj"].ToString();
if (s2 != "")
s+=" and ("+ s2 + ")";
sb.Append("| ");
sb.Append(row["glms"].ToString());
sb.Append(" |
");
sb.Append("");
if (StringHelper.GetXmlValue(xml, "同页编辑") == "1")
getSubList2(sb, instance,subprogid, s);
else
getSubList1(sb, instance, subprogid, s);
sb.Append("
");
}
}
sb.Append("");
}
}
public void getSubList1(StringBuilder sb, InstanceManager instance, string menuId, string cond)
{
InstanceManager inst = new InstanceManager(instance.Context, instance.SystemDataManager,menuId);
inst.InitState();
cond = instance.Tag.ReplaceExpression(cond, "");
inst.QueryCondition = cond;
DataTable listData = inst.GetMulitEditDataTable();
DataTable elements = inst.Program.EditElements;
getSubList(sb, inst, listData, elements, 1);
}
public void getSubList2(StringBuilder sb, InstanceManager instance, string menuId, string cond)
{
InstanceManager inst = new InstanceManager(instance.Context, instance.SystemDataManager,menuId);
inst.InitState();
cond = instance.Tag.ReplaceExpression(cond, "");
inst.QueryCondition = cond;
DataTable listData = inst.GetMulitRecordDataTable();
DataTable elements = inst.Program.ListElements;
getSubList(sb, inst,listData, elements,2);
}
public void getSubList(StringBuilder sb, InstanceManager inst, DataTable listData, DataTable elements, int mode)
{
int elementsCount = elements.Rows.Count;
string subProgramId = inst.ProgramID;
int i;
string joinCellJs = "";
sb.Append("");
for(i=0;i" + elements.Rows[i]["kjms"]+"");
if (mode == 1)
{
if (elements.Rows[i]["SX"].ToString().IndexOf("merge") != -1)
joinCellJs = "UniteCol('" + subProgramId + "'," + (i+1).ToString() + ",0);" + joinCellJs;
}
else
{
if (elements.Rows[i]["HB"].ToString() == "1")
joinCellJs = "UniteCol('" + subProgramId + "'," + (i+1).ToString() + ",0);" + joinCellJs;
}
}
sb.Append("
");
ControlManager control = new ControlManager(inst);
control.Display = true;
string str,fff;
string[] a;
int cellIdx=0;
//统计=======================================
string sTJFS = "",tjfs;
double[] var_sum, var_avg, var_max, var_min;
double var_count, var_num;
string[] a1, a2;
int j;
var_sum = new double[elementsCount];
var_avg = new double[elementsCount];
var_max = new double[elementsCount];
var_min = new double[elementsCount];
if (mode == 2)
{
sTJFS = inst.Program.Properties["TJFS"].ToString();
if (sTJFS != "")
{
for (i = 0; i < elementsCount; i++)
{
var_sum[i] = 0;
var_avg[i] = 0;
var_max[i] = double.MinValue;
var_min[i] = double.MaxValue;
}
var_count = 0;
}
}
//统计=========================================
int c = listData.Rows.Count;
for (int idx = 0; idx < c;idx++ )
{
sb.Append("");
for (i = 0; i < elementsCount; i++)
{
control.Init(listData.Rows[idx], elements.Rows[i]);
if (!control.IsHidden)
{
str = control.Text;
cellIdx++;
if (control.ControlType == "140")
{
sb.Append("| ");
if (str != "")
{
a = str.Split('|');
str = "";
for (i = 0; i < a.Length; i++)
{
fff = a[i];
sb.Append("附件" + (i + 1).ToString() + "");
}
}
sb.Append(" | ");
}
else
{
//统计=================================
if (mode == 2 && sTJFS != "" && double.TryParse(str, out var_num))
{
tjfs = elements.Rows[i]["TJFS"].ToString();
a1 = tjfs.Split(',');
for (j = 0; j < a1.Length; j++)
{
switch (a1[j])
{
case "Total":
var_sum[i] = var_sum[i] + var_num;
break;
case "Average":
var_avg[i] = var_avg[i] + var_num;
break;
case "Max":
if (var_num > var_max[i])
var_max[i] = var_num;
break;
case "Min":
if (var_num < var_min[i])
var_min[i] = var_num;
break;
}
}
}
//统计========================================
sb.Append("" + str + " | ");
}
}
}
sb.Append("
");
}
//统计
if (mode==2 && sTJFS != "")
{
a1 = sTJFS.Split(';');
for (j = 0; j < a1.Length; j++)
{
a2 = a1[j].Split(',');
tjfs = a2[5]; //' 名称
if (tjfs == "总计")
tjfs = "小计";
sb.Append("| " + tjfs + " | ");
for (i = 2; i < elementsCount; i++)
{
sb.Append("");
switch (tjfs)
{
case "小计":
if (var_sum[i] != 0)
sb.Append(var_sum[i].ToString());
else
sb.Append(" ");
break;
case "最大值":
if (var_max[i] != double.MinValue)
sb.Append(var_max[i]);
else
sb.Append(" ");
break;
case "最小值":
if (var_min[i] != double.MaxValue)
sb.Append(var_min[i]);
else
sb.Append(" ");
break;
}
sb.Append(" | ");
}
sb.Append("
");
}
}
//统计========================================================
sb.Append("
");
}
public bool IsReusable
{
get
{
return false;
}
}
}