protected void btnImport_Click(object sender, ImageClickEventArgs e)
{
DataTable dt = DefineBus.GetDataTableList(Request.QueryString["tableid"].ToString());
if (this.HidHeadName.Value.Length > 0 && this.HidTagName.Value.Length > 0)
{
int num = HidTagName.Value.Split(',').Length;
string[,] ht = new string[num, 2];
string[] arr = HidTagName.Value.Split(',');
string headname = HidHeadName.Value.Replace("#", ",");
string[] arr1 = headname.Split(',');
string[] endarr = new string[arr1.Length / 3];
for (int i = 0, j = 0; i < endarr.Length; i++)
{
endarr[i] = arr1[j];
j += 3;
}
for (int i = 0; i < num; i++)
{
for (int ii = 0; ii < 2; ii++)
{
if (ii == 0)
{
ht[i, ii] = arr[i];
}
else
{
ht[i, ii] = endarr[i];
}
}
}
ExportExcel(dt, ht, "", HidTableHeadName.Value);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//获取表头
lbl_title.Text = DefineBus.GetDefineTableByCode(Request.QueryString["tableid"].ToString());
#region 绑定表结构
DataSet defineControl = DefineBus.GetTableStruct(Request.QueryString["tableid"].ToString());
this.StructDL.DataSource = defineControl;
this.StructDL.DataBind();
#endregion
#region 读取控件名
for (int i = 0; i < defineControl.Tables[0].Rows.Count; i++)
{
HidControlName.Value = HidControlName.Value + "," + defineControl.Tables[0].Rows[i]["ccode"].ToString();//获取控件ID集合
HidControlList.Value = HidControlList.Value + ",db_" + defineControl.Tables[0].Rows[i]["ccode"].ToString() + "#" + defineControl.Tables[0].Rows[i]["type"].ToString() + "#" + defineControl.Tables[0].Rows[i]["length"].ToString() + "#" + defineControl.Tables[0].Rows[i]["isempty"].ToString() + "#" + defineControl.Tables[0].Rows[i]["cname"].ToString();
}
HidControlName.Value = HidControlName.Value.ToString().TrimStart(',');
HidControlList.Value = HidControlList.Value.ToString().TrimStart(',');
#endregion
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["ID"] != null)
{
this.HidControlID.Value = Request.QueryString["ID"].ToString();
}
if (!Page.IsPostBack)
{
//获取表头
if (HidControlID.Value == "-1")
{
lbl_title.Text = "新建" + DefineBus.GetDefineTableByCode(Request.QueryString["tableid"].ToString());
}
else
{
lbl_title.Text = "修改" + DefineBus.GetDefineTableByCode(Request.QueryString["tableid"].ToString());
}
//获取表ID
this.HidControlTableID.Value = Request.QueryString["tableid"].ToString();
//获取表内字段之间关系
HidRelation.Value = DefineBus.GetRelationByTableID(Request.QueryString["tableid"].ToString());
//获取明细横向统计关系
HidSubRelation.Value = DefineBus.GetRelationByParentTableID(Request.QueryString["tableid"].ToString(), "0");
//获取明细纵向统计关系
HidDownRelation.Value = DefineBus.GetRelationByParentTableID(Request.QueryString["tableid"].ToString(), "1");
//获取表之间关系
HidTablRelation.Value = DefineBus.GetRelationTable(Request.QueryString["tableid"].ToString());
//获取明细表默认行数
HidTableRowNum.Value = DefineBus.GetTableRows(Request.QueryString["tableid"].ToString());
//获取明细字段
HidSubTableCode.Value = DefineBus.GetSubTableByParentID(Request.QueryString["tableid"].ToString());
DataSet defineControl = DefineBus.GetTableStruct(Request.QueryString["tableid"].ToString());
#region 读取控件名
for (int i = 0; i < defineControl.Tables[0].Rows.Count; i++)
{
HidControlName.Value = HidControlName.Value + "," + defineControl.Tables[0].Rows[i]["ccode"].ToString();//获取控件ID集合
HidControlList.Value = HidControlList.Value + ",db_" + defineControl.Tables[0].Rows[i]["ccode"].ToString() + "#" + defineControl.Tables[0].Rows[i]["type"].ToString() + "#" + defineControl.Tables[0].Rows[i]["length"].ToString() + "#" + defineControl.Tables[0].Rows[i]["isempty"].ToString() + "#" + defineControl.Tables[0].Rows[i]["cname"].ToString();
}
HidControlName.Value = HidControlName.Value.ToString().TrimStart(',');
HidControlList.Value = HidControlList.Value.ToString().TrimStart(',');
#endregion
//判断表使用的模板（标准版/自定义模板）
if (DefineBus.GetModuleByTableID(Request.QueryString["tableid"].ToString()))
{
//自定义模板
DataSet moduleDS = DefineBus.GetModuleValueByTableID(Request.QueryString["tableid"].ToString());
String modulevalue = moduleDS.Tables[0].Rows[0]["ModuleContent"].ToString();
modulevalue = modulevalue.Replace(" ", "");
//替换详细列表
//HidTablRelation.value = "A#A1#A2,B#B1#B2,C#C1#C2@a#a1#a2,b#b1#b2,c#c1#c2";
if (HidTablRelation.Value.Trim().Length > 0)
{
string[] mainstr = HidTablRelation.Value.Split('@'); //mainstr = "A#A1#A2,B#B1#B2";
for (int i = 0; i < mainstr.Length; i++)
{
string[] substr = mainstr[i].Split(','); //substr="A#A1#A2";
string head = string.Empty;
for (int j = 0; j < substr.Length; j++)
{
string[] itemstr = substr[j].Split('#');
head = head + "<td valign=\"top\" style=\"background-color:#FFFFFF\">" + itemstr[6] + "</td>";
if (j >= substr.Length - 1)
{
modulevalue = modulevalue.Replace("###" + itemstr[0] + "###", head);
}
}
}
}
String sourceValue = modulevalue;
int strlen = 0;
do
{
int beginNum = modulevalue.IndexOf("{***");
int endNum = modulevalue.IndexOf("***}");
string tableColum = string.Empty;
try
{
tableColum = modulevalue.Substring(beginNum + 4, endNum - beginNum - 4);
}
catch { break; }
if (tableColum.Length < 1)
{
break;
}
for (int i = 0; i < defineControl.Tables[0].Rows.Count; i++)
{
//控件替换
string control = string.Empty;
if (tableColum == defineControl.Tables[0].Rows[i]["ccode"].ToString()) //配对获取的表字段
{
#region 文本框设置
if (defineControl.Tables[0].Rows[i]["typeflag"].ToString() == "0") //文本框
{
if (defineControl.Tables[0].Rows[i]["ismultiline"].ToString() == "0") //单行
{
if (defineControl.Tables[0].Rows[i]["isempty"].ToString() == "0") //不可以为空
{
control = "<input type='text' class='tdinput' autotab='true' style='width:90%;' onblur=\"RelationInLoad()\""
+ " name='db_" + tableColum + "' id='db_" + tableColum + "' "
+ " maxlength=" + defineControl.Tables[0].Rows[i]["length"].ToString() + " value='" + defineControl.Tables[0].Rows[i]["dropdownlistValue"].ToString() + "'/><span style=\"color:red\">*</span>";
}
else
{
control = "<input type='text' class='tdinput' autotab='true' style='width:90%;' onblur=\"RelationInLoad()\""
+ " name='db_" + tableColum + "' id='db_" + tableColum + "' "
+ " maxlength=" + defineControl.Tables[0].Rows[i]["length"].ToString() + " value='" + defineControl.Tables[0].Rows[i]["dropdownlistValue"].ToString() + "'/>";
}
}
else
{
if (defineControl.Tables[0].Rows[i]["isempty"].ToString() == "0")
{
control = "<textarea rows='4' cols='20' style='height:60px;width:90%;' class='tdinput' "
+ " name='db_" + tableColum + "' id='db_" + tableColum + "' "
+ " maxname='" + defineControl.Tables[0].Rows[i]["cname"].ToString() + "' maxlength='" + defineControl.Tables[0].Rows[i]["length"].ToString() + "'"
+ " >" + "</textarea><span style=\"color:red\">*</span>";
}
else
{
control = "<textarea rows='4' cols='20' style='height:60px;width:90%;' class='tdinput' "
+ " name='db_" + tableColum + "' id='db_" + tableColum + "' "
+ " maxname='" + defineControl.Tables[0].Rows[i]["cname"].ToString() + "' maxlength='" + defineControl.Tables[0].Rows[i]["length"].ToString() + "'"
+ " >" + "</textarea>";
}
}
}
#endregion
#region 拉框设置
if (defineControl.Tables[0].Rows[i]["typeflag"].ToString() == "1")
{
if (defineControl.Tables[0].Rows[i]["isempty"].ToString() == "0")
{
control = "<select tdinput id='db_" + defineControl.Tables[0].Rows[i]["ccode"].ToString() + "' style='width:90%'>" + defineControl.Tables[0].Rows[i]["dropdownlistValue"].ToString() + "</select><span style=\"color:red\">*</span>";
}
else
{
control = "<select id='db_" + defineControl.Tables[0].Rows[i]["ccode"].ToString() + "' style='width:90%'>" + defineControl.Tables[0].Rows[i]["dropdownlistValue"].ToString() + "</select>";
}
}
#endregion
#region 日期控件设置
if (defineControl.Tables[0].Rows[i]["typeflag"].ToString() == "2")
{
if (defineControl.Tables[0].Rows[i]["isempty"].ToString() == "0")
{
control = "<input class='tdinput' id='db_" + defineControl.Tables[0].Rows[i]["ccode"].ToString() + "' maxlength='30' type='text' style='width:90%' readonly onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('db_" + defineControl.Tables[0].Rows[i]["ccode"].ToString() + "')})\" /><span style=\"color:red\">*</span>";
}
else
{
control = "<input class='tdinput' id='db_" + defineControl.Tables[0].Rows[i]["ccode"].ToString() + "' maxlength='30' type='text' style='width:90%' readonly onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('db_" + defineControl.Tables[0].Rows[i]["ccode"].ToString() + "')})\" /> ";
}
}
#endregion
sourceValue = sourceValue.Replace("{***" + tableColum.ToString() + "***}", control);
break;
}
}
strlen = tableColum.Length;
string submodulevalue = modulevalue.Substring(endNum + 4);
modulevalue = submodulevalue;
} while (strlen > 0);
ltl_input_custom.Text = sourceValue;
}
else
{
#region 绑定表结构
this.StructDL.DataSource = defineControl;
this.StructDL.DataBind();
#endregion
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
#region 绑定检索条件
DataSet defineControl = DefineBus.GetTableSearch(Request.QueryString["tableid"].ToString());
if (defineControl == null | defineControl.Tables == null | defineControl.Tables[0].Rows.Count <= 0)
{
trSearchImg.Visible = false;
trSearchLine.Visible = false;
}
else
{
DataSet defineShowControl = DefineBus.GetTableSearch(Request.QueryString["tableid"].ToString());
//绑定搜索列
string headsearch = "<table width=\"100%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"1\" bgcolor=\"#999999\">";
int tdnum = 1;
if (defineControl != null && defineControl.Tables[0].Rows.Count > 0)
{
int rownum = defineControl.Tables[0].Rows.Count;
for (int i = 0; i < defineControl.Tables[0].Rows.Count; i++)
{
int flag = int.Parse(defineControl.Tables[0].Rows[i]["typeflag"].ToString());
if (i % 3 == 0)
{
headsearch += "<tr style=\"height:25px\"><td align=\"right\" class=\"tdColTitle\" style=\"width:10%\">" + defineControl.Tables[0].Rows[i]["cname"].ToString() + "</td>";
}
else
{
headsearch += "<td align=\"right\" class=\"tdColTitle\" style=\"width:10%\">" + defineControl.Tables[0].Rows[i]["cname"].ToString() + "</td>";
tdnum++;
}
switch (flag)
{
case 0:
headsearch += "<td bgcolor=\"#FFFFFF\" class=\"tdColInput\"><input type='text' autotab='true' style='width:200px;' "
+ " id='db_" + defineControl.Tables[0].Rows[i]["ccode"].ToString() + "' "
+ " maxlength=" + defineControl.Tables[0].Rows[i]["length"].ToString() + " value='" + "'/></td>";;
break;
case 1:
headsearch += "<td bgcolor=\"#FFFFFF\" class=\"tdColInput\"><select id='db_" + defineControl.Tables[0].Rows[i]["ccode"].ToString() + ">" + defineControl.Tables[0].Rows[i]["dropdownlistValue"].ToString() + "</select></td>";
break;
case 2:
headsearch += "<td bgcolor=\"#FFFFFF\" class=\"tdColInput\"><input id='db_" + defineControl.Tables[0].Rows[i]["ccode"].ToString() + "1' maxlength='30' style='width:80px;' type='text' value='" + DateTime.Now.ToString("yyyy-MM-01") + "' readonly onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('db_" + defineControl.Tables[0].Rows[i]["ccode"].ToString() + "')})\" />~ ";
headsearch += "<input id='db_" + defineControl.Tables[0].Rows[i]["ccode"].ToString() + "2' maxlength='30' style='width:80px;' type='text' value='" + DateTime.Now.ToString("yyyy-MM-dd") + "' readonly onclick=\"WdatePicker({dateFmt:'yyyy-MM-dd',el:$dp.$('db_" + defineControl.Tables[0].Rows[i]["ccode"].ToString() + "')})\" /> </td>";
break;
}
if ((i - 2) % 2 == 0 && i - 2 > 0)
{
headsearch += "</tr>";
}
}
}
headsearch += "<tr id=\"trSearch\" runat=\"server\" ><td colspan=\"" + tdnum * 2 + "\" height=\"30\" class=\"tdColInput\" align=\"center\"><img src=\"../../../Images/Button/Bottom_btn_search.jpg\" runat=\"server\" alt=\"检索\" id=\"imgSearch\" style=\"cursor: hand\" onclick=\"SearchList(1);\" /></td></tr></table>";
lbl_search.Text = headsearch;
InitSearch(defineShowControl);//检索绑定
}
#endregion
DataSet headds = DefineBus.GetTableHead(Request.QueryString["tableid"].ToString());
this.HidTableID.Value = Request.QueryString["TableID"].ToString();
InitPage(headds);//初始化列表头
}
}
