public static string getXmlByTable(ITableImplement table)
{
DataBaseField[] dataBaseFields = table.af_GetAvailableDataBaseField();
string tableXml = "<" + table.TableName() + ">";
foreach (DataBaseField dataBaseField in dataBaseFields)
{
tableXml += "<" + dataBaseField.FieldName + ">";
tableXml += dataBaseField.Value;
tableXml += "</" + dataBaseField.FieldName + ">";
}
tableXml += "</" + table.TableName() + ">";
return(tableXml);
}
private void getTemplateOptionsAndField()
{
string tableName = HttpUtil.GetReqStrValue("tableName");
TF_CUSTOM_TEMPLATE conf = new TF_CUSTOM_TEMPLATE();
conf.TABLE_NAME = tableName;
conf.USER_ID = Convert.ToInt32(userBase.StaffID);
conf.TYPE = 0;
List <TF_CUSTOM_TEMPLATE> templateList = BLLTable <TF_CUSTOM_TEMPLATE> .Select(new TF_CUSTOM_TEMPLATE(), conf);
string html = "<option value='-1'>--无--</option>";
if (tableName.Equals("-1"))
{
Response.Write("{\"html\":\"" + html + "\"}");
return;
}
foreach (TF_CUSTOM_TEMPLATE template in templateList)
{
html += "<option value='" + template.ID + "'>" + template.TEMPLATE_NAME + "</option>";
}
ITableImplement itable = new ITableImplement();
itable.setConn(conn).setModule(tableName);
DataBaseField[] dataBaseFields = itable.af_GetAvailableDataBaseField();
string fieldHtml = "<ul>";
foreach (DataBaseField dataBaseField in dataBaseFields)
{
TF_TB_FIELD conf2 = new TF_TB_FIELD();
conf2.FIELD_NAME = dataBaseField.FieldName;
TF_TB_FIELD val2 = BLLTable <TF_TB_FIELD> .GetRowData(conf2);
if (val2 != null)
{
fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + (string.IsNullOrEmpty(val2.NOTE)? dataBaseField.FieldName : val2.NOTE) + "</div></li>";
}
else
{
fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + dataBaseField.FieldName + "</div></li>";
}
}
fieldHtml += "</ul>";
Response.Write("{\"html\":\"" + html + "\",\"fieldHtml\":\"" + fieldHtml + "\"}");
}
private void SaveState()
{
#region 获取条件
finderObj = new ITableImplement();
foreach (DataBaseField f1 in valObj.af_GetAvailableDataBaseField())
{
string fieldValue = null;
AttributeItem attr1 = null;
try
{
if (isChaZhao(f1))
{
if (TryGetRequest(f1.Desc.FieldCtrlName + "_NAME", out fieldValue))
{
attr1 = new AttributeItem(f1.TableName, f1.Desc.FieldCtrlName + "_NAME");
finderObj.SetValue(attr1, fieldValue);
}
}
if (TryGetRequest(f1, out fieldValue))
{
attr1 = new AttributeItem(f1);
finderObj.SetValue(attr1, fieldValue);
if (!string.IsNullOrEmpty(fieldValue))
{
condObj.Like(attr1, fieldValue);
}
}
}
catch (Exception ex)
{
Cs.Error(ex.ToString());
litWarn.Text = ex.Message + ":" + attr1.LongName + "=" + fieldValue;
}
}
//hidVal.Value = valObj111.ToJson(20);
//hidCondition.Value = condObj111.ToJson(20);
hidFind.Value = finderObj.ToJson(20);
//if (hidCondition.Value != "")
//{
// condObj111 = JsonServiceBase.FromJson<ITableImplement>(hidCondition.Value);
//}
#endregion
}
//递归遍历
public List <Dictionary <string, object> > selectReverse(Dictionary <string, object> map, List <Dictionary <string, object> > mapList, ITableImplement table)
{
string tableName = "";
//取值视图配置
ITableImplement valObj = new ITableImplement();
//条件视图配置
ITableImplement condObj = new ITableImplement();
Dictionary <string, object> flagMap = new Dictionary <string, object>();
Dictionary <string, Dictionary <string, object> > nextMap = new Dictionary <string, Dictionary <string, object> >();
foreach (var item in map)
{
// Dictionary<string, object> temp2List = new Dictionary<string, object>();
if (item.Key.Equals("tableName"))
{
tableName = item.Value.ToString();
valObj.setConn(conn).setModule(item.Value.ToString(), false, true);
condObj.setConn(conn).setModule(item.Value.ToString(), false, true);
}
else if (item.Key.Equals("condition"))
{
condObj.af_WhereSQL = " " + item.Value;
}
else
{
if (item.Value is string)
{
valObj[item.Key] = item.Value;
flagMap[item.Key] = item.Value;
}
else
{
flagMap[item.Key] = new object();
// valObj[item.Key] = temp3List;
nextMap.Add(item.Key, (Dictionary <string, object>)item.Value);
}
}
}
if (table != null)
{
// foreach(ITableImplement table in tableList){
//条件视图配置 (这里要每次都new 一个 因为循环 每次都要同的条件)
ITableImplement condObj2 = new ITableImplement();
condObj2.setConn(conn).setModule(tableName.ToString(), false, true);
condObj2.af_WhereSQL = condObj.af_WhereSQL;
DataBaseField[] dataBaseFields = table.af_GetAvailableDataBaseField();
foreach (DataBaseField dataBaseField in dataBaseFields)
{
condObj2.af_WhereSQL = condObj2.af_WhereSQL.Replace("{" + dataBaseField.FieldName + "}", "'" + table[dataBaseField.FieldName].ToString() + "'");
}
condObj = condObj2;
}
List <ITableImplement> temp4List = BLLTable <ITableImplement> .Factory(conn).Select(valObj, condObj);
foreach (ITableImplement itable in temp4List)
{
Dictionary <string, object> tempMap = new Dictionary <string, object>();
foreach (var flag in flagMap)
{
if (flag.Value is string)
{
tempMap.Add(flag.Key, itable[flag.Key]);
}
else
{
tempMap.Add(flag.Key, selectReverse(nextMap[flag.Key], new List <Dictionary <string, object> >(), itable));
}
}
mapList.Add(tempMap);
}
return(mapList);
}
private void getTemplateOptionsAndField()
{
string tableName = HttpUtil.GetReqStrValue("tableName");
TF_CUSTOM_TEMPLATE conf = new TF_CUSTOM_TEMPLATE();
conf.TABLE_NAME = tableName;
conf.USER_ID = Convert.ToInt32(userBase.StaffID);
conf.TYPE = 0;
List<TF_CUSTOM_TEMPLATE> templateList = BLLTable<TF_CUSTOM_TEMPLATE>.Select(new TF_CUSTOM_TEMPLATE(), conf);
string html = "<option value='-1'>--无--</option>";
if (tableName.Equals("-1"))
{
Response.Write("{\"html\":\"" + html + "\"}");
return;
}
foreach(TF_CUSTOM_TEMPLATE template in templateList){
html += "<option value='"+template.ID+"'>"+template.TEMPLATE_NAME+"</option>";
}
ITableImplement itable = new ITableImplement();
itable.setConn(conn).setModule(tableName);
DataBaseField[] dataBaseFields = itable.af_GetAvailableDataBaseField();
string fieldHtml = "<ul>";
foreach (DataBaseField dataBaseField in dataBaseFields)
{
TF_TB_FIELD conf2 = new TF_TB_FIELD();
conf2.FIELD_NAME = dataBaseField.FieldName;
TF_TB_FIELD val2 = BLLTable<TF_TB_FIELD>.GetRowData(conf2);
if (val2 != null)
{
fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + (string.IsNullOrEmpty(val2.NOTE)? dataBaseField.FieldName : val2.NOTE) + "</div></li>";
}
else {
fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + dataBaseField.FieldName + "</div></li>";
}
}
fieldHtml += "</ul>";
Response.Write("{\"html\":\"" + html + "\",\"fieldHtml\":\"" + fieldHtml + "\"}");
}
protected void Page_Load(object sender, EventArgs e)
{
base.InitModule(ref valObj, ref KeyID, ref fieldList);
if (!string.IsNullOrEmpty(ModuleName))
{
pageAttr1 = AttributeItem.Factory(valObj.DataBaseTable.IDField);
condObj.af_PageBy(pageAttr1, Order.Desc);
//condObj111._TableName = valObj111._TableName;
finderObj._TableName = valObj._TableName;
DataBaseField[] ds1 = valObj.af_GetAvailableDataBaseField();
foreach (DataBaseField f1 in ds1)
{
if (!f1.Desc.af_Enable || !f1.Desc.af_Visable)
{
continue;
}
fieldList.Add(f1);
}
}
title = valObj._ZhName + "管理";
Page.Title = title;
if (!IsPostBack)
{
//从数据库获取配置的取值对象和条件对象，作为视图。jinsj
Ec_View cond1 = new Ec_View();
cond1.ModuleName = valObj._TableName;
Ec_View v1 = BLLTable <Ec_View> .GetRowData(cond1);
if (v1 != null && v1.IsNotNull())
{
if (v1.ValueJsonString != "")
{
valObj = JsonServiceBase.FromJson <ITableImplement>(v1.ValueJsonString);
}
if (v1.ConditionJsonString != "")
{
condObj = JsonServiceBase.FromJson <ITableImplement>(v1.ConditionJsonString);
}
string viewName = v1.ViewName;
}
#region //默认属性初始化
aspPager.CurrentPageIndex = 1;
txtPageSize.Value = "30";
aspPager.PageSize = 30;
#endregion
#region //数据初始化
#endregion
BindList(1);
}
if (hidCondition.Value != "")
{
//condObj111 = JsonServiceBase.FromJson<ITableImplement>(hidCondition.Value);
}
if (hidFind.Value != "")
{
finderObj = JsonServiceBase.FromJson <ITableImplement>(hidFind.Value);
}
if (hidVal.Value != "")
{
//valObj111 = JsonServiceBase.FromJson<ITableImplement>(hidVal.Value);
}
if (valObj.IsNull())
{
//valObj111.LoadAllAttributes(true);
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
ITableImplement valdata = valObj;//.Clone();
foreach (DataBaseField f1 in valObj.af_GetAvailableDataBaseField())
{
if (f1.TableName.ToLower() == valObj._TableName.ToLower())//±¾±í×Ö¶Î
{
string fieldValue;
if (TryGetRequest(f1, out fieldValue))
{
AttributeItem attr1 = new AttributeItem(f1);
valdata.SetValue(attr1, fieldValue);
}
}
}
if (keyid != "")
{
valdata.SetValue(valdata.KeyID, Convert.ToDecimal(keyid));
count = BLLTable <ITableImplement> .Factory(conn).Update(valdata, valdata.KeyID);
}
else
{
count = BLLTable <ITableImplement> .Factory(conn).Insert(valdata, valdata.KeyID);
string ss = BLLTable.SQL_Test.ToString();
keyid = Convert.ToString(valdata.GetValue(valdata.KeyID));
}
if (count > 0)
{
StringBuilder sbData = new StringBuilder("{valObj:''");
List <AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("}");
if (ViewState["sbData"] == null)
{
ViewState["sbData"] = sbData.ToString();
}
else
{
ViewState["sbData"] += "," + sbData.ToString();
}
Button btn = (Button)sender;
//if (btn.ID.IndexOf("btnOK")!=-1)//±£´æÍ˳ö
{
if (ViewState["sbData"] == null)
{
string dataStr = "[" + ViewState["sbData"].ToString() + "]";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + dataStr + "';}else{window.returnValue = '" + dataStr + "';}window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';};window.close();", true);
}
}
//else //½ö±£´æ
{
}
}
else
{
//ÈçºÎ´¦Àí
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
//递归遍历
public List<Dictionary<string, object>> selectReverse(Dictionary<string, object> map, List<Dictionary<string, object>> mapList,ITableImplement table)
{
string tableName = "";
//取值视图配置
ITableImplement valObj = new ITableImplement();
//条件视图配置
ITableImplement condObj = new ITableImplement();
Dictionary<string, object> flagMap = new Dictionary<string, object>();
Dictionary<string, Dictionary<string, object>> nextMap = new Dictionary<string, Dictionary<string, object>>();
foreach(var item in map){
// Dictionary<string, object> temp2List = new Dictionary<string, object>();
if (item.Key.Equals("tableName"))
{
tableName = item.Value.ToString();
valObj.setConn(conn).setModule(item.Value.ToString(), false, true);
condObj.setConn(conn).setModule(item.Value.ToString(), false, true);
}else if (item.Key.Equals("condition")){
condObj.af_WhereSQL = " " + item.Value;
} else{
if (item.Value is string)
{
valObj[item.Key] = item.Value;
flagMap[item.Key]= item.Value;
}
else {
flagMap[item.Key]= new object();
// valObj[item.Key] = temp3List;
nextMap.Add(item.Key, (Dictionary<string, object>)item.Value);
}
}
}
if (table != null)
{
// foreach(ITableImplement table in tableList){
//条件视图配置 (这里要每次都new 一个 因为循环 每次都要同的条件)
ITableImplement condObj2 = new ITableImplement();
condObj2.setConn(conn).setModule(tableName.ToString(), false, true);
condObj2.af_WhereSQL = condObj.af_WhereSQL;
DataBaseField[] dataBaseFields = table.af_GetAvailableDataBaseField();
foreach (DataBaseField dataBaseField in dataBaseFields)
{
condObj2.af_WhereSQL = condObj2.af_WhereSQL.Replace("{" + dataBaseField.FieldName + "}", "'" + table[dataBaseField.FieldName].ToString() + "'");
}
condObj = condObj2;
}
List<ITableImplement> temp4List = BLLTable<ITableImplement>.Factory(conn).Select(valObj, condObj);
foreach (ITableImplement itable in temp4List)
{
Dictionary<string, object> tempMap = new Dictionary<string, object>();
foreach (var flag in flagMap)
{
if (flag.Value is string)
{
tempMap.Add(flag.Key, itable[flag.Key]);
}
else
{
tempMap.Add(flag.Key, selectReverse(nextMap[flag.Key], new List<Dictionary<string, object>>(), itable));
}
}
mapList.Add(tempMap);
}
return mapList;
}
/// <summary>
/// 相关子表
/// </summary>
/// <returns></returns>
protected string getSubForm()
{
StringBuilder sb = new StringBuilder();
try
{
//DataBaseField[] flist = valObj.af_GetAvailableDataBaseField();
//foreach (DataBaseField f1 in flist)
{
//父表的id
object id1 = resultObj.GetValue(valObj.DataBaseTable.IDField);
string tableName1 = "关系表1";
if (valObj.DataBaseTable.SubTable_ChaZhao.Count > 0)
{
int count2 = 0;//计数
foreach (DataBaseTableRelation dr1 in valObj.DataBaseTable.SubTable_ChaZhao)
{
DataBaseTable table2 = dr1.DataBaseTable;
tableName1 = table2.TableName;
DataBaseField IDField = dr1.DataBaseTable.IDField;
DataBaseField NameField = dr1.DataBaseTable.NameField;
List <Relation> lstRel = new List <Relation>();
foreach (DataBaseRelation r1 in dr1.Relations)
{
lstRel.Add(new Relation(r1));
}
ITableImplement value2 = new ITableImplement(table2);
ITableImplement cond2 = new ITableImplement(table2);
cond2.SetValue(AttributeItem.Factory(value2.DataBaseTable.FatherTable_ChaZhao[0].DataBaseTable.IDField), id1);
List <ITableImplement> lstCond = new List <ITableImplement>();
lstCond.Add(cond2);
List <ITableImplement> lstOther = new List <ITableImplement>();
count1 = -1;
//显示明显表的 父表的信息
//value2.setConn(conn).setModule("WEC_QC_CARS");
List <ITableImplement> list2 = BLLTable <ITableImplement> .Factory(conn).SelectByPage(value2, lstRel, lstOther, lstCond,
pageSize, pageIndex, ref count1);
int num = count1 / pageSize;
if (list2.Count > 0)
{
sb.Append("<script type=\"text/javascript\">");
sb.Append("$(function () {");
sb.Append("$(\"#tbl" + tableName1 + "Title\").click(function () {");
sb.Append("$(\"#tbl" + tableName1 + "\").toggleClass(\"hide\");");
sb.Append("$(\"#tbl" + tableName1 + "Img\").toggleClass(\"showUp\");");
sb.Append("});");
//sb.Append("$(\"ul >li >a[name="+count2+"]\").click(function () {" +
// "alert($(this).attr(\"rel\"))" +
// "});");
// sb.Append("$(\"ul >li >a[name=" + count2 + "]\").click(function () {" +
// //"$(\"ul >li >a[name=" + count2 + "]\").parent().removeClass(\"active\");"+
// //"$(this).parent().addClass(\"active\");"+
// "var str = $(this).attr(\"rel\");" +
// "var strs = str.split(\".\");" +
// "var content=$(this).html();"+
// // "alert(content==\"下一页\");" +
// "if(content==\"下一页\"){"+
// "if((parseInt(strs[1])+1)<="+(num+1)+"){"+
// "var nextStr=strs[0]+\".\"+(parseInt(strs[1])+1);"+
// "var prevStr=strs[0]+\".\"+(parseInt(strs[1])-1);" +
// "$(this).attr(\"rel\",nextStr);"+
// "$(this).parent().siblings().find(\"a\").attr(\"rel\",prevStr);" +
// "$(this).parent().siblings().removeClass(\"disabled\");" +
// "}else{"+
// "var nextStr=strs[0]+\".\"+(parseInt(strs[1])+1);" +
// "var prevStr=strs[0]+\".\"+(parseInt(strs[1])-1);" +
// "$(this).attr(\"rel\",nextStr);" +
// "$(this).parent().siblings().find(\"a\").attr(\"rel\",prevStr);" +
// "$(this).parent().siblings().removeClass(\"disabled\");" +
// "$(this).parent().addClass(\"disabled\");"+
// "}"+
// " }else{"+
// "if((parseInt(strs[1])-1)>=1){"+
// "var nextStr=strs[0]+\".\"+(parseInt(strs[1])+1);" +
// "var prevStr=strs[0]+\".\"+(parseInt(strs[1])-1);"+
// "$(this).attr(\"rel\",prevStr);"+
// "$(this).parent().siblings().find(\"a\").attr(\"rel\",nextStr);" +
// "$(this).parent().siblings().removeClass(\"disabled\");" +
// "}else{"+
// "var nextStr=strs[0]+\".\"+(parseInt(strs[1])+1);" +
// "var prevStr=strs[0]+\".\"+(parseInt(strs[1])-1);" +
// "$(this).attr(\"rel\",prevStr);" +
// "$(this).parent().siblings().find(\"a\").attr(\"rel\",nextStr);" +
// "$(this).parent().siblings().removeClass(\"disabled\");" +
// "$(this).parent().addClass(\"disabled\");"+
// "}"+
// "}"+
// "$.ajax({" +
// "url:\"Back.aspx\"," +
// "type:\"post\"," +
// "data:{\"ModuleName\":\"" + ModuleName + "\",\"pageIndex\":strs[1],\"num\":strs[0],\"id1\":"+id1+",\"paging\":\"true\"}," +
// "dataType:\"text\"," +
// "success: function (data) {" +
// "$(\"tbody[rel=\" + strs[0] + \"]\").html(data);" +
// "}," +
// "error: function (data) {" +
// "alert(data);" +
// "}" +
// "});" +
//"});");
sb.Append(" var options = {" +
"currentPage: 1," +
"totalPages: " + (count1 / 10 + 1) + "," +
"numberOfPages:5," +
"onPageChanged:function(event){" +
// "alert($(event.currentTarget).find(\"ul li.active a\").html());" +
"$.ajax({" +
"url:\"Back.aspx\"," +
"type:\"post\"," +
"data:{\"ModuleName\":\"" + ModuleName + "\",\"pageIndex\":$(event.currentTarget).find(\"ul li.active a\").html(),\"num\":" + count2 + ",\"id1\":" + id1 + ",\"paging\":\"true\"}," +
"dataType:\"text\"," +
"success: function (data) {" +
"$(\"tbody[rel=" + count2 + "]\").html(data);" +
"}," +
"error: function (data) {" +
"alert(data);" +
"}" +
"});" +
"}" +
"};" +
"$('#page" + count2 + "').bootstrapPaginator(options);");
sb.Append("});");
sb.Append("</script>");
sb.Append("<div id='tbl" + tableName1 + "Title' class='showTitle'><span >" + value2._ZhName + "信息</span><span id='tbl" + tableName1 + "Img' class='showImg'></span></div>");
sb.Append("<div id='tbl" + tableName1 + "' class=\"tblist\">");
sb.Append("<table cellpadding=\"0\" cellspacing=\"0\" id=\"tbList\" class=\"table table-hover\">");
sb.Append("<thead>");
sb.Append("<tr keyname=\"ID\">");
foreach (DataBaseField d2 in value2.af_GetAvailableDataBaseField())
{
sb.Append("<td data=\"{colname:'" + d2.LongAttributeName + "',show:1}\">" + d2.ZhName + "</td>");
}
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody rel=\"" + count2 + "\">");
foreach (ITableImplement tb2 in list2)
{
sb.Append("<tr>");
foreach (DataBaseField d2 in tb2.af_GetAvailableDataBaseField())
{
sb.Append("<td>" + GetHtmlList(d2, tb2) + "");
}
sb.Append("</tr>");
}
sb.Append("</tbody>");
sb.Append("</table>");
//sb.Append("<div class=\"container\"><div><ul class=\"pager\">");
////for (int i = 0; i <= num;i++ )
////{
//// if (pageIndex == i + 1)
//// {
//// sb.Append("<li class=\"active\"><a href=\"javascript:;\" name=\""+count2+"\" rel="+count2+"."+(i+1)+">" + (i + 1) + "</a></li>");
//// }
//// else
//// {
//// sb.Append("<li><a href=\"javascript:;\" name=\""+count2+"\" rel=" + count2 + "." + (i + 1) + ">" + (i + 1) + "</a></li>");
//// }
////}
//sb.Append("<li class=\"disabled\"><a href=\"javascript:;\" name=\"" + count2 + "\" rel=" + count2 + "." + 1 + ">上一页</a></li>");
//if (num==0)
//{
// sb.Append("<li class=\"disabled\"><a href=\"javascript:;\" name=\"" + count2 + "\" rel=" + count2 + "." + 2 + ">下一页</a></li>");
//}else{
// sb.Append("<li><a href=\"javascript:;\" name=\"" + count2 + "\" rel=" + count2 + "." + 2 + ">下一页</a></li>");
//}
//sb.Append("</ul></div></div>");
sb.Append("<div id=\"page" + count2 + "\"></div>");
sb.Append("</div>");
count2++;
}
}
}
else if (valObj.DataBaseTable.SubTable_ExtField.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
else if (valObj.DataBaseTable.SubTable_Many2Many.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
else if (valObj.DataBaseTable.SubTable_MingXi.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
else if (valObj.DataBaseTable.SubTable_MyTree.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
else if (valObj.DataBaseTable.SubTable_Tree.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
}
}
catch (Exception ex)
{
}
return(sb.ToString());
}
/// <summary>
/// 输入html
/// </summary>
/// <returns></returns>
protected string getInput()
{
StringBuilder sb = new StringBuilder();
string strChazhaoID = "";
try
{
DataBaseField[] flist = valObj.af_GetAvailableDataBaseField();
foreach (DataBaseField f1 in flist)
{
string block = "基础信息";
block = f1.Desc.af_BlockName;
string blockid = f1.Desc.af_BlockID;
if (f1.TableName != resultObj._TableName) //说明不是本表字段
{
block = f1.TableName; //布局名，就是 关联表的父表 表名
if (resultObj.IsOnlyForModuleIDName == true)
{
break;
}
else
{
}
}
f1.Value = Convert.ToString(resultObj.GetValue(f1));
string attrHtml = Input;
BuildByTag b1 = new BuildByTag(BuildType.ForHtmlValue);
b1.ParseForSwitch标签(ref attrHtml, f1);
if (isChaZhao(f1))
{
DataBaseField f2 = f1.DataBaseTable.FatherTable_ChaZhao[0].DataBaseTable.NameField;
string html = Convert.ToString(resultObj.GetValue(f2));
attrHtml = attrHtml.Replace("{字段显示值}", html);
strChazhaoID = f1.Value;
}
else if (isSelect(f1))//枚举量
{
AttributeItem attr2 = AttributeItem.Factory(f1);
string html = BaseFormHelper.Factory(resultObj.ConnectKey).GetOptionText(attr2, f1.Value);
attrHtml = html;
}
else if (f1.Desc.Switch_CtrlType == BaseCtrlType.FileUpImage)
{
attrHtml = "<img style='height:19px;top:5px;postion:relative;' src ='" + f1.Value + "' style='height:40px' />";
}
sb.Append("<dl class=\"dl-horizontal\"><dt><span>").Append(f1.Desc.ZhName).Append("</span></dt><!--").Append(f1.FieldName)
.Append("--><dd><span>");
sb.Append(attrHtml);
sb.Append("</span></dd></dl>");
}
}
catch (Exception ex)
{
Cs.Error("34" + ex.ToString());
}
return(sb.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
////id=1612&pid=161&no=1&name=%u8BE6%u7EC6%u5E03%u5C40&sc=0&ntype=TF_DESIGN_DETAIL&level=0111&
// string id = HttpUtil.GetReqStrValue("id");
string pid = HttpUtil.GetReqStrValue("pid");
// string no = HttpUtil.GetReqStrValue("no");
// string name = HttpUtil.GetReqStrValue("name");
// string sc = HttpUtil.GetReqStrValue("sc");
// string ntype = HttpUtil.GetReqStrValue("ntype");
//DataBase db = DataBase.Factory(conn);
//foreach (DataBaseTable dt1 in db.DataTables_USER)
//{
// tableMap.Add(dt1.TableName,dt1.ZhName);
//}
TF_FORM conf1 = new TF_FORM();
conf1.FORM_ID = Convert.ToInt32(pid);
TF_FORM val1 = new TF_FORM();
val1.TB_ID = 1;
TF_FORM valObj1 = BLLTable <TF_FORM> .GetRowData(val1, conf1);
TF_TABLE conf2 = new TF_TABLE();
conf2.TB_ID = valObj1.TB_ID;
TF_TABLE val2 = new TF_TABLE();
val2.TB_NAME = "";
val2.CH_NAME = "";
val2.TB_ID = 0;
TF_TABLE valObj2 = BLLTable <TF_TABLE> .GetRowData(val2, conf2);
currTable = valObj2.TB_NAME;
currZhTable = valObj2.CH_NAME;
currTableId = valObj2.TB_ID;
V_TF_TEMPLATE_TABLENAME conf = new V_TF_TEMPLATE_TABLENAME();
conf.Distinct = true;
conf.USER_ID = Convert.ToInt32(userBase.StaffID);
List <V_TF_TEMPLATE_TABLENAME> templateList = BLLTable <V_TF_TEMPLATE_TABLENAME> .Select(new V_TF_TEMPLATE_TABLENAME(), conf);
foreach (V_TF_TEMPLATE_TABLENAME temp in templateList)
{
ITableImplement itable = new ITableImplement();
itable.setConn(conn).setModule(temp.TABLE_NAME);
if (!tableMap.ContainsKey(temp.TABLE_NAME))
{
tableMap.Add(temp.TABLE_NAME, temp.CH_NAME);
}
}
TF_CUSTOM_TEMPLATE conf3 = new TF_CUSTOM_TEMPLATE();
conf3.TABLE_NAME = valObj2.TB_NAME;
conf3.USER_ID = Convert.ToInt32(userBase.StaffID);
conf3.TYPE = 0;
List <TF_CUSTOM_TEMPLATE> templateList2 = BLLTable <TF_CUSTOM_TEMPLATE> .Select(new TF_CUSTOM_TEMPLATE(), conf3);
html = "<option value='-1'>--无--</option>";
foreach (TF_CUSTOM_TEMPLATE template in templateList2)
{
if (template.STATUS == 1)//被选中
{
selectedTempName = template.TEMPLATE_NAME;
html += "<option value='" + template.ID + "' selected='selected'>" + template.TEMPLATE_NAME + "</option>";
}
else
{
html += "<option value='" + template.ID + "'>" + template.TEMPLATE_NAME + "</option>";
}
}
ITableImplement itable2 = new ITableImplement();
itable2.setConn(conn).setModule(valObj2.TB_NAME);
DataBaseField[] dataBaseFields = itable2.af_GetAvailableDataBaseField();
fieldHtml = "<ul>";
foreach (DataBaseField dataBaseField in dataBaseFields)
{
TF_TB_FIELD conf4 = new TF_TB_FIELD();
conf4.FIELD_NAME = dataBaseField.FieldName;
TF_TB_FIELD val4 = BLLTable <TF_TB_FIELD> .GetRowData(conf4);
if (val4 != null)
{
fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + (string.IsNullOrEmpty(val4.NOTE)? dataBaseField.FieldName : val4.NOTE) + "</div></li>";
}
else
{
fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + dataBaseField.FieldName + "</div></li>";
}
}
fieldHtml += "</ul>";
// Response.Write("{\"html\":\"" + html + "\",\"fieldHtml\":\"" + fieldHtml + "\"}");
}
/// <summary>
/// ����ӱ�
/// </summary>
/// <returns></returns>
protected string getSubForm()
{
StringBuilder sb = new StringBuilder();
try
{
//DataBaseField[] flist = valObj.af_GetAvailableDataBaseField();
//foreach (DataBaseField f1 in flist)
{
//�����id
object id1 = resultObj.GetValue(valObj.DataBaseTable.IDField);
string tableName1 = "��ϵ��1";
if (valObj.DataBaseTable.SubTable_ChaZhao.Count > 0)
{
int count2 = 0;//����
foreach (DataBaseTableRelation dr1 in valObj.DataBaseTable.SubTable_ChaZhao)
{
DataBaseTable table2 = dr1.DataBaseTable;
tableName1 = table2.TableName;
DataBaseField IDField = dr1.DataBaseTable.IDField;
DataBaseField NameField = dr1.DataBaseTable.NameField;
List<Relation> lstRel = new List<Relation>();
foreach (DataBaseRelation r1 in dr1.Relations)
{
lstRel.Add(new Relation(r1));
}
ITableImplement value2 = new ITableImplement(table2);
ITableImplement cond2 = new ITableImplement(table2);
cond2.SetValue(AttributeItem.Factory(value2.DataBaseTable.FatherTable_ChaZhao[0].DataBaseTable.IDField), id1);
List<ITableImplement> lstCond = new List<ITableImplement>();
lstCond.Add(cond2);
List<ITableImplement> lstOther = new List<ITableImplement>();
count1 = -1;
//��ʾ���Ա�� �������Ϣ
//value2.setConn(conn).setModule("WEC_QC_CARS");
List<ITableImplement> list2 = BLLTable<ITableImplement>.Factory(conn).SelectByPage(value2, lstRel, lstOther, lstCond,
pageSize, pageIndex,ref count1);
int num = count1 / pageSize;
if (list2.Count > 0)
{
sb.Append("<script type=\"text/javascript\">");
sb.Append("$(function () {");
sb.Append("$(\"#tbl" + tableName1 + "Title\").click(function () {");
sb.Append("$(\"#tbl" + tableName1 + "\").toggleClass(\"hide\");");
sb.Append("$(\"#tbl" + tableName1 + "Img\").toggleClass(\"showUp\");");
sb.Append("});");
//sb.Append("$(\"ul >li >a[name="+count2+"]\").click(function () {" +
// "alert($(this).attr(\"rel\"))" +
// "});");
// sb.Append("$(\"ul >li >a[name=" + count2 + "]\").click(function () {" +
// //"$(\"ul >li >a[name=" + count2 + "]\").parent().removeClass(\"active\");"+
// //"$(this).parent().addClass(\"active\");"+
// "var str = $(this).attr(\"rel\");" +
// "var strs = str.split(\".\");" +
// "var content=$(this).html();"+
// // "alert(content==\"��һҳ\");" +
// "if(content==\"��һҳ\"){"+
// "if((parseInt(strs[1])+1)<="+(num+1)+"){"+
// "var nextStr=strs[0]+\".\"+(parseInt(strs[1])+1);"+
// "var prevStr=strs[0]+\".\"+(parseInt(strs[1])-1);" +
// "$(this).attr(\"rel\",nextStr);"+
// "$(this).parent().siblings().find(\"a\").attr(\"rel\",prevStr);" +
// "$(this).parent().siblings().removeClass(\"disabled\");" +
// "}else{"+
// "var nextStr=strs[0]+\".\"+(parseInt(strs[1])+1);" +
// "var prevStr=strs[0]+\".\"+(parseInt(strs[1])-1);" +
// "$(this).attr(\"rel\",nextStr);" +
// "$(this).parent().siblings().find(\"a\").attr(\"rel\",prevStr);" +
// "$(this).parent().siblings().removeClass(\"disabled\");" +
// "$(this).parent().addClass(\"disabled\");"+
// "}"+
// " }else{"+
// "if((parseInt(strs[1])-1)>=1){"+
// "var nextStr=strs[0]+\".\"+(parseInt(strs[1])+1);" +
// "var prevStr=strs[0]+\".\"+(parseInt(strs[1])-1);"+
// "$(this).attr(\"rel\",prevStr);"+
// "$(this).parent().siblings().find(\"a\").attr(\"rel\",nextStr);" +
// "$(this).parent().siblings().removeClass(\"disabled\");" +
// "}else{"+
// "var nextStr=strs[0]+\".\"+(parseInt(strs[1])+1);" +
// "var prevStr=strs[0]+\".\"+(parseInt(strs[1])-1);" +
// "$(this).attr(\"rel\",prevStr);" +
// "$(this).parent().siblings().find(\"a\").attr(\"rel\",nextStr);" +
// "$(this).parent().siblings().removeClass(\"disabled\");" +
// "$(this).parent().addClass(\"disabled\");"+
// "}"+
// "}"+
// "$.ajax({" +
// "url:\"Back.aspx\"," +
// "type:\"post\"," +
// "data:{\"ModuleName\":\"" + ModuleName + "\",\"pageIndex\":strs[1],\"num\":strs[0],\"id1\":"+id1+",\"paging\":\"true\"}," +
// "dataType:\"text\"," +
// "success: function (data) {" +
// "$(\"tbody[rel=\" + strs[0] + \"]\").html(data);" +
// "}," +
// "error: function (data) {" +
// "alert(data);" +
// "}" +
// "});" +
//"});");
sb.Append(" var options = {"+
"currentPage: 1,"+
"totalPages: "+(count1/10+1)+","+
"numberOfPages:5,"+
"onPageChanged:function(event){"+
// "alert($(event.currentTarget).find(\"ul li.active a\").html());" +
"$.ajax({" +
"url:\"Back.aspx\"," +
"type:\"post\"," +
"data:{\"ModuleName\":\"" + ModuleName + "\",\"pageIndex\":$(event.currentTarget).find(\"ul li.active a\").html(),\"num\":" + count2 + ",\"id1\":" + id1 + ",\"paging\":\"true\"}," +
"dataType:\"text\"," +
"success: function (data) {" +
"$(\"tbody[rel="+count2+"]\").html(data);" +
"}," +
"error: function (data) {" +
"alert(data);" +
"}" +
"});" +
"}" +
"};"+
"$('#page"+count2+"').bootstrapPaginator(options);");
sb.Append("});");
sb.Append("</script>");
sb.Append("<div id='tbl" + tableName1 + "Title' class='showTitle'><span >" + value2._ZhName + "��Ϣ</span><span id='tbl" + tableName1 + "Img' class='showImg'></span></div>");
sb.Append("<div id='tbl" + tableName1 + "' class=\"tblist\">");
sb.Append("<table cellpadding=\"0\" cellspacing=\"0\" id=\"tbList\" class=\"table table-hover\">");
sb.Append("<thead>");
sb.Append("<tr keyname=\"ID\">");
foreach (DataBaseField d2 in value2.af_GetAvailableDataBaseField())
{
sb.Append("<td data=\"{colname:'" + d2.LongAttributeName + "',show:1}\">" + d2.ZhName + "</td>");
}
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody rel=\""+count2+"\">");
foreach (ITableImplement tb2 in list2)
{
sb.Append("<tr>");
foreach (DataBaseField d2 in tb2.af_GetAvailableDataBaseField())
{
sb.Append("<td>" + GetHtmlList(d2, tb2) + "");
}
sb.Append("</tr>");
}
sb.Append("</tbody>");
sb.Append("</table>");
//sb.Append("<div class=\"container\"><div><ul class=\"pager\">");
////for (int i = 0; i <= num;i++ )
////{
//// if (pageIndex == i + 1)
//// {
//// sb.Append("<li class=\"active\"><a href=\"javascript:;\" name=\""+count2+"\" rel="+count2+"."+(i+1)+">" + (i + 1) + "</a></li>");
//// }
//// else
//// {
//// sb.Append("<li><a href=\"javascript:;\" name=\""+count2+"\" rel=" + count2 + "." + (i + 1) + ">" + (i + 1) + "</a></li>");
//// }
////}
//sb.Append("<li class=\"disabled\"><a href=\"javascript:;\" name=\"" + count2 + "\" rel=" + count2 + "." + 1 + ">��һҳ</a></li>");
//if (num==0)
//{
// sb.Append("<li class=\"disabled\"><a href=\"javascript:;\" name=\"" + count2 + "\" rel=" + count2 + "." + 2 + ">��һҳ</a></li>");
//}else{
// sb.Append("<li><a href=\"javascript:;\" name=\"" + count2 + "\" rel=" + count2 + "." + 2 + ">��һҳ</a></li>");
//}
//sb.Append("</ul></div></div>");
sb.Append("<div id=\"page"+count2+"\"></div>");
sb.Append("</div>");
count2++;
}
}
}
else if (valObj.DataBaseTable.SubTable_ExtField.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
else if (valObj.DataBaseTable.SubTable_Many2Many.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
else if (valObj.DataBaseTable.SubTable_MingXi.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
else if (valObj.DataBaseTable.SubTable_MyTree.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
else if (valObj.DataBaseTable.SubTable_Tree.Count > 0)
{
DataBaseField IDField = valObj.DataBaseTable.SubTable_ChaZhao[0].DataBaseTable.IDField;
}
}
}
catch (Exception ex)
{
}
return sb.ToString();
}
protected void Page_Load(object sender, EventArgs e)
{
////id=1612&pid=161&no=1&name=%u8BE6%u7EC6%u5E03%u5C40&sc=0&ntype=TF_DESIGN_DETAIL&level=0111&
// string id = HttpUtil.GetReqStrValue("id");
string pid = HttpUtil.GetReqStrValue("pid");
// string no = HttpUtil.GetReqStrValue("no");
// string name = HttpUtil.GetReqStrValue("name");
// string sc = HttpUtil.GetReqStrValue("sc");
// string ntype = HttpUtil.GetReqStrValue("ntype");
//DataBase db = DataBase.Factory(conn);
//foreach (DataBaseTable dt1 in db.DataTables_USER)
//{
// tableMap.Add(dt1.TableName,dt1.ZhName);
//}
TF_FORM conf1 = new TF_FORM();
conf1.FORM_ID = Convert.ToInt32(pid);
TF_FORM val1 = new TF_FORM();
val1.TB_ID = 1;
TF_FORM valObj1 = BLLTable<TF_FORM>.GetRowData(val1, conf1);
TF_TABLE conf2 = new TF_TABLE();
conf2.TB_ID = valObj1.TB_ID;
TF_TABLE val2 = new TF_TABLE();
val2.TB_NAME = "";
val2.CH_NAME = "";
val2.TB_ID = 0;
TF_TABLE valObj2 = BLLTable<TF_TABLE>.GetRowData(val2, conf2);
currTable = valObj2.TB_NAME;
currZhTable = valObj2.CH_NAME;
currTableId = valObj2.TB_ID;
V_TF_TEMPLATE_TABLENAME conf = new V_TF_TEMPLATE_TABLENAME();
conf.Distinct = true;
conf.USER_ID = Convert.ToInt32(userBase.StaffID);
List<V_TF_TEMPLATE_TABLENAME> templateList = BLLTable<V_TF_TEMPLATE_TABLENAME>.Select(new V_TF_TEMPLATE_TABLENAME(), conf);
foreach (V_TF_TEMPLATE_TABLENAME temp in templateList)
{
ITableImplement itable = new ITableImplement();
itable.setConn(conn).setModule(temp.TABLE_NAME);
if (!tableMap.ContainsKey(temp.TABLE_NAME))
{
tableMap.Add(temp.TABLE_NAME, temp.CH_NAME);
}
}
TF_CUSTOM_TEMPLATE conf3 = new TF_CUSTOM_TEMPLATE();
conf3.TABLE_NAME = valObj2.TB_NAME;
conf3.USER_ID = Convert.ToInt32(userBase.StaffID);
conf3.TYPE = 0;
List<TF_CUSTOM_TEMPLATE> templateList2 = BLLTable<TF_CUSTOM_TEMPLATE>.Select(new TF_CUSTOM_TEMPLATE(), conf3);
html = "<option value='-1'>--无--</option>";
foreach (TF_CUSTOM_TEMPLATE template in templateList2)
{
if (template.STATUS == 1)//被选中
{
selectedTempName = template.TEMPLATE_NAME;
html += "<option value='" + template.ID + "' selected='selected'>" + template.TEMPLATE_NAME + "</option>";
}
else
{
html += "<option value='" + template.ID + "'>" + template.TEMPLATE_NAME + "</option>";
}
}
ITableImplement itable2 = new ITableImplement();
itable2.setConn(conn).setModule(valObj2.TB_NAME);
DataBaseField[] dataBaseFields = itable2.af_GetAvailableDataBaseField();
fieldHtml = "<ul>";
foreach (DataBaseField dataBaseField in dataBaseFields)
{
TF_TB_FIELD conf4 = new TF_TB_FIELD();
conf4.FIELD_NAME = dataBaseField.FieldName;
TF_TB_FIELD val4 = BLLTable<TF_TB_FIELD>.GetRowData(conf4);
if (val4 != null)
{
fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + (string.IsNullOrEmpty(val4.NOTE)? dataBaseField.FieldName : val4.NOTE) + "</div></li>";
}
else
{
fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + dataBaseField.FieldName + "</div></li>";
}
}
fieldHtml += "</ul>";
// Response.Write("{\"html\":\"" + html + "\",\"fieldHtml\":\"" + fieldHtml + "\"}");
}