protected void btnFind_Click(object sender, EventArgs e) { try { condObj = new TF_F_COLUMN(); if (txtSHOW_NAME.Value != "") { condObj.Like(TF_F_COLUMN.Attribute.SHOW_NAME, Convert.ToString(txtSHOW_NAME.Value)); } listObj = BLLTable <TF_F_COLUMN> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } aspPager.RecordCount = recount; }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<TF_F_COLUMN>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <TF_F_COLUMN>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void Page_Load(object sender, EventArgs e) { #region//默认隐藏的列 //hideTableColumnList = new List<AttributeItem>(); //hideTableColumnList.Add(TF_F_COLUMN.Attribute.EXP1); //hideTableColumnList.Add(TF_F_COLUMN.Attribute.EXP2); //hideTableColumnList.Add(TF_F_COLUMN.Attribute.EXP3); //valObj.LoadAllAttributes(true);//暂时加此代码,以后框架更新将不需要 //valObj.Remove(hideTableColumnList); //hideFindColumnList = new List<AttributeItem>(); //hideFindColumnList.Add(TF_F_COLUMN.Attribute.EXP1); //hideFindColumnList.Add(TF_F_COLUMN.Attribute.EXP2); //hideFindColumnList.Add(TF_F_COLUMN.Attribute.EXP3); #endregion condObj.OrderBy(TF_F_COLUMN.Attribute.COLUMN_ID, Order.Desc); if (!IsPostBack) { btnFind.Text = LanguageService.GetLanguageString("btnFind", "查询"); aspPager.PageSize = 10; aspPager.CurrentPageIndex = 1; if (!string.IsNullOrEmpty(Request["ids"])) { TF_F_COLUMN roleOld = new TF_F_COLUMN(); roleOld.Where(TF_F_COLUMN.Attribute.COLUMN_ID, Request["ids"].ToString()); listObj = BLLTable <TF_F_COLUMN> .Factory(conn).Select(valObj, roleOld); for (int i = 0; i < listObj.Count; i++) { if (i > 0) { hidOld.Value += ","; hidInitIDS.Value += ","; } hidOld.Value += "{ID:'" + listObj[i].COLUMN_ID + "',Name:'" + listObj[i].COLUMN_ID + "'}";//这里的Name用于显示在列表中,请自行重定义。 hidInitIDS.Value += listObj[i].COLUMN_ID; } } try { listObj = BLLTable <TF_F_COLUMN> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; } catch (Exception ex) { litWarn.Text = ex.Message; } } }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new TF_F_COLUMN(); if(txtCOLUMN_ID.Value !="" ) condObj.Like_OR(TF_F_COLUMN.Attribute.COLUMN_ID, Convert.ToInt32(txtCOLUMN_ID.Value)); if(txtFORM_ID.Value !="" ) condObj.Like_OR(TF_F_COLUMN.Attribute.FORM_ID, Convert.ToInt32(txtFORM_ID.Value)); if(txtTB_ID.Value !="" ) condObj.Like_OR(TF_F_COLUMN.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value)); if(txtFIELD_ID.Value !="" ) condObj.Like_OR(TF_F_COLUMN.Attribute.FIELD_ID, Convert.ToInt32(txtFIELD_ID.Value)); if(txtSHOW_NAME.Value !="" ) condObj.Like_OR(TF_F_COLUMN.Attribute.SHOW_NAME, Convert.ToString(txtSHOW_NAME.Value)); if(txtCTRL_TYPE.Value !="" ) condObj.Like_OR(TF_F_COLUMN.Attribute.CTRL_TYPE, Convert.ToString(txtCTRL_TYPE.Value)); if(txtMAX_VAL.Value !="" ) condObj.Like_OR(TF_F_COLUMN.Attribute.MAX_VAL, Convert.ToInt32(txtMAX_VAL.Value)); if(txtMIN_VAL.Value !="" ) condObj.Like_OR(TF_F_COLUMN.Attribute.MIN_VAL, Convert.ToInt32(txtMIN_VAL.Value)); if(txtIS_NEED.Value !="" ) condObj.Like_OR(TF_F_COLUMN.Attribute.IS_NEED, Convert.ToInt32(txtIS_NEED.Value)); if(txtCAL_FORMULA.Value !="" ) condObj.Like_OR(TF_F_COLUMN.Attribute.CAL_FORMULA, Convert.ToString(txtCAL_FORMULA.Value)); if(txtSUM_FIELD_ID.Value !="" ) condObj.Like_OR(TF_F_COLUMN.Attribute.SUM_FIELD_ID, Convert.ToString(txtSUM_FIELD_ID.Value)); if(txtSORT_NO.Value !="" ) condObj.Like_OR(TF_F_COLUMN.Attribute.SORT_NO, Convert.ToInt32(txtSORT_NO.Value)); try { hidCondition.Value = condObj.ToJson(20); listObj = BLLTable<TF_F_COLUMN>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new TF_F_COLUMN(); if(txtCTRL_TYPE.Value !="" ) condObj.Like(TF_F_COLUMN.Attribute.CTRL_TYPE, Convert.ToString(txtCTRL_TYPE.Value)); if(txtIS_NEED.Value !="" ) condObj.Like(TF_F_COLUMN.Attribute.IS_NEED, Convert.ToInt32(txtIS_NEED.Value)); hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
protected void aspPager_PageChanged(object sender, EventArgs e) { try { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <TF_F_COLUMN>(hidCondition.Value); } listObj = BLLTable <TF_F_COLUMN> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void aspPager_PageChanged(object sender, EventArgs e) { try { recount = aspPager.RecordCount; if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<TF_F_COLUMN>(hidCondition.Value); } List<TF_F_COLUMN> listVal = BLLTable<TF_F_COLUMN>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount); repList.DataSource = listVal; repList.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new TF_F_COLUMN(); if (txtCTRL_TYPE.Value != "") { condObj.Like(TF_F_COLUMN.Attribute.CTRL_TYPE, Convert.ToString(txtCTRL_TYPE.Value)); } if (txtIS_NEED.Value != "") { condObj.Like(TF_F_COLUMN.Attribute.IS_NEED, Convert.ToInt32(txtIS_NEED.Value)); } hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
protected void btnFind_Click(object sender, EventArgs e) { try { condObj = new TF_F_COLUMN(); if(txtSHOW_NAME.Value !="" ) condObj.Like(TF_F_COLUMN.Attribute.SHOW_NAME, Convert.ToString(txtSHOW_NAME.Value)); listObj = BLLTable<TF_F_COLUMN>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } aspPager.RecordCount = recount; }
protected void Page_Load(object sender, EventArgs e) { valObj.af_PageBy(TF_F_COLUMN.Attribute.COLUMN_ID, Order.Desc); title = valObj._ZhName + "Ñ¡Ôñ"; Page.Title = title; if (Request["formid"] != null) { condObj.FORM_ID = int.Parse(Request["formid"]); } if (!IsPostBack) { aspPager.CurrentPageIndex = 1; aspPager.PageSize = 20; try { listObj = BLLTable <TF_F_COLUMN> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); FORM_BLL sub_bll = new FORM_BLL(condObj.FORM_ID); if (sub_bll.HadSubForm) { condObj = new TF_F_COLUMN(); condObj.FORM_ID = sub_bll.GetSubForm().FORM_ID; listObj2 = BLLTable <TF_F_COLUMN> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); } listObj.AddRange(listObj2); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } aspPager.RecordCount = recount; } }
private void BindList(TF_F_COLUMN condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序 { condObj.af_PageBy(TF_F_COLUMN.Attribute.SORT_NO, Order.Asc); } if (formid != "") { condObj.FORM_ID = int.Parse(formid); } listObj = BLLTable <TF_F_COLUMN> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj.Where(s => s.IS_DEFAULT == "0"); repList.DataBind(); aspPager.RecordCount = recount; //repDefault.DataSource = listObj.Where(s => s.IS_DEFAULT == "1"); //repDefault.DataBind(); TF_F_COLUMN ccc = new TF_F_COLUMN(); if (Request["ntype"] == "TF_FORM-mx") { ccc.FORM_ID = -1; } else { ccc.FORM_ID = 0; } listObj = BLLTable <TF_F_COLUMN> .Factory(conn).Select(valObj, ccc); repDefault.DataSource = listObj; repDefault.DataBind(); }
/// <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); }
protected void btnOK_Click(object sender, EventArgs e) { //try //{ #region TF_TABLE tbObj = null; TF_TB_FIELD valObj = new TF_TB_FIELD(); if (string.IsNullOrEmpty(keyid))//�����ʱ�� { if (string.IsNullOrEmpty(tbid)) { litWarn.Text = "�������������"; return; } valObj.TB_ID = int.Parse(tbid);// Convert.ToInt32(txtTB_ID.Value); } else{//�ĵ�ʱ�� valObj.FIELD_ID = Convert.ToInt32(keyid); if (string.IsNullOrEmpty(tbid)){ valObj.TB_ID = Convert.ToInt32(BLLTable<TF_TB_FIELD>.Factory(conn).GetOneValue(TF_TB_FIELD.Attribute.FIELD_ID, valObj.FIELD_ID, TF_TB_FIELD.Attribute.TB_ID)); } if (valObj.TB_ID != 0)// { tbObj = BLLTable<TF_TABLE>.Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, valObj.TB_ID); } } if (txtFIELD_NAME.Value != "") valObj.FIELD_NAME = Convert.ToString(txtFIELD_NAME.Value); else { litWarn.Text = "�ֶ���Ϊ�գ�"; return; } if (ViewState["OLDNAME"].ToString().Trim() != txtFIELD_NAME.Value) { if (BLLTable<TF_TB_FIELD>.Exists(valObj)) { litWarn.Text = "���ֶ��Ѿ����ڣ����������룡"; return; } } if (txtFIELD_ID.Value != "") valObj.FIELD_ID = Convert.ToInt32(txtFIELD_ID.Value); if (txtFIELD_TYPE.Value != "") { TF_FIELD_DBTYPE typeObj = BLLTable<TF_FIELD_DBTYPE>.Factory(conn).GetRowData(TF_FIELD_DBTYPE.Attribute.TYPE_CODE, txtFIELD_TYPE.Value); valObj.TYPE_CODE = typeObj.TYPE_CODE; valObj.DB_TYPE = typeObj.DB_TYPE; //valObj.TYPE_ID = Convert.ToInt32(txtFIELD_TYPE.Value); } //if(txtDB_TYPE.Value !="" ) // valObj.DB_TYPE = Convert.ToString(txtDB_TYPE.Value); valObj.IS_NULL = txtIS_NULL.Checked == true ? 1 : 0; if(txtNOTE.Value !="" ) valObj.NOTE = Convert.ToString(txtNOTE.Value); if(txtDEFAULT_VAL.Value !="" ) valObj.DEFAULT_VAL = Convert.ToString(txtDEFAULT_VAL.Value); //if (txtTB_ID.Value != "") if(txtCTRL_TYPE.Value !="" ) valObj.CTRL_TYPE = Convert.ToString(txtCTRL_TYPE.Value); if(txtSORT_NO.Value !="" ) valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value); #endregion int editb = -9; editb = AgileFrame.Common.TF_TABLEHelper.Factory(conn).InsertOrUpdateField(valObj, Convert.ToString(ViewState["OLDNAME"]), ref errMsg);//ͬʱ����ʽ���������ʱ���ֶ� if (keyid != "") { if (editb > 0) { count = BLLTable<TF_TB_FIELD>.Factory(conn).Update(valObj, TF_TB_FIELD.Attribute.FIELD_ID); } else { //CHG START ȥ��ϵͳ������Ϣ��ʾ��ҳ�� jin-shenjian 2013/10/23 //litWarn.Text = "�����ݿ������ֶ���Ϣʧ�ܣ�" + editb + "<a>" + errMsg + "</a>" litWarn.Text = "�����ݿ������ֶ���Ϣʧ�ܣ�"; //CHG END ȥ��ϵͳ������Ϣ��ʾ��ҳ�� jin-shenjian 2013/10/23 return; } } else { //editb = AgileFrame.Common.TF_TABLEHelper.Factory(conn).AddField(valObj, ref errMsg); if (editb > 0) { valObj.CREATED = ckAddToFormCol.Checked == true ? 1 : 0; count = BLLTable<TF_TB_FIELD>.Factory(conn).Insert(valObj, TF_TB_FIELD.Attribute.FIELD_ID); keyid = valObj.FIELD_ID.ToString(); } else { litWarn.Text = "�����ݿ��ﴴ���ֶ���Ϣʧ�ܣ�" + editb + ":" + errMsg; return; } } if (count > 0) { if (editb > 0)//��������� { if (ckAddToFormCol.Checked == true && count > 0) { #region//ͬʱ�½�Ϊij���������Ŀ��ǰ���Ǵ˱��ij�����ʹ���С� List<TF_FORM> lstForm = BLLTable<TF_FORM>.Factory(conn).Select(TF_FORM.Attribute.TB_ID, valObj.TB_ID); if (lstForm != null) { foreach (TF_FORM f in lstForm) { TF_F_COLUMN valCol = new TF_F_COLUMN(); valCol.TB_ID = valObj.TB_ID; valCol.FORM_ID = f.FORM_ID; valCol.FIELD_ID = valObj.FIELD_ID; if (!BLLTable<TF_F_COLUMN>.Exists(valCol)) { valCol.SHOW_NAME = valObj.NOTE; valCol.CTRL_TYPE = valObj.CTRL_TYPE; valCol.MAX_VAL = 0; valCol.IS_DEFAULT = "0"; valCol.MIN_VAL = 0; valCol.IS_NEED = valObj.IS_NULL == 1 ? 0 : 1; valCol.SORT_NO = valObj.SORT_NO; valCol.SHOWIN_FORM = "1"; int count2 = BLLTable<TF_F_COLUMN>.Factory(conn).Insert(valCol, TF_F_COLUMN.Attribute.COLUMN_ID); if (count2 <= 0) { "".ToString(); } } } } #endregion } } #region string gotoUrl = WebHelper.GetAppPath() + @"ok.aspx"; if (Request["tree"] != null)//�������������������� { //if(Server.MapPath(gotoUrl)) StringBuilder sb = new StringBuilder("{"); sb.Append("id:'"); sb.Append(keyid).Append("',pid:'").Append(valObj.TB_ID).Append("',no:").Append(valObj.SORT_NO).Append(",sc:0,name:'"); //CHG START ����ڵ�ѡ��ҳ���������� jin-shenjian 2013/10/26 //sb.Append(valObj.NOTE).Append("',ntype:'TF_F_COLUMN'}"); sb.Append(valObj.NOTE).Append("',ntype:'TF_TB_FIELD'}"); //CHG END ����ڵ�ѡ��ҳ���������� jin-shenjian 2013/10/26 if (Request["edit"] == null) { AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false); } else { AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false); } } else //�������Ӵ��ڵ���� { 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("})"); Button btn = (Button)sender; if (btn.ID == "btnOK")//ѡ���ʱ�� { if (ViewState["hadSave"] == null) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}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 //���水ť����� { txtFIELD_NAME.Value = ""; txtFIELD_TYPE.Value = ""; txtIS_NULL.Value = ""; txtNOTE.Value = ""; txtDEFAULT_VAL.Value = ""; AgileFrame.Core.ScriptHelper.Alert(Page, "�����ɹ�"); } } #endregion } else { litWarn.Text ="�ļ�¼û�гɹ���"; } //} //catch (Exception ex) //{ // litWarn.Text = ex.Message; //} }
/// <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 }
protected void Page_Load(object sender, EventArgs e) { dics.Add("TF_TABLE-root", "TF_TABLE"); dics.Add("TF_TABLE", "TF_TABLE"); //dics.Add("TF_TABLE", "TF_TABLE-mx"); if (!IsPostBack) { #region////显示子节点 if (Request["getSubNodes"] != null) { string nodetype = Request["ntype"]; StringBuilder sb = new StringBuilder("["); string id = Request["id"]; if (nodetype == "TF_TABLE-root") { #region TF_TABLE obj = new TF_TABLE(); TF_TABLE val = new TF_TABLE(); obj.M_TB_ID = 0; val.OrderBy(TF_TABLE.Attribute.SORT_NO, Order.Asc); List<TF_TABLE> lst = BLLTable<TF_TABLE>.Select(val, 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].TB_ID); sb.Append("',pid:'").Append("0").Append("',no:").Append(lst[i].SORT_NO); sb.Append(",sc:").Append("-1"); sb.Append(",name:'").Append(lst[i].CH_NAME).Append("',ntype:'TF_TABLE'}"); } } #endregion } if (nodetype == "TF_TABLE" || nodetype == "TF_TABLE-mx") { if (nodetype == "TF_TABLE")//明细表,将不会再有子级的明细表。。。 { #region TF_TABLE objTB = new TF_TABLE(); TF_TABLE valTB = new TF_TABLE(); objTB.M_TB_ID = int.Parse(id); valTB.OrderBy(TF_TABLE.Attribute.SORT_NO, Order.Asc); List<TF_TABLE> lstTB = BLLTable<TF_TABLE>.Select(valTB, objTB); if (lstTB.Count != null) { for (int i = 0; i < lstTB.Count; i++) { if (sb.Length > 2) { sb.Append(","); } sb.Append("{id:'").Append(lstTB[i].TB_ID); sb.Append("',pid:'").Append(id).Append("',no:").Append(lstTB[i].SORT_NO); sb.Append(",sc:").Append("1"); sb.Append(",name:'").Append(lstTB[i].CH_NAME).Append("',ntype:'TF_TABLE-mx'}"); } } #endregion } #region TF_TB_FIELD obj = new TF_TB_FIELD(); TF_TB_FIELD val = new TF_TB_FIELD(); obj.TB_ID = int.Parse(id); val.OrderBy(TF_TB_FIELD.Attribute.SORT_NO, Order.Asc); List<TF_TB_FIELD> lst = BLLTable<TF_TB_FIELD>.Select(val, obj); if (lst.Count > 0) { for (int i = 0; i < lst.Count; i++) { if (sb.Length > 2) { sb.Append(","); } sb.Append("{id:'").Append(lst[i].FIELD_ID.ToString()); sb.Append("',pid:'").Append(lst[i].TB_ID.ToString()).Append("',no:").Append(lst[i].SORT_NO); sb.Append(",sc:").Append("0"); sb.Append(",name:'").Append(lst[i].NOTE).Append("',ntype:'TF_F_COLUMN'}"); } } #endregion } if (nodetype == "TF_FORM-root") { #region TF_FORM obj = new TF_FORM(); TF_FORM val = new TF_FORM(); obj.M_FORM_ID = 0; val.OrderBy(TF_FORM.Attribute.FORM_ID, Order.Asc); List<TF_FORM> lst = BLLTable<TF_FORM>.Select(val, 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].FORM_ID); sb.Append("',pid:'").Append(lst[i].TB_ID).Append("',no:").Append(lst[i].FORM_ID); sb.Append(",sc:").Append("1"); sb.Append(",name:'").Append(lst[i].F_NAME).Append("',ntype:'TF_FORM'}"); } } #endregion } if (nodetype == "TF_FORM" || nodetype == "TF_FORM-mx") { if (nodetype == "TF_FORM") { #region TF_FORM objForm = new TF_FORM(); TF_FORM valForm = new TF_FORM(); objForm.M_FORM_ID = int.Parse(id); valForm.OrderBy(TF_FORM.Attribute.FORM_ID, Order.Asc); List<TF_FORM> lstForm = BLLTable<TF_FORM>.Select(valForm, objForm); if (lstForm.Count != null) { for (int i = 0; i < lstForm.Count; i++) { if (sb.Length > 2) { sb.Append(","); } sb.Append("{id:'").Append(lstForm[i].FORM_ID); sb.Append("',pid:'").Append(id).Append("',no:").Append(lstForm[i].FORM_ID); sb.Append(",sc:").Append("1"); sb.Append(",name:'").Append(lstForm[i].F_NAME).Append("',ntype:'TF_FORM-mx'}"); } } #endregion } #region TF_F_COLUMN obj = new TF_F_COLUMN(); TF_F_COLUMN val = new TF_F_COLUMN(); //obj.IS_DEFAULT = "0"; obj.FORM_ID = int.Parse(id); val.OrderBy(TF_F_COLUMN.Attribute.SORT_NO, Order.Asc); List<TF_F_COLUMN> lst = BLLTable<TF_F_COLUMN>.Select(val, 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].COLUMN_ID); sb.Append("',pid:'").Append(lst[i].FORM_ID).Append("',no:").Append(lst[i].SORT_NO); sb.Append(",sc:").Append("0"); sb.Append(",name:'").Append(lst[i].SHOW_NAME).Append("',ntype:'TF_F_COLUMN'}"); } } #endregion } //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'}"); sb.Append("]"); Response.Write(sb.ToString()); } #endregion #region//删除节点 if (Request["deleteNode"] != null) { string str = ""; string delID=Request["id"]; string ntype=Request["ntype"]; if (ntype == "table" || ntype == "TF_TABLE-mx") { #region//删除表 int re = 0; string msg = "删除数据库表成功!"; TF_TABLE cccSub = new TF_TABLE(); cccSub.M_TB_ID = int.Parse(delID); if (BLLTable<TF_TABLE>.Count(cccSub) > 0) { msg = "存在明细表,不能删除!"; } else { TF_TB_FIELD hadcol = new TF_TB_FIELD(); hadcol.TB_ID = int.Parse(delID); if (BLLTable<TF_TB_FIELD>.Exists(hadcol)) { msg = "存在字段,不能删除此表"; } else { TF_FORM useTB = new TF_FORM(); useTB.Where("TB_ID=" + delID + " or TB_IDS like '%," + delID + ",%'"); if (BLLTable<TF_FORM>.Exists(useTB)) { msg = "此表已被表单使用,不能删除"; } else { re = new TF_TABLEHelper(conn).DelTable(delID, ref msg);// ; if (re > 0) { if (BLLTable<TF_TABLE>.Delete(TF_TABLE.Attribute.TB_ID, delID) <= 0) { msg = "删除数据库表成功,但删除表结构信息失败!"; } } else { msg = "删除表结构信息失败!"; } } } } #endregion str = "{re:" + re + ",msg:'" + msg + "'}"; } else if (ntype == "field") { #region//删除表字段 string msg = "删除数据库表字段成功!"; int re = new TF_TABLEHelper(conn).DelField(delID, ref msg);// ; if (re > 0) { if (BLLTable<TF_TB_FIELD>.Delete(TF_TB_FIELD.Attribute.FIELD_ID, delID) <= 0) { msg = "删除数据库表字段成功,但删除字段结构信息失败!"; } } else { msg = "删除数据库表字段失败!"; } #endregion str = "{re:" + re + ",msg:'" + msg + "'}"; } else if (ntype == "TF_FORM" || ntype == "TF_FORM-mx") { #region//删除表单 int re = 0; string msg = "删除表单成功!"; TF_FORM cccSub = new TF_FORM(); cccSub.M_FORM_ID = int.Parse(delID); if (BLLTable<TF_FORM>.Count(cccSub) > 0) { msg = "存在明细表单,不能删除!"; } else { TF_F_COLUMN ccc = new TF_F_COLUMN(); ccc.FORM_ID = int.Parse(delID); ccc.IS_DEFAULT = "0"; if (BLLTable<TF_F_COLUMN>.Count(ccc) > 0) { msg = "存在栏目,不能删除!"; } else { re = BLLTable<TF_FORM>.Delete(TF_FORM.Attribute.FORM_ID, delID); BLLTable<TF_F_COLUMN>.Delete(TF_F_COLUMN.Attribute.FORM_ID, delID); if (re <= 0) { msg = "删除表单失败!"; } } } #endregion str = "{re:" + re+",msg:'" + msg + "'}"; } else if (ntype == "TF_F_COLUMN") { string msg = "删除表单栏目成功!"; TF_F_COLUMN oldObj = BLLTable<TF_F_COLUMN>.GetRowData(TF_F_COLUMN.Attribute.COLUMN_ID, delID); int re = BLLTable<TF_F_COLUMN>.Delete(TF_F_COLUMN.Attribute.COLUMN_ID, delID); if (re <= 0) { msg = "删除表单栏目失败"; } else { if (oldObj != null) { BLLTable<TF_TB_FIELD>.Update(TF_TB_FIELD.Attribute.FIELD_ID, oldObj.FIELD_ID, TF_TB_FIELD.Attribute.CREATED, 0); } } str = "{re:" + re + ",msg:'" + msg + "'}"; } Response.Write(str); } #endregion } Response.End(); }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "详细"; Page.Title = title; if (!IsPostBack) { try { if (!string.IsNullOrEmpty(Request["COLUMN_ID"])) { valObj = BLLTable <TF_F_COLUMN> .Factory(conn).GetRowData(TF_F_COLUMN.Attribute.COLUMN_ID, Request["COLUMN_ID"]); if (valObj == null) { return; } txtCOLUMN_ID.Text = Convert.ToString(valObj.COLUMN_ID);//Convert.ToInt32 txtFORM_ID.Text = Convert.ToString(valObj.FORM_ID);//Convert.ToInt32 txtTB_ID.Text = Convert.ToString(valObj.TB_ID);//Convert.ToInt32 txtFIELD_ID.Text = Convert.ToString(valObj.FIELD_ID);//Convert.ToInt32 txtSHOW_NAME.Text = Convert.ToString(valObj.SHOW_NAME);//Convert.ToString txtCTRL_TYPE.Text = Convert.ToString(valObj.CTRL_TYPE);//Convert.ToString txtMAX_VAL.Text = Convert.ToString(valObj.MAX_VAL);//Convert.ToInt32 txtMIN_VAL.Text = Convert.ToString(valObj.MIN_VAL);//Convert.ToInt32 txtIS_NEED.Text = Convert.ToString(valObj.IS_NEED);//Convert.ToInt32 txtCAL_FORMULA.Text = Convert.ToString(valObj.CAL_FORMULA);//Convert.ToString txtSUM_FIELD_ID.Text = Convert.ToString(valObj.SUM_FIELD_ID);//Convert.ToString txtSORT_NO.Text = Convert.ToString(valObj.SORT_NO);//Convert.ToInt32 } } catch (Exception ex) { litWarn.Text = ex.Message; } if (Request["ajax"] != null) { Response.Clear(); Response.Buffer = true; Response.Charset = "utf-8"; Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//设置输出流为简体中文 //Response.ContentType = "html/text"; this.EnableViewState = false; System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); divC.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); } } }
protected void btnOK_Click(object sender, EventArgs e) { //try //{ #region TF_TABLE tbObj = null; TF_TB_FIELD valObj = new TF_TB_FIELD(); if (string.IsNullOrEmpty(keyid)) //插入的时候 { if (string.IsNullOrEmpty(tbid)) { litWarn.Text = "请填充完整数据"; return; } valObj.TB_ID = int.Parse(tbid); // Convert.ToInt32(txtTB_ID.Value); } else //修改的时候 { valObj.FIELD_ID = Convert.ToInt32(keyid); if (string.IsNullOrEmpty(tbid)) { valObj.TB_ID = Convert.ToInt32(BLLTable <TF_TB_FIELD> .Factory(conn).GetOneValue(TF_TB_FIELD.Attribute.FIELD_ID, valObj.FIELD_ID, TF_TB_FIELD.Attribute.TB_ID)); } if (valObj.TB_ID != 0) // { tbObj = BLLTable <TF_TABLE> .Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, valObj.TB_ID); } } if (txtFIELD_NAME.Value != "") { valObj.FIELD_NAME = Convert.ToString(txtFIELD_NAME.Value); } else { litWarn.Text = "字段名为空!"; return; } if (ViewState["OLDNAME"].ToString().Trim() != txtFIELD_NAME.Value) { if (BLLTable <TF_TB_FIELD> .Exists(valObj)) { litWarn.Text = "此字段已经存在,请重新输入!"; return; } } if (txtFIELD_ID.Value != "") { valObj.FIELD_ID = Convert.ToInt32(txtFIELD_ID.Value); } if (txtFIELD_TYPE.Value != "") { TF_FIELD_DBTYPE typeObj = BLLTable <TF_FIELD_DBTYPE> .Factory(conn).GetRowData(TF_FIELD_DBTYPE.Attribute.TYPE_CODE, txtFIELD_TYPE.Value); valObj.TYPE_CODE = typeObj.TYPE_CODE; valObj.DB_TYPE = typeObj.DB_TYPE; //valObj.TYPE_ID = Convert.ToInt32(txtFIELD_TYPE.Value); } //if(txtDB_TYPE.Value !="" ) // valObj.DB_TYPE = Convert.ToString(txtDB_TYPE.Value); valObj.IS_NULL = txtIS_NULL.Checked == true ? 1 : 0; if (txtNOTE.Value != "") { valObj.NOTE = Convert.ToString(txtNOTE.Value); } if (txtDEFAULT_VAL.Value != "") { valObj.DEFAULT_VAL = Convert.ToString(txtDEFAULT_VAL.Value); } //if (txtTB_ID.Value != "") if (txtCTRL_TYPE.Value != "") { valObj.CTRL_TYPE = Convert.ToString(txtCTRL_TYPE.Value); } if (txtSORT_NO.Value != "") { valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value); } #endregion int editb = -9; editb = AgileFrame.Common.TF_TABLEHelper.Factory(conn).InsertOrUpdateField(valObj, Convert.ToString(ViewState["OLDNAME"]), ref errMsg); //同时修改正式表和流程临时表字段 if (keyid != "") { if (editb > 0) { count = BLLTable <TF_TB_FIELD> .Factory(conn).Update(valObj, TF_TB_FIELD.Attribute.FIELD_ID); } else { //CHG START 去掉系统捕获信息显示在页面 jin-shenjian 2013/10/23 //litWarn.Text = "在数据库里修改字段信息失败!" + editb + "<a>" + errMsg + "</a>" litWarn.Text = "在数据库里修改字段信息失败!"; //CHG END 去掉系统捕获信息显示在页面 jin-shenjian 2013/10/23 return; } } else { //editb = AgileFrame.Common.TF_TABLEHelper.Factory(conn).AddField(valObj, ref errMsg); if (editb > 0) { valObj.CREATED = ckAddToFormCol.Checked == true ? 1 : 0; count = BLLTable <TF_TB_FIELD> .Factory(conn).Insert(valObj, TF_TB_FIELD.Attribute.FIELD_ID); keyid = valObj.FIELD_ID.ToString(); } else { litWarn.Text = "在数据库里创建字段信息失败!" + editb + ":" + errMsg; return; } } if (count > 0) { if (editb > 0) //物理表已修改 { if (ckAddToFormCol.Checked == true && count > 0) { #region //同时新建为某个表单的栏目,前提是此表被某个表单使用中。 List <TF_FORM> lstForm = BLLTable <TF_FORM> .Factory(conn).Select(TF_FORM.Attribute.TB_ID, valObj.TB_ID); if (lstForm != null) { foreach (TF_FORM f in lstForm) { TF_F_COLUMN valCol = new TF_F_COLUMN(); valCol.TB_ID = valObj.TB_ID; valCol.FORM_ID = f.FORM_ID; valCol.FIELD_ID = valObj.FIELD_ID; if (!BLLTable <TF_F_COLUMN> .Exists(valCol)) { valCol.SHOW_NAME = valObj.NOTE; valCol.CTRL_TYPE = valObj.CTRL_TYPE; valCol.MAX_VAL = 0; valCol.IS_DEFAULT = "0"; valCol.MIN_VAL = 0; valCol.IS_NEED = valObj.IS_NULL == 1 ? 0 : 1; valCol.SORT_NO = valObj.SORT_NO; valCol.SHOWIN_FORM = "1"; int count2 = BLLTable <TF_F_COLUMN> .Factory(conn).Insert(valCol, TF_F_COLUMN.Attribute.COLUMN_ID); if (count2 <= 0) { "".ToString(); } } } } #endregion } } #region string gotoUrl = WebHelper.GetAppPath() + @"ok.aspx"; if (Request["tree"] != null) //父窗体有树的情况,左边 { //if(Server.MapPath(gotoUrl)) StringBuilder sb = new StringBuilder("{"); sb.Append("id:'"); sb.Append(keyid).Append("',pid:'").Append(valObj.TB_ID).Append("',no:").Append(valObj.SORT_NO).Append(",sc:0,name:'"); //CHG START 点击节点选择页面条件有误 jin-shenjian 2013/10/26 //sb.Append(valObj.NOTE).Append("',ntype:'TF_F_COLUMN'}"); sb.Append(valObj.NOTE).Append("',ntype:'TF_TB_FIELD'}"); //CHG END 点击节点选择页面条件有误 jin-shenjian 2013/10/26 if (Request["edit"] == null) { AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false); } else { AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false); } } else //非树、子窗口的情况 { 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("})"); Button btn = (Button)sender; if (btn.ID == "btnOK") //选择的时候 { if (ViewState["hadSave"] == null) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}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 //保存按钮的情况 { txtFIELD_NAME.Value = ""; txtFIELD_TYPE.Value = ""; txtIS_NULL.Value = ""; txtNOTE.Value = ""; txtDEFAULT_VAL.Value = ""; AgileFrame.Core.ScriptHelper.Alert(Page, "操作成功"); } } #endregion } else { litWarn.Text = "修改记录没有成功!"; } //} //catch (Exception ex) //{ // litWarn.Text = ex.Message; //} }
protected void Page_Load(object sender, EventArgs e) { dics.Add("TF_TABLE-root", "TF_TABLE"); dics.Add("TF_TABLE", "TF_TABLE"); //dics.Add("TF_TABLE", "TF_TABLE-mx"); if (!IsPostBack) { #region////显示子节点 if (Request["getSubNodes"] != null) { string nodetype = Request["ntype"]; StringBuilder sb = new StringBuilder("["); string id = Request["id"]; if (nodetype == "TF_TABLE-root") { #region TF_TABLE obj = new TF_TABLE(); TF_TABLE val = new TF_TABLE(); obj.M_TB_ID = 0; val.OrderBy(TF_TABLE.Attribute.SORT_NO, Order.Asc); List <TF_TABLE> lst = BLLTable <TF_TABLE> .Select(val, 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].TB_ID); sb.Append("',pid:'").Append("0").Append("',no:").Append(lst[i].SORT_NO); sb.Append(",sc:").Append("-1"); sb.Append(",name:'").Append(lst[i].CH_NAME).Append("',ntype:'TF_TABLE'}"); } } #endregion } if (nodetype == "TF_TABLE" || nodetype == "TF_TABLE-mx") { if (nodetype == "TF_TABLE")//明细表,将不会再有子级的明细表。。。 { #region TF_TABLE objTB = new TF_TABLE(); TF_TABLE valTB = new TF_TABLE(); objTB.M_TB_ID = int.Parse(id); valTB.OrderBy(TF_TABLE.Attribute.SORT_NO, Order.Asc); List <TF_TABLE> lstTB = BLLTable <TF_TABLE> .Select(valTB, objTB); if (lstTB.Count != null) { for (int i = 0; i < lstTB.Count; i++) { if (sb.Length > 2) { sb.Append(","); } sb.Append("{id:'").Append(lstTB[i].TB_ID); sb.Append("',pid:'").Append(id).Append("',no:").Append(lstTB[i].SORT_NO); sb.Append(",sc:").Append("1"); sb.Append(",name:'").Append(lstTB[i].CH_NAME).Append("',ntype:'TF_TABLE-mx'}"); } } #endregion } #region TF_TB_FIELD obj = new TF_TB_FIELD(); TF_TB_FIELD val = new TF_TB_FIELD(); obj.TB_ID = int.Parse(id); val.OrderBy(TF_TB_FIELD.Attribute.SORT_NO, Order.Asc); List <TF_TB_FIELD> lst = BLLTable <TF_TB_FIELD> .Select(val, obj); if (lst.Count > 0) { for (int i = 0; i < lst.Count; i++) { if (sb.Length > 2) { sb.Append(","); } sb.Append("{id:'").Append(lst[i].FIELD_ID.ToString()); sb.Append("',pid:'").Append(lst[i].TB_ID.ToString()).Append("',no:").Append(lst[i].SORT_NO); sb.Append(",sc:").Append("0"); sb.Append(",name:'").Append(lst[i].NOTE).Append("',ntype:'TF_F_COLUMN'}"); } } #endregion } if (nodetype == "TF_FORM-root") { #region TF_FORM obj = new TF_FORM(); TF_FORM val = new TF_FORM(); obj.M_FORM_ID = 0; val.OrderBy(TF_FORM.Attribute.FORM_ID, Order.Asc); List <TF_FORM> lst = BLLTable <TF_FORM> .Select(val, 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].FORM_ID); sb.Append("',pid:'").Append(lst[i].TB_ID).Append("',no:").Append(lst[i].FORM_ID); sb.Append(",sc:").Append("1"); sb.Append(",name:'").Append(lst[i].F_NAME).Append("',ntype:'TF_FORM'}"); } } #endregion } if (nodetype == "TF_FORM" || nodetype == "TF_FORM-mx") { if (nodetype == "TF_FORM") { #region TF_FORM objForm = new TF_FORM(); TF_FORM valForm = new TF_FORM(); objForm.M_FORM_ID = int.Parse(id); valForm.OrderBy(TF_FORM.Attribute.FORM_ID, Order.Asc); List <TF_FORM> lstForm = BLLTable <TF_FORM> .Select(valForm, objForm); if (lstForm.Count != null) { for (int i = 0; i < lstForm.Count; i++) { if (sb.Length > 2) { sb.Append(","); } sb.Append("{id:'").Append(lstForm[i].FORM_ID); sb.Append("',pid:'").Append(id).Append("',no:").Append(lstForm[i].FORM_ID); sb.Append(",sc:").Append("1"); sb.Append(",name:'").Append(lstForm[i].F_NAME).Append("',ntype:'TF_FORM-mx'}"); } } #endregion } #region TF_F_COLUMN obj = new TF_F_COLUMN(); TF_F_COLUMN val = new TF_F_COLUMN(); //obj.IS_DEFAULT = "0"; obj.FORM_ID = int.Parse(id); val.OrderBy(TF_F_COLUMN.Attribute.SORT_NO, Order.Asc); List <TF_F_COLUMN> lst = BLLTable <TF_F_COLUMN> .Select(val, 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].COLUMN_ID); sb.Append("',pid:'").Append(lst[i].FORM_ID).Append("',no:").Append(lst[i].SORT_NO); sb.Append(",sc:").Append("0"); sb.Append(",name:'").Append(lst[i].SHOW_NAME).Append("',ntype:'TF_F_COLUMN'}"); } } #endregion } //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'}"); sb.Append("]"); Response.Write(sb.ToString()); } #endregion #region//删除节点 if (Request["deleteNode"] != null) { string str = ""; string delID = Request["id"]; string ntype = Request["ntype"]; if (ntype == "table" || ntype == "TF_TABLE-mx") { #region//删除表 int re = 0; string msg = "删除数据库表成功!"; TF_TABLE cccSub = new TF_TABLE(); cccSub.M_TB_ID = int.Parse(delID); if (BLLTable <TF_TABLE> .Count(cccSub) > 0) { msg = "存在明细表,不能删除!"; } else { TF_TB_FIELD hadcol = new TF_TB_FIELD(); hadcol.TB_ID = int.Parse(delID); if (BLLTable <TF_TB_FIELD> .Exists(hadcol)) { msg = "存在字段,不能删除此表"; } else { TF_FORM useTB = new TF_FORM(); useTB.Where("TB_ID=" + delID + " or TB_IDS like '%," + delID + ",%'"); if (BLLTable <TF_FORM> .Exists(useTB)) { msg = "此表已被表单使用,不能删除"; } else { re = new TF_TABLEHelper(conn).DelTable(delID, ref msg);// ; if (re > 0) { if (BLLTable <TF_TABLE> .Delete(TF_TABLE.Attribute.TB_ID, delID) <= 0) { msg = "删除数据库表成功,但删除表结构信息失败!"; } } else { msg = "删除表结构信息失败!"; } } } } #endregion str = "{re:" + re + ",msg:'" + msg + "'}"; } else if (ntype == "field") { #region //删除表字段 string msg = "删除数据库表字段成功!"; int re = new TF_TABLEHelper(conn).DelField(delID, ref msg); // ; if (re > 0) { if (BLLTable <TF_TB_FIELD> .Delete(TF_TB_FIELD.Attribute.FIELD_ID, delID) <= 0) { msg = "删除数据库表字段成功,但删除字段结构信息失败!"; } } else { msg = "删除数据库表字段失败!"; } #endregion str = "{re:" + re + ",msg:'" + msg + "'}"; } else if (ntype == "TF_FORM" || ntype == "TF_FORM-mx") { #region//删除表单 int re = 0; string msg = "删除表单成功!"; TF_FORM cccSub = new TF_FORM(); cccSub.M_FORM_ID = int.Parse(delID); if (BLLTable <TF_FORM> .Count(cccSub) > 0) { msg = "存在明细表单,不能删除!"; } else { TF_F_COLUMN ccc = new TF_F_COLUMN(); ccc.FORM_ID = int.Parse(delID); ccc.IS_DEFAULT = "0"; if (BLLTable <TF_F_COLUMN> .Count(ccc) > 0) { msg = "存在栏目,不能删除!"; } else { re = BLLTable <TF_FORM> .Delete(TF_FORM.Attribute.FORM_ID, delID); BLLTable <TF_F_COLUMN> .Delete(TF_F_COLUMN.Attribute.FORM_ID, delID); if (re <= 0) { msg = "删除表单失败!"; } } } #endregion str = "{re:" + re + ",msg:'" + msg + "'}"; } else if (ntype == "TF_F_COLUMN") { string msg = "删除表单栏目成功!"; TF_F_COLUMN oldObj = BLLTable <TF_F_COLUMN> .GetRowData(TF_F_COLUMN.Attribute.COLUMN_ID, delID); int re = BLLTable <TF_F_COLUMN> .Delete(TF_F_COLUMN.Attribute.COLUMN_ID, delID); if (re <= 0) { msg = "删除表单栏目失败"; } else { if (oldObj != null) { BLLTable <TF_TB_FIELD> .Update(TF_TB_FIELD.Attribute.FIELD_ID, oldObj.FIELD_ID, TF_TB_FIELD.Attribute.CREATED, 0); } } str = "{re:" + re + ",msg:'" + msg + "'}"; } Response.Write(str); } #endregion } 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; }
protected void btnOK_Click(object sender, EventArgs e) { try { TF_FORM valObj = new TF_FORM(); if (txtFORM_ID.Value != "") { valObj.FORM_ID = Convert.ToInt32(txtFORM_ID.Value); } if (txtF_NAME.Value != "") { valObj.F_NAME = txtF_NAME.Value; } if (txtTB_ID.Value != "") { valObj.TB_ID = Convert.ToInt32(hidTB_ID.Value); } valObj.TPL_EDIT = txtTPL_EDIT.Value; valObj.TPL_SHOW = txtTPL_SHOW.Value; valObj.TPL_PRINT = txtTPL_PRINT.Value; valObj.TPL_LIST = txtTPL_LIST.Value; if (keyid != "") { valObj.FORM_ID = Convert.ToInt32(keyid); count = BLLTable <TF_FORM> .Factory(conn).Update(valObj, TF_FORM.Attribute.FORM_ID); } else { valObj.M_FORM_ID = pid; count = BLLTable <TF_FORM> .Factory(conn).Insert(valObj, TF_FORM.Attribute.FORM_ID); keyid = valObj.FORM_ID.ToString(); if (count > 0) { #region//自动插入默认表单栏目 TF_TB_FIELD cond = new TF_TB_FIELD(); cond.TB_ID = valObj.TB_ID; //cond.In(TF_TB_FIELD.Attribute.TB_ID, valObj.TB_ID + ",0"); List <TF_TB_FIELD> lstField = BLLTable <TF_TB_FIELD> .Factory(conn).Select(new TF_TB_FIELD(), cond); if (lstField != null) { TF_F_COLUMN valCol = new TF_F_COLUMN(); valCol.TB_ID = valObj.TB_ID; valCol.FORM_ID = valObj.FORM_ID; lstField.ForEach(f => { valCol.FIELD_ID = f.FIELD_ID; valCol.SHOW_NAME = f.NOTE; valCol.CTRL_TYPE = f.CTRL_TYPE; valCol.SHOWIN_FORM = "1"; valCol.MAX_VAL = 0; if (f.TB_ID == 0) { valCol.IS_DEFAULT = "1"; } else { valCol.IS_DEFAULT = "0"; } valCol.MIN_VAL = 0; valCol.IS_NEED = f.IS_NULL == 1 ? 0 : 1; valCol.SORT_NO = f.SORT_NO; int aaa = BLLTable <TF_F_COLUMN> .Factory(conn).Insert(valCol, TF_F_COLUMN.Attribute.COLUMN_ID); if (aaa > 0) { BLLTable <TF_TB_FIELD> .Factory(conn).Update(TF_TB_FIELD.Attribute.FIELD_ID, f.FIELD_ID, TF_TB_FIELD.Attribute.CREATED, 1); } }); } #endregion List <TF_TABLE> lstMX = BLLTable <TF_TABLE> .Factory(conn).Select(TF_TABLE.Attribute.M_TB_ID, valObj.TB_ID); if (lstMX != null && lstMX.Count > 0) { lstMX.ForEach(tb => { TF_FORM valMX = new TF_FORM(); valMX.F_NAME = tb.CH_NAME; valMX.TB_ID = Convert.ToInt32(tb.TB_ID); valMX.TPL_EDIT = ""; valMX.TPL_SHOW = ""; valMX.TPL_PRINT = ""; valMX.TPL_LIST = ""; valMX.M_FORM_ID = valObj.FORM_ID; int addmx = BLLTable <TF_FORM> .Factory(conn).Insert(valMX, TF_FORM.Attribute.FORM_ID); #region//自动插入默认表单栏目 TF_TB_FIELD condFFF = new TF_TB_FIELD(); //condFFF.In(TF_TB_FIELD.Attribute.TB_ID, valMX.TB_ID + ",0"); condFFF.TB_ID = valMX.TB_ID; lstField = BLLTable <TF_TB_FIELD> .Factory(conn).Select(new TF_TB_FIELD(), condFFF); if (lstField != null) { TF_F_COLUMN valCol = new TF_F_COLUMN(); valCol.TB_ID = valMX.TB_ID; valCol.FORM_ID = valMX.FORM_ID; lstField.ForEach(f => { valCol.FIELD_ID = f.FIELD_ID; valCol.SHOW_NAME = f.NOTE; valCol.CTRL_TYPE = f.CTRL_TYPE; valCol.SHOWIN_FORM = "1"; valCol.MAX_VAL = 0; if (f.TB_ID == 0) { valCol.IS_DEFAULT = "1"; } else { valCol.IS_DEFAULT = "0"; } valCol.MIN_VAL = 0; valCol.IS_NEED = f.IS_NULL == 1 ? 0 : 1; valCol.SORT_NO = f.SORT_NO; int aaa = BLLTable <TF_F_COLUMN> .Factory(conn).Insert(valCol, TF_F_COLUMN.Attribute.COLUMN_ID); if (aaa > 0) { BLLTable <TF_TB_FIELD> .Factory(conn).Update(TF_TB_FIELD.Attribute.FIELD_ID, f.FIELD_ID, TF_TB_FIELD.Attribute.CREATED, 1); } }); } #endregion }); } } } 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("})"); Button btn = (Button)sender; if (btn.ID == "btnOK") { if (Request["tree"] != null) { string gotoUrl = "../../../ok.aspx"; StringBuilder sb = new StringBuilder("{"); sb.Append("id:'"); sb.Append(keyid).Append("',pid:'").Append("0").Append("',no:").Append(valObj.FORM_ID).Append(",sc:1,name:'"); sb.Append(valObj.F_NAME).Append("',ntype:'form'}"); if (Request["edit"] == null) { AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false); } else { AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false); } } else { if (ViewState["hadSave"] == null) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}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 { txtF_NAME.Value = ""; txtTB_ID.Value = ""; } } } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void btnOK_Click(object sender, EventArgs e) { try { TF_F_COLUMN_ITEM valObj = new TF_F_COLUMN_ITEM(); if (txtITEM_ID.Value != "") { valObj.ITEM_ID = Convert.ToInt32(txtITEM_ID.Value); } if (txtVALUE.Value != "" && ckSetVal.Checked == true) { valObj.VALUE = Convert.ToString(txtVALUE.Value); } else { valObj.VALUE = ""; } if (txtTEXT.Value != "") { valObj.TEXT = Convert.ToString(txtTEXT.Value); } valObj.DROP_REAL = Convert.ToString(txtDROP_REAL.Value); valObj.COL_HIDE = Convert.ToString(txtCOL_HIDE.Value); if (keyid != "") { valObj.ITEM_ID = Convert.ToInt32(keyid); count = BLLTable <TF_F_COLUMN_ITEM> .Factory(conn).Update(valObj, TF_F_COLUMN_ITEM.Attribute.ITEM_ID); } else { TF_F_COLUMN colObj = BLLTable <TF_F_COLUMN> .Factory(conn).GetRowData(TF_F_COLUMN.Attribute.COLUMN_ID, colid); valObj.COLUMN_ID = colObj.COLUMN_ID; valObj.FORM_ID = colObj.FORM_ID; count = BLLTable <TF_F_COLUMN_ITEM> .Factory(conn).Insert(valObj, TF_F_COLUMN_ITEM.Attribute.ITEM_ID); keyid = valObj.ITEM_ID.ToString(); } 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"] = ViewState["sbData"].ToString() + "," + sbData.ToString(); } else { ViewState["sbData"] = sbData.ToString(); } Button btn = (Button)sender; if (btn.ID == "btnOK") { 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 { txtITEM_ID.Value = ""; txtVALUE.Value = ""; txtTEXT.Value = ""; txtDROP_REAL.Value = ""; txtCOL_HIDE.Value = ""; } } } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { #region//Ĭ�����ص��� //hideTableColumnList = new List<AttributeItem>(); //hideTableColumnList.Add(TF_F_COLUMN.Attribute.EXP1); //hideTableColumnList.Add(TF_F_COLUMN.Attribute.EXP2); //hideTableColumnList.Add(TF_F_COLUMN.Attribute.EXP3); //valObj.LoadAllAttributes(true);//��ʱ�Ӵ˴��룬�Ժ��ܸ��½�����Ҫ //valObj.Remove(hideTableColumnList); //hideFindColumnList = new List<AttributeItem>(); //hideFindColumnList.Add(TF_F_COLUMN.Attribute.EXP1); //hideFindColumnList.Add(TF_F_COLUMN.Attribute.EXP2); //hideFindColumnList.Add(TF_F_COLUMN.Attribute.EXP3); #endregion condObj.OrderBy(TF_F_COLUMN.Attribute.COLUMN_ID, Order.Desc); if (!IsPostBack) { btnFind.Text = LanguageService.GetLanguageString("btnFind", "��ѯ"); aspPager.PageSize = 10; aspPager.CurrentPageIndex = 1; if (!string.IsNullOrEmpty(Request["ids"])) { TF_F_COLUMN roleOld = new TF_F_COLUMN(); roleOld.Where(TF_F_COLUMN.Attribute.COLUMN_ID, Request["ids"].ToString()); listObj = BLLTable<TF_F_COLUMN>.Factory(conn).Select(valObj, roleOld); for (int i = 0; i < listObj.Count; i++) { if (i > 0) { hidOld.Value += ","; hidInitIDS.Value += ","; } hidOld.Value += "{ID:'" + listObj[i].COLUMN_ID + "',Name:'" + listObj[i].COLUMN_ID + "'}";//�����Name������ʾ���б��У��������ض��塣 hidInitIDS.Value += listObj[i].COLUMN_ID; } } try { listObj = BLLTable<TF_F_COLUMN>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; } catch (Exception ex) { litWarn.Text = ex.Message; } } }
/// <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 }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "��ϸ"; Page.Title = title; if (!IsPostBack) { try { if (!string.IsNullOrEmpty(Request["COLUMN_ID"])) { valObj = BLLTable<TF_F_COLUMN>.Factory(conn).GetRowData(TF_F_COLUMN.Attribute.COLUMN_ID, Request["COLUMN_ID"]); if(valObj==null) return ; txtCOLUMN_ID.Text = Convert.ToString(valObj.COLUMN_ID);//Convert.ToInt32 txtFORM_ID.Text = Convert.ToString(valObj.FORM_ID);//Convert.ToInt32 txtTB_ID.Text = Convert.ToString(valObj.TB_ID);//Convert.ToInt32 txtFIELD_ID.Text = Convert.ToString(valObj.FIELD_ID);//Convert.ToInt32 txtSHOW_NAME.Text = Convert.ToString(valObj.SHOW_NAME);//Convert.ToString txtCTRL_TYPE.Text = Convert.ToString(valObj.CTRL_TYPE);//Convert.ToString txtMAX_VAL.Text = Convert.ToString(valObj.MAX_VAL);//Convert.ToInt32 txtMIN_VAL.Text = Convert.ToString(valObj.MIN_VAL);//Convert.ToInt32 txtIS_NEED.Text = Convert.ToString(valObj.IS_NEED);//Convert.ToInt32 txtCAL_FORMULA.Text = Convert.ToString(valObj.CAL_FORMULA);//Convert.ToString txtSUM_FIELD_ID.Text = Convert.ToString(valObj.SUM_FIELD_ID);//Convert.ToString txtSORT_NO.Text = Convert.ToString(valObj.SORT_NO);//Convert.ToInt32 } } catch (Exception ex) { litWarn.Text = ex.Message; } if (Request["ajax"] != null) { Response.Clear(); Response.Buffer = true; Response.Charset = "utf-8"; Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//���������Ϊ�������� //Response.ContentType = "html/text"; this.EnableViewState = false; System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true); System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); divC.RenderControl(oHtmlTextWriter); Response.Write(oStringWriter.ToString()); Response.End(); } } }
protected void Page_Load(object sender, EventArgs e) { //���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼ if (Request["DelCOLUMN_ID"] != null) { int re = BLLTable<TF_F_COLUMN>.Factory(conn).Delete(TF_F_COLUMN.Attribute.COLUMN_ID, Request["DelCOLUMN_ID"]); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼ if (Request["DelKeyIDS"] != null) { TF_F_COLUMN cond = new TF_F_COLUMN(); cond.In(TF_F_COLUMN.Attribute.COLUMN_ID, Request["DelKeyIDS"]); Relation rel = new Relation(TF_TB_FIELD.Attribute.FIELD_ID, TF_F_COLUMN.Attribute.FIELD_ID); TF_TB_FIELD obj = new TF_TB_FIELD(); obj.CREATED =0; int re = BLLTable<TF_TB_FIELD>.Factory(conn).Update(obj, cond, rel); re = BLLTable<TF_F_COLUMN>.Factory(conn).Delete(cond); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ��� if (Request["saveInfo"] != null) { TF_F_COLUMN val = new TF_F_COLUMN(); val.COLUMN_ID = int.Parse(Request["FieldKeyID"]); List<AttributeItem> lstCol = val.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName])) { val.SetValue(lstCol[i].FieldName,Request["txt" + lstCol[i].FieldName]); } } BLLTable<TF_F_COLUMN>.Factory(conn).Update(val, TF_F_COLUMN.Attribute.COLUMN_ID); Response.Write("���û���Ϣ�ɹ�"); } if (Request["getColItems"] != null) { string colid=Request["colID"]; List<TF_F_COLUMN_ITEM> lst = BLLTable<TF_F_COLUMN_ITEM>.Factory(conn).Select(TF_F_COLUMN_ITEM.Attribute.COLUMN_ID, colid); StringBuilder sb = new StringBuilder("["); if (lst != null) { lst.ForEach(col => { if(sb.Length>3){ sb.Append(","); sb.Append("{val:'"+col.VALUE+"',txt:'"+col.TEXT+"'}"); } }); } sb.Append("]"); Response.Write(sb.ToString()); } Response.End(); }
protected void Page_Load(object sender, EventArgs e) { //在列表里点击删除按钮,通过AJAX执行这里的后台代码,删除一条记录 if (Request["DelCOLUMN_ID"] != null) { int re = BLLTable <TF_F_COLUMN> .Factory(conn).Delete(TF_F_COLUMN.Attribute.COLUMN_ID, Request["DelCOLUMN_ID"]); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在列表顶部点击删除按钮,通过AJAX执行这里的后台代码,删除多条记录 if (Request["DelKeyIDS"] != null) { TF_F_COLUMN cond = new TF_F_COLUMN(); cond.In(TF_F_COLUMN.Attribute.COLUMN_ID, Request["DelKeyIDS"]); Relation rel = new Relation(TF_TB_FIELD.Attribute.FIELD_ID, TF_F_COLUMN.Attribute.FIELD_ID); TF_TB_FIELD obj = new TF_TB_FIELD(); obj.CREATED = 0; int re = BLLTable <TF_TB_FIELD> .Factory(conn).Update(obj, cond, rel); re = BLLTable <TF_F_COLUMN> .Factory(conn).Delete(cond); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在用户详细信息查看编辑页面,点保存时,通过AJAX执行这里的后台代码,实现部门字段的更新 if (Request["saveInfo"] != null) { TF_F_COLUMN val = new TF_F_COLUMN(); val.COLUMN_ID = int.Parse(Request["FieldKeyID"]); List <AttributeItem> lstCol = val.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName])) { val.SetValue(lstCol[i].FieldName, Request["txt" + lstCol[i].FieldName]); } } BLLTable <TF_F_COLUMN> .Factory(conn).Update(val, TF_F_COLUMN.Attribute.COLUMN_ID); Response.Write("修改用户信息成功"); } if (Request["getColItems"] != null) { string colid = Request["colID"]; List <TF_F_COLUMN_ITEM> lst = BLLTable <TF_F_COLUMN_ITEM> .Factory(conn).Select(TF_F_COLUMN_ITEM.Attribute.COLUMN_ID, colid); StringBuilder sb = new StringBuilder("["); if (lst != null) { lst.ForEach(col => { if (sb.Length > 3) { sb.Append(","); sb.Append("{val:'" + col.VALUE + "',txt:'" + col.TEXT + "'}"); } }); } sb.Append("]"); Response.Write(sb.ToString()); } Response.End(); }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "�༭"; Page.Title = title; if (!string.IsNullOrEmpty(Request["COLUMN_ID"])) { keyid = Request["COLUMN_ID"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (!string.IsNullOrEmpty(Request["edit"]) && Request["ntype"]=="TF_F_COLUMN") { keyid = Request["id"]; } if (Request["ntype"] == "TF_FORM" || Request["ntype"] == "TF_FORM-mx") { formid = Request["id"]; txtFORM_ID.Value = formid; } if (!string.IsNullOrEmpty(Request["formid"])) { formid = Request["formid"]; txtFORM_ID.Value = formid; } if (!IsPostBack) { dlCAL_FORMULA.Style.Value="display:none";//.Visible = false; dlSUM_FIELD_ID.Style.Value="display:none";//.Visible = false; //try //{ ViewState["txtFIELD_ID"] = ""; if (keyid != "") { valObj = BLLTable<TF_F_COLUMN>.Factory(conn).GetRowData(TF_F_COLUMN.Attribute.COLUMN_ID, keyid); if (valObj == null) return; txtCOLUMN_ID.Value = Convert.ToString(valObj.COLUMN_ID);//Convert.ToInt32 formid = valObj.FORM_ID.ToString(); txtFORM_ID.Value = Convert.ToString(valObj.FORM_ID);//Convert.ToInt32 txtTB_ID.Value = Convert.ToString(valObj.TB_ID);//Convert.ToInt32 hidFIELD_ID.Value = Convert.ToString(valObj.FIELD_ID);//Convert.ToInt32 txtFIELD_ID.Value = BLLTable<TF_TB_FIELD>.Factory(conn).GetOneValue(TF_TB_FIELD.Attribute.FIELD_ID, valObj.FIELD_ID, TF_TB_FIELD.Attribute.NOTE); ViewState["txtFIELD_ID"] = txtFIELD_ID.Value; ViewState["hidFIELD_ID"] = hidFIELD_ID.Value; txtSHOW_NAME.Value = Convert.ToString(valObj.SHOW_NAME);//Convert.ToString //txtCTRL_TYPE.Value = Convert.ToString(valObj.CTRL_TYPE);//Convert.ToString txtMAX_VAL.Value = Convert.ToString(valObj.MAX_VAL);//Convert.ToInt32 txtMIN_VAL.Value = Convert.ToString(valObj.MIN_VAL);//Convert.ToInt32 txtDEFAULT_VAL.Value = Convert.ToString(valObj.DEFAULT_VAL);//Convert.ToString txtIS_NEED.Checked = valObj.IS_NEED == 1 ? true : false;//Convert.ToInt32 //txtCAL_FORMULA.Value = Convert.ToString(valObj.CAL_FORMULA);//Convert.ToString txtSUM_FIELD_ID.Value = Convert.ToString(valObj.SUM_FIELD_ID);//Convert.ToString txtSORT_NO.Value = Convert.ToString(valObj.SORT_NO);//Convert.ToInt32 txtCAL_FORMULA.Value = valObj.CAL_FORMULA; if (valObj.SHOWIN_HEADER == "1") { txtSHOWIN_HEADR.Checked = true; } else { txtSHOWIN_HEADR.Checked = false; } txtSHOWIN_FORM.Checked = valObj.SHOWIN_FORM == "1" ? true : false; TF_TB_FIELD fieldObj = BLLTable<TF_TB_FIELD>.Factory(conn).GetRowData(TF_TB_FIELD.Attribute.FIELD_ID, valObj.FIELD_ID); if (fieldObj != null) { if (fieldObj.TYPE_CODE == TF_ENUM.FieldTypeCode.Decimal.ToString() || fieldObj.TYPE_CODE == TF_ENUM.FieldTypeCode.Number.ToString()) { //dlCAL_FORMULA.Style.Value = "display:block";//.Visible = true; } else { dlCAL_FORMULA.Visible = false; dlSUM_FIELD_ID.Visible = false; } } else { litWarn.Text = "��Ӧ�ֶι�������ȷ��"; } // Response.Write(fieldObj.TYPE_CODE); } if (txtFORM_ID.Value != "") { #region//��ʼ�����ڱ�д��ʽ�Ŀ�ѡ�ֶ��б� TF_FORM formObj = BLLTable<TF_FORM>.Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, txtFORM_ID.Value); if (formObj != null) txtTB_ID.Value = formObj.TB_ID.ToString(); if (formObj.M_FORM_ID > 0) { TF_TB_FIELD numccc = new TF_TB_FIELD(); numccc.In(TF_TB_FIELD.Attribute.TYPE_CODE, TF_ENUM.FieldTypeCode.Decimal.ToString() + "," + TF_ENUM.FieldTypeCode.Number.ToString()); numccc.TB_ID = formObj.TB_ID; List<TF_TB_FIELD> fieldList = BLLTable<TF_TB_FIELD>.Factory(conn).Select(new TF_TB_FIELD(), numccc); if (fieldList != null && fieldList.Count > 0) { StringBuilder sbnumcols = new StringBuilder(); fieldList.ForEach(f => { sbnumcols.Append("<a data='" + f.FIELD_NAME + "' onclick='selColToCalInput(this);'>" + f.NOTE + "(" + f.FIELD_NAME + ")</a>"); }); litNumberFields.Text = sbnumcols.ToString(); if (keyid != "") { dlCAL_FORMULA.Style.Value = "display:block";//.Visible = true; } //dlCAL_FORMULA.Visible = true; } #endregion #region//��ʼ���ۺϿ���������Ϊ����ij���ֶε�ֵ���ֶ��б�,��Щ�ֶ�������ϸ�� formObj = BLLTable<TF_FORM>.Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, formObj.M_FORM_ID); if (formObj != null) { numccc = new TF_TB_FIELD(); numccc.In(TF_TB_FIELD.Attribute.TYPE_CODE, TF_ENUM.FieldTypeCode.Decimal.ToString() + "," + TF_ENUM.FieldTypeCode.Number.ToString()); numccc.TB_ID = formObj.TB_ID; TF_TABLE tbObj = BLLTable<TF_TABLE>.Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, formObj.TB_ID); fieldList = new List<TF_TB_FIELD>(); fieldList = BLLTable<TF_TB_FIELD>.Factory(conn).Select(new TF_TB_FIELD(), numccc); if (fieldList != null && fieldList.Count > 0) { StringBuilder sbnumcols = new StringBuilder(); fieldList.ForEach(f => { sbnumcols.Append("<a class='cansel' data='" + tbObj.TB_NAME + "." + f.FIELD_NAME + "' onclick='selColToSum(this);'>" + f.NOTE + "(" + f.FIELD_NAME + ")</a>"); }); litSUM_FIELD_ID.Text = sbnumcols.ToString(); if (keyid != "") { dlSUM_FIELD_ID.Style.Value = "display:block";//.Visible = true; } //dlSUM_FIELD_ID.Visible = true; } } } #endregion } #region//��ʼ���ؼ����� TF_CTRL_TYPE ctrlCond = new TF_CTRL_TYPE(); ctrlCond.OrderBy(TF_CTRL_TYPE.Attribute.SORT_NO, Order.Asc); DataTable dtCtrl = BLLTable<TF_CTRL_TYPE>.SelectForDataTable(new TF_CTRL_TYPE(), ctrlCond); ViewState["CTRL_TYPE"] = valObj.CTRL_TYPE; DataView dv1 = new DataView(); dv1.Table = dtCtrl; dv1.RowFilter = "P_CTRL_TYPE='0'"; dv1.Sort = "SORT_NO asc"; for (int i = 0; i < dv1.Count; i++) { litCTRL_TYPE.Text += "<optgroup label='" + dv1[i]["CTRL_NAME"].ToString() + "'>"; DataView dv2 = new DataView(); dv2.Table = dtCtrl; dv2.RowFilter = "P_CTRL_TYPE='" + dv1[i]["CTRL_TYPE"].ToString() + "'"; dv2.Sort = "SORT_NO asc"; for (int a = 0; a < dv2.Count; a++) { if (valObj != null && valObj.CTRL_TYPE == dv2[a]["CTRL_TYPE"].ToString()) { litCTRL_TYPE.Text += "<option value='" + dv2[a]["CTRL_TYPE"].ToString() + "' selected='selected'>" + dv2[a]["CTRL_NAME"].ToString() + "</option>"; } else { litCTRL_TYPE.Text += "<option value='" + dv2[a]["CTRL_TYPE"].ToString() + "'>" + dv2[a]["CTRL_NAME"].ToString() + "</option>"; } } litCTRL_TYPE.Text += "</optgroup>"; } #endregion //} //catch (Exception ex) //{ // litWarn.Text = ex.Message; //} } }
protected void Page_Load(object sender, EventArgs e) { if (Request["selCOLUMN"] != null) { WF_STEP_FORM_TPL valObj = new WF_STEP_FORM_TPL(); int stepid = int.Parse(Request["StepID"]); WF_STEP_TPL stepObj = BLLTable <WF_STEP_TPL> .Factory(conn).GetRowData(WF_STEP_TPL.Attribute.STEP_ID, stepid); valObj.WFID = stepObj.WFID; valObj.PROCID = stepObj.PROCID; valObj.STEP_ID = stepid; valObj.COLUMN_ID = Convert.ToInt32(Request["selCOLUMN"]); TF_F_COLUMN wfObj = BLLTable <TF_F_COLUMN> .Factory(conn).GetRowData(TF_F_COLUMN.Attribute.COLUMN_ID, valObj.COLUMN_ID); valObj.FORM_ID = wfObj.FORM_ID; BLLTable <WF_STEP_FORM_TPL> .Factory(conn).Insert(valObj, WF_STEP_FORM_TPL.Attribute.STEP_FID); Response.Write(valObj._COLUMN_ID.ToString()); } //在列表里点击删除按钮,通过AJAX执行这里的后台代码,删除一条记录 if (Request["DelByKeyID"] != null) { int re = BLLTable <WF_STEP_FORM_TPL> .Factory(conn).Delete(WF_STEP_FORM_TPL.Attribute.STEP_FID, Request["DelByKeyID"]); if (re > 0) { Response.Write("{re:1,msg:'删除成功!'}");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("{re:0,msg:'删除失败!'}"); } } //在列表顶部点击删除按钮,通过AJAX执行这里的后台代码,删除多条记录 if (Request["DelKeyIDS"] != null) { WF_STEP_FORM_TPL cond = new WF_STEP_FORM_TPL(); cond.In(WF_STEP_FORM_TPL.Attribute.STEP_FID, Request["DelKeyIDS"]); int re = BLLTable <WF_STEP_FORM_TPL> .Factory(conn).Delete(cond); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在用户详细信息查看编辑页面,点保存时,通过AJAX执行这里的后台代码,实现部门字段的更新 if (Request["saveInfo"] != null) { WF_STEP_FORM_TPL val = new WF_STEP_FORM_TPL(); val.STEP_FID = int.Parse(Request["FieldKeyID"]); List <AttributeItem> lstCol = val.af_AttributeItemList; for (int i = 0; i < lstCol.Count; i++) { if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName])) { val.SetValue(lstCol[i].FieldName, Request["txt" + lstCol[i].FieldName]); } } BLLTable <WF_STEP_FORM_TPL> .Factory(conn).Update(val, WF_STEP_FORM_TPL.Attribute.STEP_FID); Response.Write("修改用户信息成功"); } Response.End(); }
protected void btnOK_Click(object sender, EventArgs e) { //try //{ #region TF_TB_FIELD valObj = new TF_TB_FIELD(); valObj.TB_ID = int.Parse(tbid); // Convert.ToInt32(txtTB_ID.Value); if (txtFIELD_NAME.Value != "") { valObj.FIELD_NAME = Convert.ToString(txtFIELD_NAME.Value); } if (ViewState["OLDNAME"].ToString() != txtFIELD_NAME.Value) { if (BLLTable <TF_TB_FIELD> .Exists(valObj)) { litWarn.Text = "此字段已经存在,请重新输入!"; return; } } if (txtFIELD_ID.Value != "") { valObj.FIELD_ID = Convert.ToInt32(txtFIELD_ID.Value); } if (txtFIELD_TYPE.Value != "") { TF_FIELD_DBTYPE typeObj = BLLTable <TF_FIELD_DBTYPE> .Factory(conn).GetRowData(TF_FIELD_DBTYPE.Attribute.TYPE_CODE, txtFIELD_TYPE.Value); valObj.TYPE_CODE = typeObj.TYPE_CODE; valObj.DB_TYPE = typeObj.DB_TYPE; //valObj.TYPE_ID = Convert.ToInt32(txtFIELD_TYPE.Value); } //if(txtDB_TYPE.Value !="" ) // valObj.DB_TYPE = Convert.ToString(txtDB_TYPE.Value); valObj.IS_NULL = txtIS_NULL.Checked == true ? 1 : 0; if (txtNOTE.Value != "") { valObj.NOTE = Convert.ToString(txtNOTE.Value); } if (txtDEFAULT_VAL.Value != "") { valObj.DEFAULT_VAL = Convert.ToString(txtDEFAULT_VAL.Value); } //if (txtTB_ID.Value != "") if (txtCTRL_TYPE.Value != "") { valObj.CTRL_TYPE = Convert.ToString(txtCTRL_TYPE.Value); } if (txtSORT_NO.Value != "") { valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value); } #endregion int editb = -9; if (keyid != "") { valObj.FIELD_ID = Convert.ToInt32(keyid); //TF_TB_FIELD oldObj = BLLTable<TF_TB_FIELD>.Factory(conn).GetRowData(TF_TB_FIELD.Attribute.FIELD_ID, keyid); editb = new AgileFrame.Common.TF_TABLEHelper(conn).SaveOrUpdateField(valObj, ViewState["OLDNAME"].ToString(), ref errMsg); //同时修改正式表和流程临时表字段 if (editb > 0) { count = BLLTable <TF_TB_FIELD> .Factory(conn).Update(valObj, TF_TB_FIELD.Attribute.FIELD_ID); } else { litWarn.Text = "在数据库里修改字段信息失败!" + editb; return; } } else { //editb = new AgileFrame.Common.TF_TABLEHelper(conn).AddField(valObj, ref errMsg); editb = new AgileFrame.Common.TF_TABLEHelper(conn).InsertOrUpdateField(valObj, null, ref errMsg); if (editb > 0) { valObj.CREATED = ckAddToFormCol.Checked == true ? 1 : 0; count = BLLTable <TF_TB_FIELD> .Factory(conn).Insert(valObj, TF_TB_FIELD.Attribute.FIELD_ID); keyid = valObj.FIELD_ID.ToString(); } else { litWarn.Text = "在数据库里创建字段信息失败!" + editb; return; } } if (count > 0) { if (editb > 0) { if (ckAddToFormCol.Checked == true && count > 0) { #region //同时新建为某个表单的栏目,前提是此表倍某个表单使用中。 List <TF_FORM> lstForm = BLLTable <TF_FORM> .Factory(conn).Select(TF_FORM.Attribute.TB_ID, valObj.TB_ID); if (lstForm != null) { lstForm.ForEach(f => { TF_F_COLUMN valCol = new TF_F_COLUMN(); valCol.TB_ID = valObj.TB_ID; valCol.FORM_ID = f.FORM_ID; valCol.FIELD_ID = valObj.FIELD_ID; if (!BLLTable <TF_F_COLUMN> .Exists(valCol)) { valCol.SHOW_NAME = valObj.NOTE; valCol.CTRL_TYPE = valObj.CTRL_TYPE; valCol.MAX_VAL = 0; valCol.IS_DEFAULT = "0"; valCol.MIN_VAL = 0; valCol.IS_NEED = valObj.IS_NULL == 1 ? 0 : 1; valCol.SORT_NO = valObj.SORT_NO; valCol.SHOWIN_FORM = "1"; BLLTable <TF_F_COLUMN> .Factory(conn).Insert(valCol, TF_F_COLUMN.Attribute.COLUMN_ID); } }); } #endregion } } #region if (Request["tree"] != null) { string gotoUrl = "../../../../ok.aspx"; StringBuilder sb = new StringBuilder("{"); sb.Append("id:'"); sb.Append(keyid).Append("',pid:'").Append(valObj.TB_ID).Append("',no:").Append(valObj.SORT_NO).Append(",sc:0,name:'"); sb.Append(valObj.NOTE).Append("',ntype:'field'}"); if (Request["edit"] == null) { AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false); } else { AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false); } } else { 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("})"); Button btn = (Button)sender; if (btn.ID == "btnOK") { if (ViewState["hadSave"] == null) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}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 { txtFIELD_NAME.Value = ""; txtFIELD_TYPE.Value = ""; txtIS_NULL.Value = ""; txtNOTE.Value = ""; txtDEFAULT_VAL.Value = ""; } } #endregion } else { litWarn.Text = "修改记录没有成功!"; } //} //catch (Exception ex) //{ // litWarn.Text = ex.Message; //} }
private void BindList(TF_F_COLUMN condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ����������������� condObj.af_PageBy(TF_F_COLUMN.Attribute.SORT_NO, Order.Asc); if (formid != "") { condObj.FORM_ID = int.Parse(formid); } listObj = BLLTable<TF_F_COLUMN>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj.Where(s=>s.IS_DEFAULT=="0"); repList.DataBind(); aspPager.RecordCount = recount; //repDefault.DataSource = listObj.Where(s => s.IS_DEFAULT == "1"); //repDefault.DataBind(); TF_F_COLUMN ccc = new TF_F_COLUMN(); if (Request["ntype"] == "form-mx") { ccc.FORM_ID = -1; } else { ccc.FORM_ID = 0; } listObj = BLLTable<TF_F_COLUMN>.Factory(conn).Select(valObj, ccc); repDefault.DataSource = listObj; repDefault.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "编辑"; Page.Title = title; if (!string.IsNullOrEmpty(Request["COLUMN_ID"])) { keyid = Request["COLUMN_ID"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (!string.IsNullOrEmpty(Request["edit"]) && Request["ntype"] == "formcol") { keyid = Request["id"]; } if (Request["ntype"] == "form" || Request["ntype"] == "form-mx") { formid = Request["id"]; txtFORM_ID.Value = formid; } if (!string.IsNullOrEmpty(Request["formid"])) { formid = Request["formid"]; txtFORM_ID.Value = formid; } if (!IsPostBack) { dlCAL_FORMULA.Style.Value = "display:none"; //.Visible = false; dlSUM_FIELD_ID.Style.Value = "display:none"; //.Visible = false; //try //{ ViewState["txtFIELD_ID"] = ""; if (keyid != "") { valObj = BLLTable <TF_F_COLUMN> .Factory(conn).GetRowData(TF_F_COLUMN.Attribute.COLUMN_ID, keyid); if (valObj == null) { return; } txtCOLUMN_ID.Value = Convert.ToString(valObj.COLUMN_ID); //Convert.ToInt32 formid = valObj.FORM_ID.ToString(); txtFORM_ID.Value = Convert.ToString(valObj.FORM_ID); //Convert.ToInt32 txtTB_ID.Value = Convert.ToString(valObj.TB_ID); //Convert.ToInt32 hidFIELD_ID.Value = Convert.ToString(valObj.FIELD_ID); //Convert.ToInt32 txtFIELD_ID.Value = BLLTable <TF_TB_FIELD> .Factory(conn).GetOneValue(TF_TB_FIELD.Attribute.FIELD_ID, valObj.FIELD_ID, TF_TB_FIELD.Attribute.NOTE); ViewState["txtFIELD_ID"] = txtFIELD_ID.Value; txtSHOW_NAME.Value = Convert.ToString(valObj.SHOW_NAME);//Convert.ToString //txtCTRL_TYPE.Value = Convert.ToString(valObj.CTRL_TYPE);//Convert.ToString txtMAX_VAL.Value = Convert.ToString(valObj.MAX_VAL); //Convert.ToInt32 txtMIN_VAL.Value = Convert.ToString(valObj.MIN_VAL); //Convert.ToInt32 txtIS_NEED.Checked = valObj.IS_NEED == 1 ? true : false; //Convert.ToInt32 //txtCAL_FORMULA.Value = Convert.ToString(valObj.CAL_FORMULA);//Convert.ToString txtSUM_FIELD_ID.Value = Convert.ToString(valObj.SUM_FIELD_ID); //Convert.ToString txtSORT_NO.Value = Convert.ToString(valObj.SORT_NO); //Convert.ToInt32 txtCAL_FORMULA.Value = valObj.CAL_FORMULA; if (valObj.SHOWIN_HEADER == "1") { txtSHOWIN_HEADR.Checked = true; } else { txtSHOWIN_HEADR.Checked = false; } txtSHOWIN_FORM.Checked = valObj.SHOWIN_FORM == "1" ? true : false; TF_TB_FIELD fieldObj = BLLTable <TF_TB_FIELD> .Factory(conn).GetRowData(TF_TB_FIELD.Attribute.FIELD_ID, valObj.FIELD_ID); if (fieldObj != null) { if (fieldObj.TYPE_CODE == TF_ENUM.FieldTypeCode.Decimal.ToString() || fieldObj.TYPE_CODE == TF_ENUM.FieldTypeCode.Number.ToString()) { //dlCAL_FORMULA.Style.Value = "display:block";//.Visible = true; } else { dlCAL_FORMULA.Visible = false; dlSUM_FIELD_ID.Visible = false; } } else { litWarn.Text = "对应字段关联不正确。"; } // Response.Write(fieldObj.TYPE_CODE); } if (txtFORM_ID.Value != "") { #region //初始化用于编写公式的可选字段列表 TF_FORM formObj = BLLTable <TF_FORM> .Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, txtFORM_ID.Value); if (formObj != null && formObj.M_FORM_ID > 0) { TF_TB_FIELD numccc = new TF_TB_FIELD(); numccc.In(TF_TB_FIELD.Attribute.TYPE_CODE, TF_ENUM.FieldTypeCode.Decimal.ToString() + "," + TF_ENUM.FieldTypeCode.Number.ToString()); numccc.TB_ID = formObj.TB_ID; List <TF_TB_FIELD> fieldList = BLLTable <TF_TB_FIELD> .Factory(conn).Select(new TF_TB_FIELD(), numccc); if (fieldList != null && fieldList.Count > 0) { StringBuilder sbnumcols = new StringBuilder(); fieldList.ForEach(f => { sbnumcols.Append("<a data='" + f.FIELD_NAME + "' onclick='selColToCalInput(this);'>" + f.NOTE + "(" + f.FIELD_NAME + ")</a>"); }); litNumberFields.Text = sbnumcols.ToString(); if (keyid != "") { dlCAL_FORMULA.Style.Value = "display:block"; //.Visible = true; } //dlCAL_FORMULA.Visible = true; } } #endregion #region //初始化综合可以用于作为主表某个字段的值的字段列表,这些字段来自明细表 if (formObj != null && formObj.M_FORM_ID > 0) { formObj = BLLTable <TF_FORM> .Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, formObj.M_FORM_ID); if (formObj != null) { TF_TB_FIELD numccc = new TF_TB_FIELD(); numccc.In(TF_TB_FIELD.Attribute.TYPE_CODE, TF_ENUM.FieldTypeCode.Decimal.ToString() + "," + TF_ENUM.FieldTypeCode.Number.ToString()); numccc.TB_ID = formObj.TB_ID; TF_TABLE tbObj = BLLTable <TF_TABLE> .Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, formObj.TB_ID); List <TF_TB_FIELD> fieldList = BLLTable <TF_TB_FIELD> .Factory(conn).Select(new TF_TB_FIELD(), numccc); if (fieldList != null && fieldList.Count > 0) { StringBuilder sbnumcols = new StringBuilder(); fieldList.ForEach(f => { sbnumcols.Append("<a class='cansel' data='" + tbObj.TB_NAME + "." + f.FIELD_NAME + "' onclick='selColToSum(this);'>" + f.NOTE + "(" + f.FIELD_NAME + ")</a>"); }); litSUM_FIELD_ID.Text = sbnumcols.ToString(); if (keyid != "") { dlSUM_FIELD_ID.Style.Value = "display:block"; //.Visible = true; } //dlSUM_FIELD_ID.Visible = true; } } } #endregion } #region //初始化控件类型 TF_CTRL_TYPE ctrlCond = new TF_CTRL_TYPE(); ctrlCond.OrderBy(TF_CTRL_TYPE.Attribute.SORT_NO, Order.Asc); DataTable dtCtrl = BLLTable <TF_CTRL_TYPE> .SelectForDataTable(new TF_CTRL_TYPE(), ctrlCond); ViewState["CTRL_TYPE"] = valObj.CTRL_TYPE; DataView dv1 = new DataView(); dv1.Table = dtCtrl; dv1.RowFilter = "P_CTRL_TYPE='0'"; dv1.Sort = "SORT_NO asc"; for (int i = 0; i < dv1.Count; i++) { litCTRL_TYPE.Text += "<optgroup label='" + dv1[i]["CTRL_NAME"].ToString() + "'>"; DataView dv2 = new DataView(); dv2.Table = dtCtrl; dv2.RowFilter = "P_CTRL_TYPE='" + dv1[i]["CTRL_TYPE"].ToString() + "'"; dv2.Sort = "SORT_NO asc"; for (int a = 0; a < dv2.Count; a++) { if (valObj != null && valObj.CTRL_TYPE == dv2[a]["CTRL_TYPE"].ToString()) { litCTRL_TYPE.Text += "<option value='" + dv2[a]["CTRL_TYPE"].ToString() + "' selected='selected'>" + dv2[a]["CTRL_NAME"].ToString() + "</option>"; } else { litCTRL_TYPE.Text += "<option value='" + dv2[a]["CTRL_TYPE"].ToString() + "'>" + dv2[a]["CTRL_NAME"].ToString() + "</option>"; } } litCTRL_TYPE.Text += "</optgroup>"; } #endregion //} //catch (Exception ex) //{ // litWarn.Text = ex.Message; //} } }
protected void Page_Load(object sender, EventArgs e) { valObj.af_PageBy(TF_F_COLUMN.Attribute.COLUMN_ID, Order.Desc); title = valObj._ZhName + "ѡ��"; Page.Title = title; if (Request["formid"] != null) { condObj.FORM_ID = int.Parse(Request["formid"]); } if (!IsPostBack) { aspPager.CurrentPageIndex = 1; aspPager.PageSize = 20; try { listObj = BLLTable<TF_F_COLUMN>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); FORM_BLL sub_bll = new FORM_BLL(condObj.FORM_ID); if (sub_bll.HadSubForm) { condObj = new TF_F_COLUMN(); condObj.FORM_ID = sub_bll.GetSubForm().FORM_ID; listObj2 = BLLTable<TF_F_COLUMN>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); } listObj.AddRange(listObj2); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } aspPager.RecordCount = recount; } }
protected void btnOK_Click(object sender, EventArgs e) { try { TF_F_COLUMN valObj = new TF_F_COLUMN(); if (txtFORM_ID.Value != "") { valObj.FORM_ID = Convert.ToInt32(txtFORM_ID.Value); } if (txtFIELD_ID.Value != "") { valObj.FIELD_ID = Convert.ToInt32(hidFIELD_ID.Value); } if (ViewState["txtFIELD_ID"].ToString() != txtFIELD_ID.Value) { if (BLLTable <TF_F_COLUMN> .Exists(valObj)) { litWarn.Text = "该表字段已经被某栏目使用。"; return; } } if (txtCOLUMN_ID.Value != "") { valObj.COLUMN_ID = Convert.ToInt32(txtCOLUMN_ID.Value); } if (txtTB_ID.Value != "") { valObj.TB_ID = Convert.ToInt32(txtTB_ID.Value); } if (txtSHOWIN_HEADR.Checked == true) { valObj.SHOWIN_HEADER = "1"; } else { valObj.SHOWIN_HEADER = "0"; } if (txtSHOW_NAME.Value != "") { valObj.SHOW_NAME = txtSHOW_NAME.Value; } //if(txtCTRL_TYPE.Value !="" ) valObj.CTRL_TYPE = Request["txtCTRL_TYPE"]; if (txtMAX_VAL.Value != "") { valObj.MAX_VAL = Convert.ToInt32(txtMAX_VAL.Value); } if (txtMIN_VAL.Value != "") { valObj.MIN_VAL = Convert.ToInt32(txtMIN_VAL.Value); } valObj.IS_NEED = txtIS_NEED.Checked == true ? 1 : 0; if (txtSORT_NO.Value != "") { valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value); } valObj.CAL_FORMULA = txtCAL_FORMULA.Value; valObj.SHOWIN_FORM = txtSHOWIN_FORM.Checked == true ? "1" : "0"; valObj.SUM_FIELD_ID = txtSUM_FIELD_ID.Value; if (keyid != "") { valObj.COLUMN_ID = Convert.ToInt32(keyid); count = BLLTable <TF_F_COLUMN> .Factory(conn).Update(valObj, TF_F_COLUMN.Attribute.COLUMN_ID); } else { valObj.IS_DEFAULT = "0"; count = BLLTable <TF_F_COLUMN> .Factory(conn).Insert(valObj, TF_F_COLUMN.Attribute.COLUMN_ID); keyid = valObj.COLUMN_ID.ToString(); } if (count > 0) { Button btn = (Button)sender; if (Request["tree"] != null) { string gotoUrl = "../../../../ok.aspx"; StringBuilder sb = new StringBuilder("{"); sb.Append("id:'"); sb.Append(keyid).Append("',pid:'").Append(valObj.FORM_ID).Append("',no:").Append(valObj.SORT_NO).Append(",sc:0,name:'"); sb.Append(valObj.SHOW_NAME).Append("',ntype:'field'}"); if (Request["edit"] == null) { AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false); } else { AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false); } } else { 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 (btn.ID.IndexOf("btnOK") != -1) { litWarn.Text = "修改栏目信息成功!"; if (ViewState["hadSave"] == null) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}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 { litWarn.Text = "修改栏目信息成功!"; txtSHOW_NAME.Value = ""; //txtCTRL_TYPE.Value =""; txtMAX_VAL.Value = ""; txtMIN_VAL.Value = ""; txtIS_NEED.Checked = true; } } } } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void btnOK_Click(object sender, EventArgs e) { try { TF_FORM valObj = new TF_FORM(); if(txtFORM_ID.Value !="" ) valObj.FORM_ID = Convert.ToInt32(txtFORM_ID.Value); if(txtF_NAME.Value !="" ) valObj.F_NAME = txtF_NAME.Value; if(txtTB_ID.Value !="" ) valObj.TB_ID = Convert.ToInt32(hidTB_ID.Value); valObj.TPL_EDIT = txtTPL_EDIT.Value; valObj.TPL_SHOW =txtTPL_SHOW.Value; valObj.TPL_PRINT =txtTPL_PRINT.Value; valObj.TPL_LIST = txtTPL_LIST.Value; if (keyid != "") { valObj.FORM_ID = Convert.ToInt32(keyid); count = BLLTable<TF_FORM>.Factory(conn).Update(valObj, TF_FORM.Attribute.FORM_ID); } else { valObj.M_FORM_ID = pid; count = BLLTable<TF_FORM>.Factory(conn).Insert(valObj, TF_FORM.Attribute.FORM_ID); keyid = valObj.FORM_ID.ToString(); if (count > 0) { #region//�Զ�����Ĭ�ϱ����Ŀ TF_TB_FIELD cond = new TF_TB_FIELD(); cond.TB_ID = valObj.TB_ID; //cond.In(TF_TB_FIELD.Attribute.TB_ID, valObj.TB_ID + ",0"); List<TF_TB_FIELD> lstField = BLLTable<TF_TB_FIELD>.Factory(conn).Select(new TF_TB_FIELD(), cond); if (lstField != null) { TF_F_COLUMN valCol = new TF_F_COLUMN(); valCol.TB_ID = valObj.TB_ID; valCol.FORM_ID = valObj.FORM_ID; lstField.ForEach(f => { valCol.FIELD_ID = f.FIELD_ID; valCol.SHOW_NAME = f.NOTE; valCol.CTRL_TYPE = f.CTRL_TYPE; valCol.SHOWIN_FORM = "1"; valCol.MAX_VAL = 0; if (f.TB_ID == 0) { valCol.IS_DEFAULT = "1"; } else { valCol.IS_DEFAULT = "0"; } valCol.MIN_VAL = 0; valCol.IS_NEED = f.IS_NULL == 1 ? 0 : 1; valCol.SORT_NO = f.SORT_NO; int aaa=BLLTable<TF_F_COLUMN>.Factory(conn).Insert(valCol, TF_F_COLUMN.Attribute.COLUMN_ID); if (aaa > 0) { BLLTable<TF_TB_FIELD>.Factory(conn).Update(TF_TB_FIELD.Attribute.FIELD_ID, f.FIELD_ID, TF_TB_FIELD.Attribute.CREATED, 1); } }); } #endregion List<TF_TABLE> lstMX = BLLTable<TF_TABLE>.Factory(conn).Select(TF_TABLE.Attribute.M_TB_ID, valObj.TB_ID); if (lstMX != null && lstMX.Count > 0) { lstMX.ForEach(tb => { TF_FORM valMX = new TF_FORM(); valMX.F_NAME = tb.CH_NAME; valMX.TB_ID = Convert.ToInt32(tb.TB_ID); valMX.TPL_EDIT = ""; valMX.TPL_SHOW = ""; valMX.TPL_PRINT = ""; valMX.TPL_LIST = ""; valMX.M_FORM_ID = valObj.FORM_ID; int addmx = BLLTable<TF_FORM>.Factory(conn).Insert(valMX, TF_FORM.Attribute.FORM_ID); #region//�Զ�����Ĭ�ϱ����Ŀ TF_TB_FIELD condFFF = new TF_TB_FIELD(); //condFFF.In(TF_TB_FIELD.Attribute.TB_ID, valMX.TB_ID + ",0"); condFFF.TB_ID = valMX.TB_ID; lstField = BLLTable<TF_TB_FIELD>.Factory(conn).Select(new TF_TB_FIELD(), condFFF); if (lstField != null) { TF_F_COLUMN valCol = new TF_F_COLUMN(); valCol.TB_ID = valMX.TB_ID; valCol.FORM_ID = valMX.FORM_ID; lstField.ForEach(f => { valCol.FIELD_ID = f.FIELD_ID; valCol.SHOW_NAME = f.NOTE; valCol.CTRL_TYPE = f.CTRL_TYPE; valCol.SHOWIN_FORM = "1"; valCol.MAX_VAL = 0; if (f.TB_ID == 0) { valCol.IS_DEFAULT = "1"; } else { valCol.IS_DEFAULT = "0"; } valCol.MIN_VAL = 0; valCol.IS_NEED = f.IS_NULL == 1 ? 0 : 1; valCol.SORT_NO = f.SORT_NO; int aaa=BLLTable<TF_F_COLUMN>.Factory(conn).Insert(valCol, TF_F_COLUMN.Attribute.COLUMN_ID); if (aaa > 0) { BLLTable<TF_TB_FIELD>.Factory(conn).Update(TF_TB_FIELD.Attribute.FIELD_ID, f.FIELD_ID, TF_TB_FIELD.Attribute.CREATED, 1); } }); } #endregion }); } } } 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("})"); Button btn = (Button)sender; if (btn.ID == "btnOK") { if (Request["tree"] != null) { string gotoUrl = "../../../ok.aspx"; StringBuilder sb = new StringBuilder("{"); sb.Append("id:'"); sb.Append(keyid).Append("',pid:'").Append("0").Append("',no:").Append(valObj.FORM_ID).Append(",sc:1,name:'"); //CHG START ����ڵ�ѡ��ҳ���������� jin-shenjian 2013/10/26 //sb.Append(valObj.F_NAME).Append("',ntype:'form'}"); sb.Append(valObj.F_NAME).Append("',ntype:'TF_FORM_MANAGE'}"); //CHG END ����ڵ�ѡ��ҳ���������� jin-shenjian 2013/10/26 if (Request["edit"] == null) { AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false); } else { AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false); } } else { if (ViewState["hadSave"] == null) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}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 { txtF_NAME.Value =""; txtTB_ID.Value =""; } } } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new TF_F_COLUMN(); if (txtCOLUMN_ID.Value != "") { condObj.Like_OR(TF_F_COLUMN.Attribute.COLUMN_ID, Convert.ToInt32(txtCOLUMN_ID.Value)); } if (txtFORM_ID.Value != "") { condObj.Like_OR(TF_F_COLUMN.Attribute.FORM_ID, Convert.ToInt32(txtFORM_ID.Value)); } if (txtTB_ID.Value != "") { condObj.Like_OR(TF_F_COLUMN.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value)); } if (txtFIELD_ID.Value != "") { condObj.Like_OR(TF_F_COLUMN.Attribute.FIELD_ID, Convert.ToInt32(txtFIELD_ID.Value)); } if (txtSHOW_NAME.Value != "") { condObj.Like_OR(TF_F_COLUMN.Attribute.SHOW_NAME, Convert.ToString(txtSHOW_NAME.Value)); } if (txtCTRL_TYPE.Value != "") { condObj.Like_OR(TF_F_COLUMN.Attribute.CTRL_TYPE, Convert.ToString(txtCTRL_TYPE.Value)); } if (txtMAX_VAL.Value != "") { condObj.Like_OR(TF_F_COLUMN.Attribute.MAX_VAL, Convert.ToInt32(txtMAX_VAL.Value)); } if (txtMIN_VAL.Value != "") { condObj.Like_OR(TF_F_COLUMN.Attribute.MIN_VAL, Convert.ToInt32(txtMIN_VAL.Value)); } if (txtIS_NEED.Value != "") { condObj.Like_OR(TF_F_COLUMN.Attribute.IS_NEED, Convert.ToInt32(txtIS_NEED.Value)); } if (txtCAL_FORMULA.Value != "") { condObj.Like_OR(TF_F_COLUMN.Attribute.CAL_FORMULA, Convert.ToString(txtCAL_FORMULA.Value)); } if (txtSUM_FIELD_ID.Value != "") { condObj.Like_OR(TF_F_COLUMN.Attribute.SUM_FIELD_ID, Convert.ToString(txtSUM_FIELD_ID.Value)); } if (txtSORT_NO.Value != "") { condObj.Like_OR(TF_F_COLUMN.Attribute.SORT_NO, Convert.ToInt32(txtSORT_NO.Value)); } try { hidCondition.Value = condObj.ToJson(20); listObj = BLLTable <TF_F_COLUMN> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void btnOK_Click(object sender, EventArgs e) { try { TF_F_COLUMN valObj = new TF_F_COLUMN(); if (txtFORM_ID.Value != "") valObj.FORM_ID = Convert.ToInt32(txtFORM_ID.Value); if (txtFIELD_ID.Value != "") valObj.FIELD_ID = Convert.ToInt32(hidFIELD_ID.Value); if (ViewState["txtFIELD_ID"].ToString() != txtFIELD_ID.Value) { if (BLLTable<TF_F_COLUMN>.Exists(valObj)) { litWarn.Text = "�ñ��ֶ��Ѿ���ij��Ŀʹ�á�"; return; } } if(txtCOLUMN_ID.Value !="" ) valObj.COLUMN_ID = Convert.ToInt32(txtCOLUMN_ID.Value); if(txtTB_ID.Value !="" ) valObj.TB_ID = Convert.ToInt32(txtTB_ID.Value); if (txtDEFAULT_VAL.Value != "") valObj.DEFAULT_VAL = Convert.ToString(txtDEFAULT_VAL.Value); if (txtSHOWIN_HEADR.Checked == true) { valObj.SHOWIN_HEADER = "1"; } else { valObj.SHOWIN_HEADER = "0"; } if(txtSHOW_NAME.Value !="" ) valObj.SHOW_NAME = txtSHOW_NAME.Value; //if(txtCTRL_TYPE.Value !="" ) valObj.CTRL_TYPE = Request["txtCTRL_TYPE"]; if(txtMAX_VAL.Value !="" ) valObj.MAX_VAL = Convert.ToInt32(txtMAX_VAL.Value); if(txtMIN_VAL.Value !="" ) valObj.MIN_VAL = Convert.ToInt32(txtMIN_VAL.Value); valObj.IS_NEED = txtIS_NEED.Checked == true ? 1 : 0; if(txtSORT_NO.Value !="" ) valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value); valObj.CAL_FORMULA = txtCAL_FORMULA.Value; valObj.SHOWIN_FORM = txtSHOWIN_FORM.Checked == true ? "1" : "0"; valObj.SUM_FIELD_ID = txtSUM_FIELD_ID.Value; if (keyid != "") { valObj.COLUMN_ID = Convert.ToInt32(keyid); count = BLLTable<TF_F_COLUMN>.Factory(conn).Update(valObj, TF_F_COLUMN.Attribute.COLUMN_ID); //ADD START ���±��ֶ��Ƿ�ʹ��״̬ jin-shenjian 2013/10/28 //���±��ֶ��Ƿ�ʹ��״̬ TF_TB_FIELD objCond = new TF_TB_FIELD(); objCond.FIELD_ID = Convert.ToInt32(hidFIELD_ID.Value); TF_TB_FIELD objVal = new TF_TB_FIELD(); //�ֶ���ʹ�� objVal.CREATED = 1; count += BLLTable<TF_TB_FIELD>.Factory(conn).Update(objVal, objCond); objCond = new TF_TB_FIELD(); objCond.FIELD_ID = Convert.ToInt32(Convert.ToString(ViewState["hidFIELD_ID"])); objVal = new TF_TB_FIELD(); //�ֶ�δʹ�� objVal.CREATED = 0; count += BLLTable<TF_TB_FIELD>.Factory(conn).Update(objVal, objCond); //ADD END ���±��ֶ��Ƿ�ʹ��״̬ jin-shenjian 2013/10/28 } else { valObj.IS_DEFAULT = "0"; count = BLLTable<TF_F_COLUMN>.Factory(conn).Insert(valObj, TF_F_COLUMN.Attribute.COLUMN_ID); keyid = valObj.COLUMN_ID.ToString(); //ADD START ���±��ֶ��Ƿ�ʹ��״̬ jin-shenjian 2013/10/28 //���±��ֶ��Ƿ�ʹ��״̬ TF_TB_FIELD objCond = new TF_TB_FIELD(); objCond.FIELD_ID = Convert.ToInt32(hidFIELD_ID.Value); TF_TB_FIELD objVal = new TF_TB_FIELD(); //�ֶ���ʹ�� objVal.CREATED = 1; count += BLLTable<TF_TB_FIELD>.Factory(conn).Update(objVal, objCond); //ADD END ���±��ֶ��Ƿ�ʹ��״̬ jin-shenjian 2013/10/28 } if (count > 0) { Button btn = (Button)sender; if (Request["tree"] != null) { string gotoUrl = "../../../../ok.aspx"; StringBuilder sb = new StringBuilder("{"); sb.Append("id:'"); sb.Append(keyid).Append("',pid:'").Append(valObj.FORM_ID).Append("',no:").Append(valObj.SORT_NO).Append(",sc:0,name:'"); //CHG START ����ڵ�ѡ��ҳ���������� jin-shenjian 2013/10/26 //sb.Append(valObj.SHOW_NAME).Append("',ntype:'field'}"); sb.Append(valObj.SHOW_NAME).Append("',ntype:'TF_F_COLUMN'}"); //CHG END ����ڵ�ѡ��ҳ���������� jin-shenjian 2013/10/26 if (Request["edit"] == null) { AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false); } else { AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false); } } else { 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 (btn.ID.IndexOf("btnOK") != -1) { //litWarn.Text = "����Ŀ��Ϣ�ɹ���"; //if (ViewState["hadSave"] == null) //{ // ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}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 { litWarn.Text = "����Ŀ��Ϣ�ɹ���"; txtSHOW_NAME.Value = ""; //txtCTRL_TYPE.Value =""; txtDEFAULT_VAL.Value = ""; txtMAX_VAL.Value = ""; txtMIN_VAL.Value = ""; txtIS_NEED.Checked = true; } } } } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void btnOK_Click(object sender, EventArgs e) { //try //{ #region TF_TB_FIELD valObj = new TF_TB_FIELD(); valObj.TB_ID = int.Parse(tbid);// Convert.ToInt32(txtTB_ID.Value); if (txtFIELD_NAME.Value != "") valObj.FIELD_NAME = Convert.ToString(txtFIELD_NAME.Value); if (ViewState["OLDNAME"].ToString() != txtFIELD_NAME.Value) { if (BLLTable<TF_TB_FIELD>.Exists(valObj)) { litWarn.Text = "���ֶ��Ѿ����ڣ����������룡"; return; } } if (txtFIELD_ID.Value != "") valObj.FIELD_ID = Convert.ToInt32(txtFIELD_ID.Value); if (txtFIELD_TYPE.Value != "") { TF_FIELD_DBTYPE typeObj = BLLTable<TF_FIELD_DBTYPE>.Factory(conn).GetRowData(TF_FIELD_DBTYPE.Attribute.TYPE_CODE, txtFIELD_TYPE.Value); valObj.TYPE_CODE = typeObj.TYPE_CODE; valObj.DB_TYPE = typeObj.DB_TYPE; //valObj.TYPE_ID = Convert.ToInt32(txtFIELD_TYPE.Value); } //if(txtDB_TYPE.Value !="" ) // valObj.DB_TYPE = Convert.ToString(txtDB_TYPE.Value); valObj.IS_NULL = txtIS_NULL.Checked == true ? 1 : 0; if(txtNOTE.Value !="" ) valObj.NOTE = Convert.ToString(txtNOTE.Value); if(txtDEFAULT_VAL.Value !="" ) valObj.DEFAULT_VAL = Convert.ToString(txtDEFAULT_VAL.Value); //if (txtTB_ID.Value != "") if(txtCTRL_TYPE.Value !="" ) valObj.CTRL_TYPE = Convert.ToString(txtCTRL_TYPE.Value); if(txtSORT_NO.Value !="" ) valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value); #endregion int editb = -9; if (keyid != "") { valObj.FIELD_ID = Convert.ToInt32(keyid); //TF_TB_FIELD oldObj = BLLTable<TF_TB_FIELD>.Factory(conn).GetRowData(TF_TB_FIELD.Attribute.FIELD_ID, keyid); editb = new AgileFrame.Common.TF_TABLEHelper(conn).SaveOrUpdateField(valObj, ViewState["OLDNAME"].ToString(), ref errMsg);//ͬʱ����ʽ���������ʱ���ֶ� if (editb > 0) { count = BLLTable<TF_TB_FIELD>.Factory(conn).Update(valObj, TF_TB_FIELD.Attribute.FIELD_ID); } else { litWarn.Text = "�����ݿ������ֶ���Ϣʧ�ܣ�" + editb; return; } } else { //editb = new AgileFrame.Common.TF_TABLEHelper(conn).AddField(valObj, ref errMsg); editb = new AgileFrame.Common.TF_TABLEHelper(conn).InsertOrUpdateField(valObj, null, ref errMsg); if (editb > 0) { valObj.CREATED = ckAddToFormCol.Checked == true ? 1 : 0; count = BLLTable<TF_TB_FIELD>.Factory(conn).Insert(valObj, TF_TB_FIELD.Attribute.FIELD_ID); keyid = valObj.FIELD_ID.ToString(); } else { litWarn.Text = "�����ݿ��ﴴ���ֶ���Ϣʧ�ܣ�" + editb; return; } } if (count > 0) { if (editb > 0) { if (ckAddToFormCol.Checked == true && count > 0) { #region//ͬʱ�½�Ϊij���������Ŀ��ǰ���Ǵ˱��ij�����ʹ���С� List<TF_FORM> lstForm = BLLTable<TF_FORM>.Factory(conn).Select(TF_FORM.Attribute.TB_ID, valObj.TB_ID); if (lstForm != null) { lstForm.ForEach(f => { TF_F_COLUMN valCol = new TF_F_COLUMN(); valCol.TB_ID = valObj.TB_ID; valCol.FORM_ID = f.FORM_ID; valCol.FIELD_ID = valObj.FIELD_ID; if (!BLLTable<TF_F_COLUMN>.Exists(valCol)) { valCol.SHOW_NAME = valObj.NOTE; valCol.CTRL_TYPE = valObj.CTRL_TYPE; valCol.MAX_VAL = 0; valCol.IS_DEFAULT = "0"; valCol.MIN_VAL = 0; valCol.IS_NEED = valObj.IS_NULL == 1 ? 0 : 1; valCol.SORT_NO = valObj.SORT_NO; valCol.SHOWIN_FORM = "1"; BLLTable<TF_F_COLUMN>.Factory(conn).Insert(valCol, TF_F_COLUMN.Attribute.COLUMN_ID); } }); } #endregion } } #region if (Request["tree"] != null) { string gotoUrl = "../../../../ok.aspx"; StringBuilder sb = new StringBuilder("{"); sb.Append("id:'"); sb.Append(keyid).Append("',pid:'").Append(valObj.TB_ID).Append("',no:").Append(valObj.SORT_NO).Append(",sc:0,name:'"); sb.Append(valObj.NOTE).Append("',ntype:'field'}"); if (Request["edit"] == null) { AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false); } else { AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false); } } else { 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("})"); Button btn = (Button)sender; if (btn.ID == "btnOK") { if (ViewState["hadSave"] == null) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}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 { txtFIELD_NAME.Value = ""; txtFIELD_TYPE.Value = ""; txtIS_NULL.Value = ""; txtNOTE.Value = ""; txtDEFAULT_VAL.Value = ""; } } #endregion } else { litWarn.Text ="�ļ�¼û�гɹ���"; } //} //catch (Exception ex) //{ // litWarn.Text = ex.Message; //} }