/// <summary> /// 获取list页的数据源 /// 支持主模块的链接 /// 支持枚举量 /// 支持时间格式 /// </summary> /// <param name="f1"></param> /// <returns></returns> public string GetHtmlList(DataBaseField f1, ITableImplement this1) { if (!f1.Desc.af_Enable) { return(""); //是否可用 } if (!f1.Desc.af_Visable) { return(""); //是否可见 } string html = ""; string tableName = f1.TableName; AttributeItem attr1 = AttributeItem.Factory(f1); object value1 = (this1.GetValue(attr1)); DataBaseTable dt1 = f1.DataBaseTable; //DataBaseField f1; try { DataBaseField id1 = dt1.IDField; DataBaseField name1 = dt1.NameField; if (f1 == dt1.IDField) { //html = "<a href='index.aspx?id=" + this1.GetValue(dt1.FieldID.FieldName) + "'>" + html + "</a>"; } else if (f1 == dt1.NameField) // != null && dt1.NameField.FieldName == f1.FieldName)//本模块name详细链接 { string showUrl = "../" + dt1.TableName + "/show.aspx"; if (!Exist(showUrl)) { showUrl = "show.aspx"; } html = "<a href='" + showUrl + "?id=" + this1.GetValue(id1) + "&moduleName=" + tableName + "' target='_blank'>" + value1 + "</a>"; } else if (isSelect(f1)) //枚举量 { html = BaseFormHelper.Factory(this1.ConnectKey).GetOptionText(attr1, value1); } else if (isChaZhao(f1)) //父表 { DataBaseField f2 = f1.DataBaseTable.FatherTable_ChaZhao[0].DataBaseTable.NameField; AttributeItem attr2 = AttributeItem.Factory(f2); html = Convert.ToString(this1.GetValue(attr2)); } else if (f1.Desc.Switch_CtrlType == BaseCtrlType.FileUpImage) { html = "<img src ='" + value1 + "' style='height:40px' />"; } } catch (Exception ex) { Cs.Error(ex.ToString()); } if (html == "") { html = Convert.ToString(value1); } return(html); }
private bool initParam() { if (string.IsNullOrEmpty(Request["template"]))//表名 { DBTableName = Convert.ToString(Request["template"]); } if (string.IsNullOrEmpty(Request["template_id"]))//表的id { ID_FIELD = Convert.ToString(Request["template_id"]); } if (string.IsNullOrEmpty(Request["template_name"]))//表的名称 { NAME_FIELD = Convert.ToString(Request["template_name"]); } if (string.IsNullOrEmpty(Request["template_pid"]))//表的父对象id { PID_FIELD = Convert.ToString(Request["template_pid"]); } if (string.IsNullOrEmpty(Request["template_type"]))//是否为树结构 { IsTypeTree = Convert.ToString(Request["template_type"]); } itable = new ITableImplementHelper(conn).Factory(DBTableName); if (string.IsNullOrEmpty(DBTableName) || string.IsNullOrEmpty(ID_FIELD) || string.IsNullOrEmpty(NAME_FIELD) || itable == null || itable.IsNull() ) { return(false); } return(true); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<ITableImplement>(hidCondition.Value); condObj._TableName = valObj._TableName; } BindList(aspPager.CurrentPageIndex); }
////////////////////////////////////////////////////////////////////////////////////////////// /// <summary> /// 属性列表对象。适用于repList_ItemDataBound /// </summary> public string GetHTML(string templateList, ITableImplement valObj) { BuildByTemplate bt = new BuildByTemplate(BuildType.ForHtmlValue); bt.ConnectKey = conn; string htmlEdit = bt.BuildByStr(templateList, "bs", valObj, @"c:\123.txt"); return(htmlEdit); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <ITableImplement>(hidCondition.Value); condObj._TableName = valObj._TableName; } BindList(aspPager.CurrentPageIndex); }
int recount = -1; //��ѯ�ܼ�¼�� #endregion Fields #region Methods /// <summary> /// ��ȡlistҳ������Դ /// ֧����ģ������� /// ֧��ö���� /// ֧��ʱ���ʽ /// </summary> /// <param name="f1"></param> /// <returns></returns> public string GetHtmlList(DataBaseField f1, ITableImplement this1) { if (!f1.Desc.af_Enable) return "";//�Ƿ���� if (!f1.Desc.af_Visable) return "";//�Ƿ�ɼ� string html = ""; string tableName = f1.TableName; AttributeItem attr1 = AttributeItem.Factory(f1); object value1 = (this1.GetValue(attr1)); DataBaseTable dt1 = f1.DataBaseTable; //DataBaseField f1; try { DataBaseField id1 = dt1.IDField; DataBaseField name1 = dt1.NameField; if (f1 == dt1.IDField) { //html = "<a href='index.aspx?id=" + this1.GetValue(dt1.FieldID.FieldName) + "'>" + html + "</a>"; } else if (f1 == dt1.NameField)// != null && dt1.NameField.FieldName == f1.FieldName)//��ģ��name��ϸ���� { string showUrl = "../" + dt1.TableName + "/show.aspx"; if (!Exist(showUrl)) { showUrl = "show.aspx"; } html = "<a href='" + showUrl + "?id=" + this1.GetValue(id1) + "&moduleName=" + tableName + "' target='_blank'>" + value1 + "</a>"; } else if (isSelect(f1))//ö���� { html = BaseFormHelper.Factory(this1.ConnectKey).GetOptionText(attr1, value1); } else if (isChaZhao(f1))//���� { DataBaseField f2 = f1.DataBaseTable.FatherTable_ChaZhao[0].DataBaseTable.NameField; AttributeItem attr2 = AttributeItem.Factory(f2); html = Convert.ToString(this1.GetValue(attr2)); } else if (f1.Desc.Switch_CtrlType == BaseCtrlType.FileUpImage) { html = "<img src ='" + value1 + "' style='height:40px' />"; } } catch (Exception ex) { Cs.Error(ex.ToString()); } if (html == "") { html = Convert.ToString(value1); } return html; }
public void getTemplateHtml() { string tableName = HttpUtil.GetReqStrValue("tableName"); string templateName = HttpUtil.GetReqStrValue("templateName"); if (templateName.Equals("默认")) { //默认,根据tableName取获取模板 ITableImplement itable = new ITableImplement(); itable.setConn(conn).setModule(tableName); int i = 0; string html = ""; string tr = "<tr>"; foreach (AttributeItem attr in itable.af_AttributeItemList) { if (i % 2 == 0) { html += tr + "</tr>"; tr = "<tr>"; } TF_TB_FIELD conf2 = new TF_TB_FIELD(); conf2.FIELD_NAME = attr.FieldName; TF_TB_FIELD val = BLLTable <TF_TB_FIELD> .GetRowData(conf2); if (val != null) { tr += "<td>" + val.NOTE + "</td><td>[" + tableName + "." + attr.FieldName + "]</td>"; } else { tr += "<td>" + (string.IsNullOrEmpty(attr.ZhName) ? attr.FieldName : attr.ZhName) + "</td><td>[" + tableName + "." + attr.FieldName + "]</td>"; } i++; } Response.Write(DEFAULT_TEMPLATE_START + html + DEFAULT_TEMPLATE_END); return; } TF_CUSTOM_TEMPLATE conf = new TF_CUSTOM_TEMPLATE(); conf.TEMPLATE_NAME = templateName; conf.TABLE_NAME = tableName; conf.USER_ID = Convert.ToInt32(userBase.StaffID); conf.TYPE = 0; TF_CUSTOM_TEMPLATE valObj = BLLTable <TF_CUSTOM_TEMPLATE> .GetRowData(conf); if (valObj == null) { Response.Write(""); } else { Response.Write(valObj.TEMPLATE_HTML); } }
/// <summary> /// 从取值对象中获得属性,从条件对象中获得值 /// </summary> /// <param name="valObj"></param> /// <param name="condObj"></param> /// <returns></returns> public List <DataBaseField> Parse(ITableImplement valObj, ITableImplement condObj) { List <DataBaseField> list2 = new List <DataBaseField>(); List <AttributeItem> list = new List <AttributeItem>(); list.AddRange(valObj.af_GetAvailableAttributeItem()); if (list.Count == 0) { list.AddRange(valObj.af_AttributeItemList); } string tbName = valObj._TableName.ToLower(); if (tbName == ITableImplement.defaultTableName.ToLower()) { tbName = list[0].TableName; } #region 表操作 DataBaseTable dt1 = null; dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[tbName]; if (dt1 == null) { ConsoleService.Warn(tbName + " 数据表不存在"); return(new List <DataBaseField>()); } #endregion foreach (AttributeItem item in list) { string fieldName = item.FieldName.ToLower(); #region 列操作 DataBaseField f1 = null; if (!dt1.DataFields.TryGetValue(fieldName, out f1)) { ConsoleService.Warn(string.Format("数据表{0},数据字段{1}不存在", tbName, fieldName)); continue; } if (f1.Desc.CtrlType == BaseCtrlType.Text || f1.Desc.CtrlType == BaseCtrlType.HTML || f1.Desc.CtrlType == BaseCtrlType.SmallText) { continue; } if (condObj != null && condObj.IsNotNull()) { f1.Value = condObj.GetString(item); } #endregion list2.Add(f1); } return(list2); }
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 SetRequest(ITableImplement condRequest) { foreach (AttributeItem attr in condRequest.af_AttributeItemList) { if (!string.IsNullOrEmpty(Request[attr.FieldCtrlName])) { condRequest.SetValue(attr, Request[attr.FieldCtrlName]); } else if (!string.IsNullOrEmpty(Request[attr.FieldName])) { condRequest.SetValue(attr, Request[attr.FieldName]); } } }
protected void Page_Load(object sender, EventArgs e) { base.InitModule(ref valObj, ref KeyID, ref fieldList); title = valObj._ZhName + "±à¼"; Page.Title = title; if (!string.IsNullOrEmpty(Request["ID"])) { keyid = Request["ID"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (!string.IsNullOrEmpty(Request["record"])) { keyid = Request["record"]; } if (!IsPostBack) { try { if (string.IsNullOrEmpty(keyid))//ÐÂÔö { } else//ÐÞ¸Ä { ITableImplement cond1 = valObj.Clone(); cond1.SetValue(KeyID, keyid); resultObj = BLLTable <ITableImplement> .Factory(conn).GetRowData(valObj, cond1); if (resultObj == null) { ScriptHelper.Alert(this, "¼Ç¼²»´æÔÚ"); ScriptHelper.CloseMe(this); return; } //string html = Convert.ToString(resultObj.GetValue(WEC_A_VOTE.Attribute.TITLE)); } } catch (Exception ex) { litWarn.Text = ex.Message; } } if (valObj.IsNull()) { //valObj.LoadAllAttributes(true); } }
public string GetTemplate(string template, ITableImplement valObj, ITableImplement condObj) { try { BuildByTemplate bt = new BuildByTemplate(BuildType.ForHtmlTemplate); bt.ConnectKey = conn; string template1 = bt.BuildByStr(template, "bs", Parse(valObj, condObj), @"c:\123.txt"); return(template1); } catch (Exception ex) { File.AppendAllText(Path.Combine(WebHelper.GetAppPath(), "abc.txt"), ex.ToString()); throw ex; } return(""); }
public void getTemplateHtml() { string tableName = HttpUtil.GetReqStrValue("tableName"); string templateName = HttpUtil.GetReqStrValue("templateName"); if (templateName.Equals("默认")) { //默认,根据tableName取获取模板 ITableImplement itable = new ITableImplement(); itable.setConn(conn).setModule(tableName); int i = 0; string html = ""; string tr = "<tr>"; foreach(AttributeItem attr in itable.af_AttributeItemList){ if (i % 2 == 0) { html += tr+"</tr>"; tr = "<tr>"; } TF_TB_FIELD conf2 = new TF_TB_FIELD(); conf2.FIELD_NAME = attr.FieldName; TF_TB_FIELD val = BLLTable<TF_TB_FIELD>.GetRowData(conf2); if (val != null) { tr += "<td>" + val.NOTE + "</td><td>[" + tableName + "." + attr.FieldName + "]</td>"; } else { tr += "<td>" + (string.IsNullOrEmpty(attr.ZhName) ? attr.FieldName : attr.ZhName )+ "</td><td>[" + tableName + "." + attr.FieldName + "]</td>"; } i++; } Response.Write(DEFAULT_TEMPLATE_START + html + DEFAULT_TEMPLATE_END); return; } TF_CUSTOM_TEMPLATE conf = new TF_CUSTOM_TEMPLATE(); conf.TEMPLATE_NAME = templateName; conf.TABLE_NAME = tableName; conf.USER_ID = Convert.ToInt32(userBase.StaffID); conf.TYPE = 0; TF_CUSTOM_TEMPLATE valObj=BLLTable<TF_CUSTOM_TEMPLATE>.GetRowData(conf); if (valObj == null) { Response.Write(""); } else { Response.Write(valObj.TEMPLATE_HTML); } }
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 + "\"}"); }
/// <summary> /// 生成标签模版 + 生成值 /// </summary> protected void TagBinding(Page page, List <Literal> lits, ITableImplement valObj, ITableImplement condObj, List <ITableImplement> listObj) { //isModule = true; Content c1 = (Content)(page.FindControl("Content2")); Literal Lit_Finder = (Literal)(page.FindControl("Lit_Finder")); foreach (Literal lit in lits) { if (lit == null) { continue; } if (lit.ID == "Lit_Finder") { string old1 = lit.Text; lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetTemplate(old1, valObj, condObj); lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetHTML(lit.Text, condObj); } else if (lit.ID == "Lit_ListHeader") { string old1 = lit.Text; lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetTemplate(old1, valObj); lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetHTML(lit.Text, valObj); } else if (lit.ID == "Lit_RepList") { string old1 = lit.Text; if (listObj.Count > 0) { lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetTemplate(old1, listObj[0]); lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetHTML(lit.Text, listObj); } else { lit.Text = ""; } } else { string old1 = lit.Text; lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetTemplate(old1, valObj); lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetHTML(lit.Text, valObj); } } }
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 static ITableImplement getITableByJson(string tableName, string valJson) { ITableImplement ITable = new ITableImplement(tableName); JavaScriptSerializer jss = new JavaScriptSerializer(); Dictionary <string, object> valMap = jss.Deserialize <Dictionary <string, object> >(valJson); List <AttributeItem> items = new List <AttributeItem>(); foreach (var val in valMap) { items.Add(new AttributeItem(tableName, val.Key)); } ITable.Add(items.ToArray()); foreach (AttributeItem item in items) { ITable[item] = valMap[item.FieldName]; } return(ITable); }
private void getTemplateNameOptions() { 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); string html = "<option value='-1'>--无--</option>"; foreach (V_TF_TEMPLATE_TABLENAME temp in templateList) { ITableImplement itable = new ITableImplement(); itable.setConn(conn).setModule(temp.TABLE_NAME); html += "<option value='" + temp.TABLE_NAME + "'>" + temp.CH_NAME + "</option>"; } Response.Write("{\"html\":\"" + html + "\"}"); }
protected void Page_Load(object sender, EventArgs e) { //base.Page_Init(sender, e); //初始化模块加载参数 base.InitModule(ref valObj, ref KeyID, ref fieldList); title = valObj._ZhName + "详细"; Page.Title = title; if (!IsPostBack) { try { resultObj.IsOnlyForModuleIDName = false; valObj.IsOnlyForModuleIDName = false; if (!string.IsNullOrEmpty(Request["ID"])) { AttributeItem id1 = AttributeItem.Factory(valObj.DataBaseTable.IDField); ITableImplement cond1 = new ITableImplement(); cond1.SetValue(id1, Request["ID"]); resultObj = BLLTable <ITableImplement> .Factory(conn).GetRowData(valObj, cond1); if (resultObj == null) { ScriptHelper.Alert(this, "记录不存在"); ScriptHelper.CloseMe(this); return; } BLLTable.SQL_Test.ToArray(); object obj1 = resultObj.GetValue(WEC_A_VOTE.Attribute.TITLE); } } catch (Exception ex) { //litWarn.Text = ex.Message; } } }
public JsonData Add(ITableImplement table) { this.table = table; return(this); }
protected void Page_Load(object sender, EventArgs e) { try { #region 输入参数:数据模型、采用此布局模型展示 if (Request["ModuleType"] != null) { string ModuleType = ""; if (Request["ModuleType"] != null) { ModuleType = Convert.ToString(Request["ModuleType"]); } //是模块,则设置 取值、条件对象 等。 if (ModuleType == "TF_TABLE") { msg = "未制定表名"; string ModuleTbName = Convert.ToString(Request["moduleName"]); if (string.IsNullOrEmpty(ModuleTbName)) { Response.Write(msg); Response.End(); } TF_TABLE condObj1 = new TF_TABLE(); condObj1.TB_NAME = ModuleTbName; SetRequest(condObj1); bool ret1 = AgileFrame.Common.TF_TABLEHelper.Factory(conn).Parse(condObj1, out valObj, out condObj, out relationList, out otherValueList, out condList, ref msg);//获取数据域(不是显示域) msg = "制定模块的数据模型未存在,请安装此模块"; if (!ret1) { Response.Write(msg); Response.End(); } //设置条件对象 SetRequest(condObj); SetRequest(condList); } } else { valObj = new ITableImplementHelper(conn).Factory("TF_TABLE"); condObj = new ITableImplementHelper(conn).Factory("TF_TABLE"); //(ITableImplement)valObj.Clone();// } #endregion title = valObj._ZhName + "管理"; Page.Title = title; if (Request["PID"] != null) { pid = Request["PID"]; } if (Request["submit"] != null) { } if (!IsPostBack) { #region //默认属性初始化 aspPager.CurrentPageIndex = 1; aspPager.ShowInputBox = AgileFrame.Core.WebSystem.ShowInputBox.Auto; //.WebCtrls //txtPageSize.Value = "2"; aspPager.PageSize = 30; //if (pid == "" || pid == "0") //{ // a_top.Visible = false; //} #endregion #region//条件 BindCondition(); #endregion #region//数据初始化 //txtTB_TYPE.Items.AddRange(FormHelper.GetListItem(TF_TABLE.Attribute.TB_TYPE)); #endregion BindList(1); } //Lit_ToolLeftButton; } catch (Exception ex) { HandleError(ex); } }
//抽象封装 private string getTree(ITableImplement val, AttributeItem pid, AttributeItem sortAttr, AttributeItem a) { return ""; }
/// <summary> /// 从取值对象中获得属性,从条件对象中获得值 /// </summary> /// <param name="valObj"></param> /// <param name="condObj"></param> /// <returns></returns> public List<DataBaseField> Parse(ITableImplement valObj, ITableImplement condObj) { List<DataBaseField> list2 = new List<DataBaseField>(); List<AttributeItem> list = new List<AttributeItem>(); list.AddRange(valObj.af_GetAvailableAttributeItem()); if (list.Count == 0) list.AddRange(valObj.af_AttributeItemList); string tbName = valObj._TableName.ToLower(); if (tbName == ITableImplement.defaultTableName.ToLower()) tbName = list[0].TableName; #region 表操作 DataBaseTable dt1 = null; dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[tbName]; if (dt1 == null) { ConsoleService.Warn(tbName + " 数据表不存在"); return new List<DataBaseField>(); } #endregion foreach (AttributeItem item in list) { string fieldName = item.FieldName.ToLower(); #region 列操作 DataBaseField f1 = null; if (!dt1.DataFields.TryGetValue(fieldName, out f1)) { ConsoleService.Warn(string.Format("数据表{0},数据字段{1}不存在", tbName, fieldName)); continue; } if (f1.Desc.CtrlType == BaseCtrlType.Text || f1.Desc.CtrlType == BaseCtrlType.HTML || f1.Desc.CtrlType == BaseCtrlType.SmallText) continue; if (condObj != null && condObj.IsNotNull()) f1.Value = condObj.GetString(item); #endregion list2.Add(f1); } return list2; }
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); } }
private void BindData(ITableImplement con, int pageCur, AspNetPager asppager) { int recount = -1; asppager.PageSize = 20; switch (asppager.ID) { case "aspAllCusPager": case "aspContractedPager": V_CRM_STAFF_CUSTOMER vcrmscCon = con as V_CRM_STAFF_CUSTOMER; if (vcrmscCon == null) { return; } if (asppager.ID == "aspAllCusPager") { hidAllCus.Value = JsonServiceBase.ToJson <V_CRM_STAFF_CUSTOMER>(vcrmscCon); } else { hidContracted.Value = JsonServiceBase.ToJson <V_CRM_STAFF_CUSTOMER>(vcrmscCon); } vcrmscCon.af_PageBy(V_CRM_STAFF_CUSTOMER.Attribute.Cus_ID, Order.Desc); V_CRM_STAFF_CUSTOMER valsc = new V_CRM_STAFF_CUSTOMER(); valsc._SID = ""; valsc.Cus_ID = 0; valsc.CompanyName = ""; valsc.ShopName = ""; valsc.Cus_Name = ""; valsc.CustQQ = ""; valsc.WangWangId = ""; valsc.LastContactTime = DateTime.MinValue; valsc.SNAME = ""; valsc.CustStatus = 0; if (vcrmscCon.af_PageByAttributeItem == null) //如果不存在用户定义的分页排序属性,则用主键属性排序 { vcrmscCon.af_PageBy(V_CRM_STAFF_CUSTOMER.Attribute.Cus_ID, Order.Desc); } List <V_CRM_STAFF_CUSTOMER> vcrmscList = BLLTable <V_CRM_STAFF_CUSTOMER> .Factory(conn).SelectByPage(valsc, vcrmscCon, asppager.PageSize, pageCur, ref recount); if (vcrmscList.Count > 0) { FormHelper.Bind(Page, vcrmscList[0].DicAttrValues); //BindToFindSelect(listObj[0].DicAttrValues); } if (asppager.ID == "aspAllCusPager") { repAllCusList.DataSource = vcrmscList; repAllCusList.DataBind(); } else { lit_ContractedCusCount.Text = recount.ToString(); repContractedList.DataSource = vcrmscList; repContractedList.DataBind(); } asppager.RecordCount = recount; break; case "aspToDayMustConPager": case "aspExpiredPager": case "aspWillInHighSeasPager": V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscnCon = con as V_CRM_STAFF_CUSTOMER_NOTCONTACT; if (vcrmscnCon == null) { return; } if (asppager.ID == "aspToDayMustConPager") { hidToDayMustCon.Value = JsonServiceBase.ToJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon); } else if (asppager.ID == "aspExpiredPager") { hidExpired.Value = JsonServiceBase.ToJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon); } else { hidWillInHighSeas.Value = JsonServiceBase.ToJson <V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon); } vcrmscnCon.af_PageBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.Cus_ID, Order.Desc); V_CRM_STAFF_CUSTOMER_NOTCONTACT valscn = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); valscn.STAFF_ID = 0; valscn.Cus_ID = 0; valscn.CompanyName = ""; valscn.ShopName = ""; valscn.Cus_Name = ""; valscn.CustQQ = ""; valscn.WangWangId = ""; valscn.LastContactTime = DateTime.MinValue; valscn.NextContactTime = DateTime.MinValue; valscn.SNAME = ""; valscn.CustStatus = 0; if (vcrmscnCon.af_PageByAttributeItem == null) //如果不存在用户定义的分页排序属性,则用主键属性排序 { vcrmscnCon.af_PageBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.Cus_ID, Order.Desc); } List <V_CRM_STAFF_CUSTOMER_NOTCONTACT> vcrmscnList = BLLTable <V_CRM_STAFF_CUSTOMER_NOTCONTACT> .Factory(conn).SelectByPage(valscn, vcrmscnCon, asppager.PageSize, pageCur, ref recount); if (vcrmscnList.Count > 0) { FormHelper.Bind(Page, vcrmscnList[0].DicAttrValues); //BindToFindSelect(listObj[0].DicAttrValues); } if (asppager.ID == "aspToDayMustConPager") { lit_todayConCusCount.Text = recount.ToString(); repToDayMustConList.DataSource = vcrmscnList; repToDayMustConList.DataBind(); } else if (asppager.ID == "aspExpiredPager") { lit_ExpiredUnConCusCount.Text = recount.ToString(); repExpiredList.DataSource = vcrmscnList; repExpiredList.DataBind(); } else { lit_WillInHighSeasCusCount.Text = recount.ToString(); repWillInHighSeasList.DataSource = vcrmscnList; repWillInHighSeasList.DataBind(); } asppager.RecordCount = recount; break; default: break; } }
private void SetRequest(ITableImplement condRequest) { foreach (AttributeItem attr in condRequest.af_AttributeItemList) { if (!string.IsNullOrEmpty(Request[attr.FieldCtrlName])) condRequest.SetValue(attr, Request[attr.FieldCtrlName]); else if (!string.IsNullOrEmpty(Request[attr.FieldName])) condRequest.SetValue(attr, Request[attr.FieldName]); } }
/// <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()); }
private void getTemplateNameOptions() { 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); string html = "<option value='-1'>--无--</option>"; foreach (V_TF_TEMPLATE_TABLENAME temp in templateList) { ITableImplement itable = new ITableImplement(); itable.setConn(conn).setModule(temp.TABLE_NAME); html += "<option value='" + temp.TABLE_NAME + "'>" + temp.CH_NAME + "</option>"; } Response.Write("{\"html\":\"" + html + "\"}"); }
public JsonData Add(ITableImplement table, string tableName) { return(Add(tableName, table)); }
//抽象封装 private string getTree(ITableImplement val, AttributeItem pid, AttributeItem sortAttr, AttributeItem a) { return(""); }
int recount = -1; //��ѯ�ܼ�¼�� #endregion Fields #region Methods /// <summary> /// ��ȡlistҳ������Դ /// ֧����ģ������� /// ֧��ö���� /// ֧��ʱ���ʽ /// </summary> /// <param name="f1"></param> /// <returns></returns> public string GetHtmlList(DataBaseField f1, ITableImplement this1) { string html = ""; try { DataBaseTable dt1 = f1.DataBaseTable; if (f1 != dt1.IDField && f1 != dt1.NameField) { if (!f1.Desc.af_Enable) return "";//�Ƿ���� if (!f1.Desc.af_Visable) return "";//�Ƿ�ɼ� } AttributeItem attr1 = AttributeItem.Factory(f1); object value1 = (this1.GetValue(attr1)); //DataBaseField f1; DataBaseField id1 = dt1.IDField; DataBaseField name1 = dt1.NameField; if (f1 == dt1.IDField)//����ֶ� { //html = "<a href='index.aspx?id=" + this1.GetValue(dt1.FieldID.FieldName) + "'>" + html + "</a>"; } else if (f1 == dt1.NameField)// != null && dt1.NameField.FieldName == f1.FieldName)//��ģ��name��ϸ���� { string showUrl = "../" + f1.TableName + "/show.aspx"; if (!Exist(showUrl)) { showUrl = "show.aspx"; } html = "<a href='" + showUrl + "?id=" + this1.GetValue(id1) + "&moduleName=" + f1.TableName + "' target='_blank'>" + value1 + "</a>"; } else if (isSelect(f1))//ö���� { string str=Convert.ToString(value1); if (str.Contains(",")) { //��ѡ string[] strs = str.Split(','); List<object> valueList = new List<object>(strs); List<object> nameList = BaseFormHelper.Factory(this1.ConnectKey).GetOptionText(attr1, valueList); StringBuilder sb = new StringBuilder(); foreach(object s in nameList){ String ss=Convert.ToString(s); sb.Append(ss+","); } html = sb.ToString(); html=html.Substring(0,html.LastIndexOf(",")); } else { //��ѡ html = BaseFormHelper.Factory(this1.ConnectKey).GetOptionText(attr1, value1); } } else if (isChaZhao(f1))//���� { DataBaseField f2 = f1.DataBaseTable.FatherTable_ChaZhao[0].DataBaseTable.NameField; AttributeItem attr2 = AttributeItem.Factory(f2); html = Convert.ToString(this1.GetValue(attr2)); //Ϊ�����ı��name�������� string showUrl = "../" + f1.TableName + "/show.aspx"; if (!Exist(showUrl)) { showUrl = "show.aspx"; } html = "<a href='" + showUrl + "?id=" + this1.GetValue(id1) + "&moduleName=" + f1.TableName + "' target='_blank'>" + html + "</a>"; } else if (f1.Desc.Switch_CtrlType == BaseCtrlType.FileUpImage) { html = "<img src ='" + value1 + "' style='height:40px' />"; } else if (f1.Desc.Switch_CtrlType == BaseCtrlType.FileUpUpDoc) {// if(!value1.Equals(" ")){ string val = Convert.ToString(value1); string[] strs = val.Split(';'); for (int i = 0; i < strs.Length - 1; i++) { string[] ss=strs[i].Split(','); string title = ss[0]; string url=ss[1]; html += "<span>" + title + " <a href='Back.aspx?moduleName="+ModuleName+"&download=true&filename="+url+"'>����</a></span>"; } } } if (html == "") { html = Convert.ToString(value1); } } catch (Exception ex) { Cs.Error(ex.ToString()); } return html;//.TrimEnd('\n').TrimEnd('\r').Trim(); }
protected void Page_Load(object sender, EventArgs e) { //base.Page_Init(sender, e); //��ʼ��ģ����ز��� base.InitModule(ref valObj, ref KeyID, ref fieldList); if (!string.IsNullOrEmpty(ModuleName)) { condObj.af_PageBy(KeyID, Order.Desc); finderObj._TableName = valObj._TableName; } 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 Page_Load(object sender, EventArgs e) { try { #region �������������ģ�͡����ô˲���ģ��չʾ if (Request["ModuleType"] != null) { string ModuleType = ""; if (Request["ModuleType"] != null) { ModuleType = Convert.ToString(Request["ModuleType"]); } //��ģ�飬������ ȡֵ���������� �ȡ� if (ModuleType == "TF_TABLE") { msg = "δ�ƶ�����"; string ModuleTbName = Convert.ToString(Request["moduleName"]); if (string.IsNullOrEmpty(ModuleTbName)) { Response.Write(msg); Response.End(); } TF_TABLE condObj1 = new TF_TABLE(); condObj1.TB_NAME = ModuleTbName; SetRequest(condObj1); bool ret1 = AgileFrame.Common.TF_TABLEHelper.Factory(conn).Parse(condObj1, out valObj, out condObj, out relationList, out otherValueList, out condList, ref msg);//��ȡ������(������ʾ��) msg = "�ƶ�ģ�������ģ��δ���ڣ��밲װ��ģ��"; if (!ret1) { Response.Write(msg); Response.End(); } //������������ SetRequest(condObj); SetRequest(condList); } } else { valObj = new ITableImplementHelper(conn).Factory("TF_TABLE"); condObj = new ITableImplementHelper(conn).Factory("TF_TABLE"); //(ITableImplement)valObj.Clone();// } #endregion title = valObj._ZhName + "����"; Page.Title = title; if (Request["PID"] != null) { pid = Request["PID"]; } if (Request["submit"] != null) { } if (!IsPostBack) { #region//Ĭ�����Գ�ʼ�� aspPager.CurrentPageIndex = 1; aspPager.ShowInputBox = AgileFrame.Core.WebSystem.ShowInputBox.Auto;//.WebCtrls //txtPageSize.Value = "2"; aspPager.PageSize = 30; //if (pid == "" || pid == "0") //{ // a_top.Visible = false; //} #endregion #region//���� BindCondition(); #endregion #region//���ݳ�ʼ�� //txtTB_TYPE.Items.AddRange(FormHelper.GetListItem(TF_TABLE.Attribute.TB_TYPE)); #endregion BindList(1); } //Lit_ToolLeftButton; } catch (Exception ex) { HandleError(ex); } }
/// <summary> /// ���ɱ�ǩģ�� + ����ֵ /// </summary> protected void TagBinding(Page page, List<Literal> lits, ITableImplement valObj, ITableImplement condObj, List<ITableImplement> listObj) { //isModule = true; Content c1 = (Content)(page.FindControl("Content2")); Literal Lit_Finder = (Literal)(page.FindControl("Lit_Finder")); foreach (Literal lit in lits) { if (lit == null) continue; if (lit.ID == "Lit_Finder") { string old1 = lit.Text; lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetTemplate(old1, valObj, condObj); lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetHTML(lit.Text, condObj); } else if (lit.ID == "Lit_ListHeader") { string old1 = lit.Text; lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetTemplate(old1, valObj); lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetHTML(lit.Text, valObj); } else if (lit.ID == "Lit_RepList") { string old1 = lit.Text; if (listObj.Count > 0) { lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetTemplate(old1, listObj[0]); lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetHTML(lit.Text, listObj); } else lit.Text = ""; } else { string old1 = lit.Text; lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetTemplate(old1, valObj); lit.Text = new AgileFrame.Common.TF_TABLEHelper(conn).GetHTML(lit.Text, valObj); } } }
private bool initParam() { if (string.IsNullOrEmpty(Request["template"]))//表名 DBTableName = Convert.ToString(Request["template"]); if (string.IsNullOrEmpty(Request["template_id"]))//表的id ID_FIELD = Convert.ToString(Request["template_id"]); if (string.IsNullOrEmpty(Request["template_name"]))//表的名称 NAME_FIELD = Convert.ToString(Request["template_name"]); if (string.IsNullOrEmpty(Request["template_pid"]))//表的父对象id PID_FIELD = Convert.ToString(Request["template_pid"]); if (string.IsNullOrEmpty(Request["template_type"]))//是否为树结构 IsTypeTree = Convert.ToString(Request["template_type"]); itable = new ITableImplementHelper(conn).Factory(DBTableName); if (string.IsNullOrEmpty(DBTableName) ||string.IsNullOrEmpty(ID_FIELD) || string.IsNullOrEmpty(NAME_FIELD) ||itable == null || itable.IsNull() ) { return false; } return true; }
/// <summary> /// TF_FORM 从配置中获得表单布局 /// </summary> /// <param name="conn"></param> /// <param name="cond"></param> /// <returns></returns> public bool Parse(TF_TABLE cond, out ITableImplement valObj, out ITableImplement condObj, out List <Relation> relationList, out List <ITableImplement> otherValueList, out List <ITableImplement> condList, ref string msg) { valObj = new ITableImplement(); condObj = new ITableImplement(); //载入关系 otherValueList = new List <ITableImplement>(); condList = new List <ITableImplement>(); relationList = new List <Relation>(); msg = "条件不存在"; if (string.IsNullOrEmpty(cond.TB_NAME)) { return(false); } DataBaseTable tb1; List <DataBaseField> listf1 = new List <DataBaseField>(); List <DataBaseTable> listTb1 = new List <DataBaseTable>(); bool ret = true; tb1 = null; //TF_TABLE val = BLLTable<TF_TABLE>.Factory(conn).GetRowData(new TF_TABLE(), cond); TF_TB_FIELD val1 = new TF_TB_FIELD(); TF_F_COLUMN val2 = new TF_F_COLUMN(); TF_TABLE val3 = new TF_TABLE(); TF_TB_FIELD cond1 = new TF_TB_FIELD(); TF_F_COLUMN cond2 = new TF_F_COLUMN(); TF_FORM cond3 = new TF_FORM(); List <ITableImplement> otherValueList1 = new List <ITableImplement>(); List <ITableImplement> condList1 = new List <ITableImplement>(); otherValueList1.Add(val2); otherValueList1.Add(val3); condList1.Add(cond); List <Relation> relationList1 = new List <Relation>(); relationList1.Add(RelationFactory.TF_TABLE_TF_FORM); relationList1.Add(RelationFactory.TF_TABLE_TF_TB_FIELD); relationList1.Add(RelationFactory.TF_TB_FIELD_TF_F_COLUMN); int pageSize = 100; int pageIndex = 1; int recount = -1; string cachekey = null; List <TF_TB_FIELD> list1 = BLLTable <TF_TB_FIELD> .Factory(conn).SelectByPage(val1, relationList1, otherValueList1, condList1, pageSize, pageIndex, ref recount, out cachekey); if (list1.Count == 0) { DataBaseTable dt1 = null; dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[cond.TB_NAME]; msg = cond.TB_NAME + " 数据表不存在"; if (dt1 == null) { ret = false; ConsoleService.Warn(msg); } return(ret); } if (list1.Count > 90) { msg = "条件错误,所配置的字段记录超过90"; return(false); } //生成布局模版用 tb1 = new DataBaseTable(); foreach (TF_TB_FIELD item in list1) { string tbName = Convert.ToString(item.GetValue(TF_TABLE.Attribute.TB_NAME)).ToLower(); #region 表操作 DataBaseTable dt1 = null; dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[tbName]; msg = tbName + " 数据表不存在"; ret = false; if (dt1 == null) { ConsoleService.Warn(msg); return(ret); } tb1 = dt1; listTb1.Add(dt1); //是否显示 object obj1 = null; object obj2 = null; object obj3 = null; if (item.TryGetValue(TF_FORM.Attribute.FORM_ID, out obj1)) { dt1.IsVisable = true; } #endregion string fieldName = item.FIELD_NAME.ToLower(); #region 列操作 DataBaseField f1 = null; msg = string.Format("数据表{0},数据字段{1}不存在", tbName, fieldName); if (!dt1.DataFields.TryGetValue(fieldName, out f1)) { ret = false; ConsoleService.Warn(msg); continue; } //是否显示 obj1 = null; obj2 = null; obj3 = null; if (item.TryGetValue(TF_F_COLUMN.Attribute.COLUMN_ID, out obj1) && item.TryGetValue(TF_F_COLUMN.Attribute.SHOW_NAME, out obj2) && item.TryGetValue(TF_F_COLUMN.Attribute.CTRL_TYPE, out obj3)) { //f1.IsVisable = true; } #endregion listf1.Add(f1); } //取值对象 valObj = ITableImplement.Factory(tb1); //其他取值对象 foreach (DataBaseTable tb2 in listTb1) { if (tb2.TableName == tb1.TableName) { continue; } otherValueList.Add(ITableImplement.Factory(tb2)); } //关系呢 return(ret); }
/// <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> /// //自身为树,可以按照类型进行 树节点外观区别 /// //子相关对象 /// </summary> /// <param name="p_tableTree"></param> /// <param name="itables"></param> private void setTree(ITableTree p_tableTree, List <ITableTree> ListTables) { string p_tableStr = p_tableTree.val.TableName(); ITableImplement p_table1 = ((ITableImplement)p_tableTree.val.Clone()); p_table1.LoadAllAttributes(true); if (string.IsNullOrEmpty(p_table1.af_OrderByText) && p_tableTree.SORT_NO != null) { p_table1.OrderBy(p_tableTree.SORT_NO, Order.Asc); } #region 树 TF_TABLE #region//显示子节点 TF_TABLE if (Request["getSubNodes"] != null) { string nodetype = Request["ntype"]; StringBuilder sb = new StringBuilder("["); string id = Request["id"]; string p_name = null; string p_note = null; string s_name = null; string s_note = null; if (nodetype == p_tableStr + "-root") { #region ITableImplement obj = p_tableTree.val; if (!obj.GetInitialized(p_tableTree.M_ID)) { obj.SetValue(p_tableTree.M_ID, 0); } // p_table1.Top(1000); List <ITableImplement> lst = BLLTable <ITableImplement> .Factory(conn).Select(p_table1, obj); if (lst.Count != null) { for (int i = 0; i < lst.Count; i++) { if (sb.Length > 2) { sb.Append(","); } sb.Append("{id:'").Append(lst[i].GetValue(p_tableTree.ID)).Append("'"); sb.Append(",pid:'").Append("0").Append("',no:").Append((p_tableTree.SORT_NO != null)?lst[i].GetValue(p_tableTree.SORT_NO):"1"); p_name = Convert.ToString(lst[i].GetValue(p_tableTree.NAME)); if (string.IsNullOrEmpty(p_name)) { p_name = p_note; "".ToString(); } else if (p_tableTree.NOTE != null) { p_note = Convert.ToString(lst[i].GetValue(p_tableTree.NOTE)); p_note = setNote(p_note, "", p_tableTree); sb.Append(",note:'[").Append(p_note).Append("]'"); } sb.Append(",name:'").Append(p_name).Append("'"); sb.Append(",sc:").Append("-1"); //CHG START 区分表管理和表单管理 jin-shenjian 2013/10/30 //sb.Append(",ntype:'" + p_tableStr + "'}"); if (p_tableStr.Equals("TF_FORM")) { //表单管理 sb.Append(",ntype:'" + p_tableStr + "_MANAGE'}"); } else { //表管理 sb.Append(",ntype:'" + p_tableStr + "'}"); } //CHG END 区分表管理和表单管理 jin-shenjian 2013/10/30 } } #endregion } //CHG START 增加树关系管理,布局管理,列表布局菜单 jin-shenjian 2013/10/30 //表单列表下添加三个管理菜单 else if (nodetype == p_tableStr + "_MANAGE") { sb.Append("{id:'").Append(id).Append("'"); sb.Append(",pid:'").Append(id).Append("',no:").Append("1"); sb.Append(",name:'").Append("字段管理").Append("'"); sb.Append(",sc:").Append("-1"); sb.Append(",ntype:'" + p_tableStr + "'}"); sb.Append(","); sb.Append("{id:'").Append(id).Append("'"); sb.Append(",pid:'").Append(id).Append("',no:").Append("1"); sb.Append(",name:'").Append("关系管理").Append("'"); sb.Append(",sc:").Append("-1"); sb.Append(",ntype:'TF_TB_RELA'}"); sb.Append(","); sb.Append("{id:'").Append(id).Append("'"); sb.Append(",pid:'").Append(id).Append("',no:").Append("1"); sb.Append(",name:'").Append("布局管理").Append("'"); sb.Append(",sc:").Append("-1"); sb.Append(",ntype:'TF_FORM_DESIGN'}"); } //布局管理下添加两个子菜单 else if (nodetype == p_tableStr + "_DESIGN") { sb.Append("{id:'").Append(id).Append("1'"); sb.Append(",pid:'").Append(id).Append("',no:").Append("1"); sb.Append(",name:'").Append("列表布局").Append("'"); sb.Append(",sc:").Append("0"); sb.Append(",ntype:'TF_DESIGN_LIST'}"); sb.Append(","); sb.Append("{id:'").Append(id).Append("2'"); sb.Append(",pid:'").Append(id).Append("',no:").Append("1"); sb.Append(",name:'").Append("详细布局").Append("'"); sb.Append(",sc:").Append("0"); sb.Append(",ntype:'TF_DESIGN_DETAIL'}"); } //ADD END 增加树关系管理,布局管理,列表布局菜单 jin-shenjian 2013/10/30 else if (nodetype == p_tableStr)//table1type.Contains(nodetype)) { //if (nodetype == "TF_TABLE")//明细表,将不会再有子级的明细表。。。 { #region ITableImplement objTB = p_tableTree.val; objTB.SetValue(p_tableTree.M_ID, int.Parse(id)); // p_table1.Top(1000); List <ITableImplement> lst = BLLTable <ITableImplement> .Factory(conn).Select(p_table1, objTB); if (lst.Count != null) { for (int i = 0; i < lst.Count; i++) { if (sb.Length > 2) { sb.Append(","); } sb.Append("{id:'").Append(lst[i].GetValue(p_tableTree.ID)).Append("'"); sb.Append(",pid:'").Append(id).Append("',no:").Append((p_tableTree.SORT_NO != null)?lst[i].GetValue(p_tableTree.SORT_NO):"1"); p_name = Convert.ToString(lst[i].GetValue(p_tableTree.NAME)); if (string.IsNullOrEmpty(p_name)) { p_name = p_note; "".ToString(); } else if (p_tableTree.NOTE != null) { p_note = Convert.ToString(lst[i].GetValue(p_tableTree.NOTE)); p_note = setNote(p_note, "", p_tableTree); sb.Append(",note:'[").Append(p_note).Append("]'"); } sb.Append(",name:'").Append(p_name).Append("'"); sb.Append(",sc:").Append("1"); sb.Append(",ntype:'" + p_tableStr + "'}");//TF_TABLE-mx } } #endregion } #region if (ListTables.Count > 0) { foreach (ITableTree s_tableTree1 in ListTables) { ITableImplement val1 = ((ITableImplement)s_tableTree1.val.Clone()); string table1 = val1.TableName(); if (string.IsNullOrEmpty(val1.af_OrderByText) && s_tableTree1.SORT_NO != null) { val1.OrderBy(s_tableTree1.SORT_NO, Order.Asc); } // val1.Top(1000); ITableImplement condObj = ((ITableImplement)s_tableTree1.val.Clone()); condObj.SetValue(p_tableTree.ID, int.Parse(id)); List <ITableImplement> otherValue = new List <ITableImplement>(); otherValue.Add(p_table1); List <ITableImplement> condtions = new List <ITableImplement>(); condtions.Add(condObj); List <ITableImplement> lst = BLLTable <ITableImplement> .Factory(conn).Select(val1, s_tableTree1.relations, otherValue, condtions); if (lst.Count > 0) { for (int i = 0; i < lst.Count; i++) { if (sb.Length > 2) { sb.Append(","); } ITableImplement table = lst[i]; sb.Append("{id:'").Append(table.GetValue(s_tableTree1.ID)).Append("'"); sb.Append(",pid:'").Append(table.GetValue(s_tableTree1.M_ID)).Append("',no:") .Append((s_tableTree1.SORT_NO != null)?table.GetValue(s_tableTree1.SORT_NO):"1"); s_name = Convert.ToString(table.GetValue(s_tableTree1.NAME)); sb.Append(",name:'").Append(s_name).Append("'"); if (s_tableTree1.NOTE != null) { s_note = Convert.ToString(table.GetValue(s_tableTree1.NOTE)); if (s_tableTree1.NAME.TableName == "TF_TB_FIELD") { s_note = setNote(table.GetValue("TF_TABLE", "TB_NAME"), s_note, s_tableTree1); } sb.Append(",note:'[").Append(s_note).Append("]'"); } sb.Append(",sc:").Append("0"); sb.Append(",ntype:'" + table1 + "'}"); } } } } #endregion } else { sb = new StringBuilder(); } //sb.Append("{id:'").Append("1"); //sb.Append("',pid:'").Append("0").Append("',no:").Append("1"); //sb.Append(",sc:").Append("1"); //sb.Append(",name:'").Append("aaaaa(aaa)").Append("',ntype:'TF_FORM'}"); if (sb.Length > 1) { sb.Append("]"); } Response.Write(sb.ToString()); } #endregion #region//删除节点 if (Request["deleteNode"] != null) { string str = ""; string delID = Request["id"]; string ntype = Request["ntype"]; //CHG START 删除表单判断变更 jin-shenjian 2013/10/30 //if (ntype == p_tableStr)//if (ntype == "table" || ntype == "TF_TABLE-mx") if (ntype == p_tableStr + "_MANAGE" || ntype == p_tableStr)//if (ntype == "table" || ntype == "TF_TABLE-mx") //CHG END 删除表单判断变更 jin-shenjian 2013/10/30 { #region //删除表 int re = 0; string msg = "删除数据对象成功!"; // "删除数据库表成功!"; ITableImplement cccSub = ((ITableImplement)p_tableTree.val.Clone()); cccSub.SetValue(p_tableTree.M_ID, int.Parse(delID)); bool isAllowDel = true; if (BLLTable <ITableImplement> .Count(cccSub) > 0) { isAllowDel = false; msg = "存在明细对象,不能删除此对象";//"存在明细表,不能删除!"; } else //相关子对象,相关子对象如果存在,能否被删除呢。级联删除。 { if (ListTables.Count > 0)// "存在字段,不能删除此表"; { foreach (ITableTree sub_table1 in ListTables) { ITableImplement hadcol = ((ITableImplement)sub_table1.val.Clone()); hadcol.SetValue(sub_table1.M_ID, int.Parse(delID)); if (BLLTable <ITableImplement> .Exists(hadcol)) { msg = "存在相关对象(子对象),不能删除此对象"; isAllowDel = false; break; } } } } if (isAllowDel) { //外部条件 //TF_FORM useTB = new TF_FORM(); //useTB.Where("TB_ID=" + delID + " or TB_IDS like '%," + delID + ",%'"); //if (BLLTable<TF_FORM>.Exists(useTB)) //{ // msg = "此表已倍表单使用,不能删除"; // goto _no_del; //} re = BLLTable <ITableImplement> .Factory(conn).Delete(p_tableTree.ID, delID); if (re > 0) { //foreach (ITableTree sub_table1 in ListTables) //{ // //??? // if (BLLTable<ITableImplement>.Factory(conn).Delete(sub_table1.M_ID, delID) < 0) // { // msg = "删除数据对象成功,但删除子对象信息失败!"; // } // else msg = "删除数据对象成功!"; //} } else { msg = "删除数据对象失败!"; } //_no_del: } #endregion str = "{re:" + re + ",msg:'" + msg + "'}"; } else { if (ListTables.Count > 0) { foreach (ITableTree itable1 in ListTables) { if (ntype == itable1.val._TableName)//if (ntype == "field") { int re = 0; string msg = "删除数据对象成功!"; #region//删除表字段 //ADD START 更新表字段是否使用状态 jin-shenjian 2013/10/28 //更新表字段是否使用状态 if (ntype.Equals("TF_F_COLUMN")) { TF_F_COLUMN objCond = new TF_F_COLUMN(); objCond.COLUMN_ID = Convert.ToInt32(delID); TF_TB_FIELD objVal = new TF_TB_FIELD(); //字段未使用 objVal.CREATED = 0; int ret2 = BLLTable <TF_TB_FIELD> .Factory(conn).Update(objVal, objCond, new Relation(TF_TB_FIELD.Attribute.FIELD_ID, TF_F_COLUMN.Attribute.FIELD_ID)); } //ADD END 更新表字段是否使用状态 jin-shenjian 2013/10/28 int ret1 = BLLTable <ITableImplement> .Factory(conn).Delete(itable1.ID, delID); if (ret1 <= 0) { msg = "删除数据对象失败!"; } else { msg = "删除数据对象成功!"; } #endregion //CHG START 判断是否删除变量选错 jin-shenjian 2013/10/28 //str = "{re:" + re + ",msg:'" + msg + "'}"; str = "{re:" + ret1 + ",msg:'" + msg + "'}"; //CHG START 判断是否删除变量选错 jin-shenjian 2013/10/28 } } } } Response.Write(str); } #endregion #endregion 树 TF_TABLE }
////////////////////////////////////////////////////////////////////////////////////////////// /// <summary> /// 属性列表对象。适用于repList_ItemDataBound /// </summary> public string GetHTML(string templateList, ITableImplement valObj) { BuildByTemplate bt = new BuildByTemplate(BuildType.ForHtmlValue); bt.ConnectKey = conn; string htmlEdit = bt.BuildByStr(templateList, "bs", valObj, @"c:\123.txt"); return htmlEdit; }
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 + "\"}"); }
//递归遍历 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; }
protected void Page_Load(object sender, EventArgs e) { if(Request["deleteFile"]==null){ base.InitModule(ref valObj, ref KeyID, ref fieldList); } //���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼ if (Request["DelID"] != null) { valObj.SetValue(valObj.KeyID, Request["DelID"]); int re = BLLTable<ITableImplement>.Factory(conn).Delete(valObj); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼ if (Request["DelKeyIDS"] != null) { ITableImplement cond = valObj; cond.In(AttributeItem.Factory(cond.DataBaseTable.IDField), Request["DelKeyIDS"]); int re = BLLTable<ITableImplement>.Factory(conn).Delete(cond); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ��� if (Request["saveInfo"] != null) { valObj.SetValue(valObj.KeyID, Request["FieldKeyID"]); List<AttributeItem> lstCol = valObj.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName])) { valObj.SetValue(lstCol[i], Request["txt" + lstCol[i].FieldName]); } } BLLTable<ITableImplement>.Factory(conn).Update(valObj, valObj.KeyID); Response.Write("�ļ�¼��Ϣ�ɹ�"); } //ɾ�������ļ� if (Request["deleteFile"] != null) { //string filepath=WebHelper.GetAppPath() + Request["fileName"]; string filepath = System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + Request["fileName"]; ; if (File.Exists(filepath)) { File.Delete(filepath); } } //��ҳAJAX���� if(Request["paging"]!=null){ int pageSize = 10; int pageIndex = 1; int count1 = -1; pageIndex = Convert.ToInt32(HttpUtil.GetReqStrValue("pageIndex")); int num = Convert.ToInt32(HttpUtil.GetReqStrValue("num")); ; StringBuilder sb = new StringBuilder(); try { //DataBaseField[] flist = valObj.af_GetAvailableDataBaseField(); //foreach (DataBaseField f1 in flist) { //�����id object id1 = HttpUtil.GetReqStrValue("id1"); string tableName1 = "��ϵ��1"; if (valObj.DataBaseTable.SubTable_ChaZhao.Count > 0) { // foreach (DataBaseTableRelation dr1 in valObj.DataBaseTable.SubTable_ChaZhao) //{ DataBaseTableRelation dr1 = valObj.DataBaseTable.SubTable_ChaZhao[num]; 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>(); //��ʾ���Ա�� �������Ϣ //value2.setConn(conn).setModule("WEC_QC_CARS"); List<ITableImplement> list2 = BLLTable<ITableImplement>.Factory(conn).SelectByPage(value2, lstRel, lstOther, lstCond, pageSize, pageIndex, ref count1); // BLLTable.SQL_Test.ToString(); if (list2.Count > 0) { foreach (ITableImplement tb2 in list2) { sb.Append("<tr>"); foreach (DataBaseField d2 in tb2.af_GetAvailableDataBaseField()) { sb.Append("<td>" + GetHtmlList(d2, tb2) + ""); } sb.Append("</tr>"); } } } } } catch (Exception ex) { } Response.Write(sb.ToString()); } //�����ļ� if(Request["download"]!=null){ string filename = Request["filename"]; string fullpath =Request.PhysicalApplicationPath +filename; Response.ContentType = "APPLICATION/OCTET-STREAM"; Response.AddHeader("Content-Disposition", "attachment;filename=" + filename.Substring(filename.LastIndexOf("/") + 1)); FileStream fs = new FileStream(fullpath,FileMode.Open); int len=(int)fs.Length; byte[] buf = new byte[len]; int count; int sum = 0; while ((count = fs.Read(buf, 0, len)) > 0) { sum += count; Response.OutputStream.Write(buf,0,count); } } Response.End(); }
/// <summary> /// TF_FORM 从配置中获得表单布局 /// </summary> /// <param name="conn"></param> /// <param name="cond"></param> /// <returns></returns> public bool Parse(TF_TABLE cond, out ITableImplement valObj, out ITableImplement condObj, out List<Relation> relationList, out List<ITableImplement> otherValueList, out List<ITableImplement> condList, ref string msg) { valObj = new ITableImplement(); condObj = new ITableImplement(); //载入关系 otherValueList = new List<ITableImplement>(); condList = new List<ITableImplement>(); relationList = new List<Relation>(); msg = "条件不存在"; if (string.IsNullOrEmpty(cond.TB_NAME)) return false; DataBaseTable tb1; List<DataBaseField> listf1 = new List<DataBaseField>(); List<DataBaseTable> listTb1 = new List<DataBaseTable>(); bool ret = true; tb1 = null; //TF_TABLE val = BLLTable<TF_TABLE>.Factory(conn).GetRowData(new TF_TABLE(), cond); TF_TB_FIELD val1 = new TF_TB_FIELD(); TF_F_COLUMN val2 = new TF_F_COLUMN(); TF_TABLE val3 = new TF_TABLE(); TF_TB_FIELD cond1 = new TF_TB_FIELD(); TF_F_COLUMN cond2 = new TF_F_COLUMN(); TF_FORM cond3 = new TF_FORM(); List<ITableImplement> otherValueList1 = new List<ITableImplement>(); List<ITableImplement> condList1 = new List<ITableImplement>(); otherValueList1.Add(val2); otherValueList1.Add(val3); condList1.Add(cond); List<Relation> relationList1 = new List<Relation>(); relationList1.Add(RelationFactory.TF_TABLE_TF_FORM); relationList1.Add(RelationFactory.TF_TABLE_TF_TB_FIELD); relationList1.Add(RelationFactory.TF_TB_FIELD_TF_F_COLUMN); int pageSize = 100; int pageIndex = 1; int recount = -1; string cachekey = null; List<TF_TB_FIELD> list1 = BLLTable<TF_TB_FIELD>.Factory(conn).SelectByPage(val1, relationList1, otherValueList1, condList1, pageSize, pageIndex, ref recount, out cachekey); if (list1.Count == 0) { DataBaseTable dt1 = null; dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[cond.TB_NAME]; msg = cond.TB_NAME + " 数据表不存在"; if (dt1 == null) { ret = false; ConsoleService.Warn(msg); } return ret; } if (list1.Count > 90) { msg = "条件错误,所配置的字段记录超过90"; return false; } //生成布局模版用 tb1 = new DataBaseTable(); foreach (TF_TB_FIELD item in list1) { string tbName = Convert.ToString(item.GetValue(TF_TABLE.Attribute.TB_NAME)).ToLower(); #region 表操作 DataBaseTable dt1 = null; dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[tbName]; msg = tbName + " 数据表不存在"; ret = false; if (dt1 == null) { ConsoleService.Warn(msg); return ret; } tb1 = dt1; listTb1.Add(dt1); //是否显示 object obj1 = null; object obj2 = null; object obj3 = null; if (item.TryGetValue(TF_FORM.Attribute.FORM_ID, out obj1)) { dt1.IsVisable = true; } #endregion string fieldName = item.FIELD_NAME.ToLower(); #region 列操作 DataBaseField f1 = null; msg = string.Format("数据表{0},数据字段{1}不存在", tbName, fieldName); if (!dt1.DataFields.TryGetValue(fieldName, out f1)) { ret = false; ConsoleService.Warn(msg); continue; } //是否显示 obj1 = null; obj2 = null; obj3 = null; if (item.TryGetValue(TF_F_COLUMN.Attribute.COLUMN_ID, out obj1) && item.TryGetValue(TF_F_COLUMN.Attribute.SHOW_NAME, out obj2) && item.TryGetValue(TF_F_COLUMN.Attribute.CTRL_TYPE, out obj3)) { //f1.IsVisable = true; } #endregion listf1.Add(f1); } //取值对象 valObj = ITableImplement.Factory(tb1); //其他取值对象 foreach (DataBaseTable tb2 in listTb1) { if (tb2.TableName == tb1.TableName) continue; otherValueList.Add(ITableImplement.Factory(tb2)); } //关系呢 return ret; }
public string GetTemplate(string template, ITableImplement valObj, ITableImplement condObj) { try { BuildByTemplate bt = new BuildByTemplate(BuildType.ForHtmlTemplate); bt.ConnectKey = conn; string template1 = bt.BuildByStr(template, "bs", Parse(valObj, condObj), @"c:\123.txt"); return template1; } catch (Exception ex) { File.AppendAllText(Path.Combine(WebHelper.GetAppPath(), "abc.txt"), ex.ToString()); throw ex; } return ""; }
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; } }
protected void Page_Load(object sender, EventArgs e) { //base.Page_Init(sender, e); //��ʼ��ģ����ز��� base.InitModule(ref valObj, ref KeyID, ref fieldList); title = valObj._ZhName + "��ϸ"; Page.Title = title; if (!IsPostBack) { try { resultObj.IsOnlyForModuleIDName = false; valObj.IsOnlyForModuleIDName = false; if (!string.IsNullOrEmpty(Request["ID"])) { AttributeItem id1 = AttributeItem.Factory(valObj.DataBaseTable.IDField); ITableImplement cond1 = new ITableImplement(); cond1.SetValue(id1, Request["ID"]); resultObj = BLLTable<ITableImplement>.Factory(conn).GetRowData(valObj, cond1); if (resultObj == null) { ScriptHelper.Alert(this, "��¼������"); ScriptHelper.CloseMe(this); return; } BLLTable.SQL_Test.ToArray(); object obj1 = resultObj.GetValue(WEC_A_VOTE.Attribute.TITLE); } } catch (Exception ex) { //litWarn.Text = ex.Message; } } }
public JsonData Add(string tableName, ITableImplement table) { this.tableName = tableName; this.table = table; return(this); }
private void BindData(ITableImplement con, int pageCur, AspNetPager asppager) { int recount = -1; asppager.PageSize = 20; switch (asppager.ID) { case "aspAllCusPager": case "aspContractedPager": V_CRM_STAFF_CUSTOMER vcrmscCon = con as V_CRM_STAFF_CUSTOMER; if (vcrmscCon == null) return; if (asppager.ID == "aspAllCusPager") hidAllCus.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER>(vcrmscCon); else hidContracted.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER>(vcrmscCon); vcrmscCon.af_PageBy(V_CRM_STAFF_CUSTOMER.Attribute.Cus_ID, Order.Desc); V_CRM_STAFF_CUSTOMER valsc = new V_CRM_STAFF_CUSTOMER(); valsc._SID = ""; valsc.Cus_ID = 0; valsc.CompanyName = ""; valsc.ShopName = ""; valsc.Cus_Name = ""; valsc.CustQQ = ""; valsc.WangWangId = ""; valsc.LastContactTime = DateTime.MinValue; valsc.SNAME = ""; valsc.CustStatus = 0; List<V_CRM_STAFF_CUSTOMER> vcrmscList = BLLTable<V_CRM_STAFF_CUSTOMER>.Factory(conn).SelectByPage(valsc, vcrmscCon, asppager.PageSize, pageCur, ref recount); if (vcrmscList.Count > 0) { FormHelper.Bind(Page, vcrmscList[0].DicAttrValues); //BindToFindSelect(listObj[0].DicAttrValues); } if (asppager.ID == "aspAllCusPager") { repAllCusList.DataSource = vcrmscList; repAllCusList.DataBind(); } else { lit_ContractedCusCount.Text = recount.ToString(); repContractedList.DataSource = vcrmscList; repContractedList.DataBind(); } asppager.RecordCount = recount; break; case "aspToDayMustConPager": case "aspExpiredPager": case "aspWillInHighSeasPager": V_CRM_STAFF_CUSTOMER_NOTCONTACT vcrmscnCon = con as V_CRM_STAFF_CUSTOMER_NOTCONTACT; if (vcrmscnCon == null) return; if (asppager.ID == "aspToDayMustConPager") hidToDayMustCon.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon); else if (asppager.ID == "aspExpiredPager") hidExpired.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon); else hidWillInHighSeas.Value = JsonServiceBase.ToJson<V_CRM_STAFF_CUSTOMER_NOTCONTACT>(vcrmscnCon); vcrmscnCon.af_PageBy(V_CRM_STAFF_CUSTOMER_NOTCONTACT.Attribute.Cus_ID, Order.Desc); V_CRM_STAFF_CUSTOMER_NOTCONTACT valscn = new V_CRM_STAFF_CUSTOMER_NOTCONTACT(); valscn.STAFF_ID = 0; valscn.Cus_ID = 0; valscn.CompanyName = ""; valscn.ShopName = ""; valscn.Cus_Name = ""; valscn.CustQQ = ""; valscn.WangWangId = ""; valscn.LastContactTime = DateTime.MinValue; valscn.NextContactTime = DateTime.MinValue; valscn.SNAME = ""; valscn.CustStatus = 0; List<V_CRM_STAFF_CUSTOMER_NOTCONTACT> vcrmscnList = BLLTable<V_CRM_STAFF_CUSTOMER_NOTCONTACT>.Factory(conn).SelectByPage(valscn, vcrmscnCon, asppager.PageSize, pageCur, ref recount); if (vcrmscnList.Count > 0) { FormHelper.Bind(Page, vcrmscnList[0].DicAttrValues); //BindToFindSelect(listObj[0].DicAttrValues); } if (asppager.ID == "aspToDayMustConPager") { lit_todayConCusCount.Text = recount.ToString(); repToDayMustConList.DataSource = vcrmscnList; repToDayMustConList.DataBind(); } else if (asppager.ID == "aspExpiredPager") { lit_ExpiredUnConCusCount.Text = recount.ToString(); repExpiredList.DataSource = vcrmscnList; repExpiredList.DataBind(); } else { lit_WillInHighSeasCusCount.Text = recount.ToString(); repWillInHighSeasList.DataSource = vcrmscnList; repWillInHighSeasList.DataBind(); } asppager.RecordCount = recount; break; default: break; } }
protected void Page_Load(object sender, EventArgs e) { base.InitModule(ref valObj, ref KeyID, ref fieldList); title = valObj._ZhName + "�༭"; Page.Title = title; if (!string.IsNullOrEmpty(Request["ID"])) { keyid = Request["ID"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (!string.IsNullOrEmpty(Request["record"])) { keyid = Request["record"]; } if (!IsPostBack) { try { if (string.IsNullOrEmpty(keyid))//���� { } else//�� { ITableImplement cond1 = valObj.Clone(); cond1.SetValue(KeyID, keyid); resultObj = BLLTable<ITableImplement>.Factory(conn).GetRowData(valObj, cond1); if (resultObj == null) { ScriptHelper.Alert(this, "��¼������"); ScriptHelper.CloseMe(this); return; } //string html = Convert.ToString(resultObj.GetValue(WEC_A_VOTE.Attribute.TITLE)); } } catch (Exception ex) { litWarn.Text = ex.Message; } } if (valObj.IsNull()) { //valObj.LoadAllAttributes(true); } }
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); } }
//递归遍历 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 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 }
protected void Page_Load(object sender, EventArgs e) { if (Request["deleteFile"] == null) { base.InitModule(ref valObj, ref KeyID, ref fieldList); } //在列表里点击删除按钮,通过AJAX执行这里的后台代码,删除一条记录 if (Request["DelID"] != null) { valObj.SetValue(valObj.KeyID, Request["DelID"]); int re = BLLTable <ITableImplement> .Factory(conn).Delete(valObj); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在列表顶部点击删除按钮,通过AJAX执行这里的后台代码,删除多条记录 if (Request["DelKeyIDS"] != null) { ITableImplement cond = valObj; cond.In(AttributeItem.Factory(cond.DataBaseTable.IDField), Request["DelKeyIDS"]); int re = BLLTable <ITableImplement> .Factory(conn).Delete(cond); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在用户详细信息查看编辑页面,点保存时,通过AJAX执行这里的后台代码,实现部门字段的更新 if (Request["saveInfo"] != null) { valObj.SetValue(valObj.KeyID, Request["FieldKeyID"]); List <AttributeItem> lstCol = valObj.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName])) { valObj.SetValue(lstCol[i], Request["txt" + lstCol[i].FieldName]); } } BLLTable <ITableImplement> .Factory(conn).Update(valObj, valObj.KeyID); Response.Write("修改记录信息成功"); } //删除本地文件 if (Request["deleteFile"] != null) { //string filepath=WebHelper.GetAppPath() + Request["fileName"]; string filepath = System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + Request["fileName"];; if (File.Exists(filepath)) { File.Delete(filepath); } } //分页AJAX请求 if (Request["paging"] != null) { int pageSize = 10; int pageIndex = 1; int count1 = -1; pageIndex = Convert.ToInt32(HttpUtil.GetReqStrValue("pageIndex")); int num = Convert.ToInt32(HttpUtil.GetReqStrValue("num"));; StringBuilder sb = new StringBuilder(); try { //DataBaseField[] flist = valObj.af_GetAvailableDataBaseField(); //foreach (DataBaseField f1 in flist) { //父表的id object id1 = HttpUtil.GetReqStrValue("id1"); string tableName1 = "关系表1"; if (valObj.DataBaseTable.SubTable_ChaZhao.Count > 0) { // foreach (DataBaseTableRelation dr1 in valObj.DataBaseTable.SubTable_ChaZhao) //{ DataBaseTableRelation dr1 = valObj.DataBaseTable.SubTable_ChaZhao[num]; 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>(); //显示明显表的 父表的信息 //value2.setConn(conn).setModule("WEC_QC_CARS"); List <ITableImplement> list2 = BLLTable <ITableImplement> .Factory(conn).SelectByPage(value2, lstRel, lstOther, lstCond, pageSize, pageIndex, ref count1); // BLLTable.SQL_Test.ToString(); if (list2.Count > 0) { foreach (ITableImplement tb2 in list2) { sb.Append("<tr>"); foreach (DataBaseField d2 in tb2.af_GetAvailableDataBaseField()) { sb.Append("<td>" + GetHtmlList(d2, tb2) + ""); } sb.Append("</tr>"); } } } } } catch (Exception ex) { } Response.Write(sb.ToString()); } //下载文件 if (Request["download"] != null) { string filename = Request["filename"]; string fullpath = Request.PhysicalApplicationPath + filename; Response.ContentType = "APPLICATION/OCTET-STREAM"; Response.AddHeader("Content-Disposition", "attachment;filename=" + filename.Substring(filename.LastIndexOf("/") + 1)); FileStream fs = new FileStream(fullpath, FileMode.Open); int len = (int)fs.Length; byte[] buf = new byte[len]; int count; int sum = 0; while ((count = fs.Read(buf, 0, len)) > 0) { sum += count; Response.OutputStream.Write(buf, 0, count); } } Response.End(); }
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 + "\"}"); }