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 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; //} }
protected void btnOK_Click(object sender, EventArgs e) { try { TF_TABLE valObj = new TF_TABLE(); if (string.IsNullOrEmpty(keyid)) { if (txtTB_NAME.Value != "") valObj.TB_NAME = txtTB_NAME_PRE.Value + txtTB_NAME.Value; if (ViewState["OLDNAME"].ToString() != valObj.TB_NAME) { if (BLLTable<TF_TABLE>.Exists(valObj)) { litWarn.Text = "�ñ��Ѿ����ڣ����������룡"; return; } } if (txtTB_ID.Value != "") valObj.TB_ID = Convert.ToInt32(txtTB_ID.Value); //if (txtM_TB_ID.Value != "") valObj.M_TB_ID = pid; if (txtTB_TYPE.Value != "") valObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value); } else { valObj.TB_NAME = txtTB_NAME_PRE.Value + txtTB_NAME.Value; } if(txtSORT_NO.Value !="" ) valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value); //ADD START ��������ȱ�� jin-shenjian 2013/10/12 if (txtCH_NAME.Value != "") valObj.CH_NAME = Convert.ToString(txtCH_NAME.Value); //ADD END ��������ȱ�� jin-shenjian 2013/10/12 if(txtNOTE.Value !="" ) valObj.NOTE = Convert.ToString(txtNOTE.Value); if (keyid != "") { valObj.TB_ID = Convert.ToInt32(keyid); count = BLLTable<TF_TABLE>.Factory(conn).Update(valObj, TF_TABLE.Attribute.TB_ID); if (count > 0) { TF_TABLEHelper.Factory(conn).EditTable(ViewState["OLDNAME"].ToString(), valObj, ref errMsg); } } else { int ret1 = AgileFrame.Common.TF_TABLEHelper.Factory(conn).AddTableWithDefaultCols(valObj, txtTB_NAME_Save.Value, GetConnByDevKey(txtDB_NAME_Save.Value), ref errMsg); if (ret1 == 0) { litWarn.Text = errMsg; Response.End(); return; } valObj.SOURCE_TABLE = txtTB_NAME_Save.Value; valObj.SOURCE_DB = txtDB_NAME_Save.Value; count = BLLTable<TF_TABLE>.Factory(conn).Insert(valObj, TF_TABLE.Attribute.TB_ID); keyid = valObj.TB_ID.ToString(); TF_TB_FIELD valField = new TF_TB_FIELD(); DataBaseTable tbsource = null; string strRetMessage = ""; if (!string.IsNullOrEmpty(valObj.TB_NAME) && DataBase.Factory(conn).TryGetValue(valObj.TB_NAME, out tbsource)) { int count1 = new TF_TABLEHelper(conn).SaveToTF_TB_FIELD(valObj.TB_NAME, valObj.TB_ID,ref strRetMessage); if (count1 < 1) { } } } if (count > 0) { string gotoUrl = WebHelper.GetAppPath() + @"ok.aspx"; if (Request["tree"] != null) { StringBuilder sb = new StringBuilder("{"); sb.Append("id:'"); sb.Append(keyid).Append("',pid:'").Append("0").Append("',no:").Append(valObj.SORT_NO).Append(",sc:1,name:'"); if (valObj.M_TB_ID > 0) { sb.Append(valObj.CH_NAME).Append("',ntype:'TF_TABLE-mx'}"); } else { sb.Append(valObj.CH_NAME).Append("',ntype:'TF_TABLE'}"); } 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.IndexOf("btnOK") != -1) { 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 { txtTB_NAME.Value = ""; txtCH_NAME.Value = ""; txtNOTE.Value = ""; } } } } 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; //} }