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 + "\"}"); }