protected void btnFind_Click(object sender, EventArgs e) { condObj = new TF_TB_FIELD(); if (txtFIELD_NAME.Value != "") { condObj.Like(TF_TB_FIELD.Attribute.FIELD_NAME, Convert.ToString(txtFIELD_NAME.Value)); } if (txtFIELD_TYPE.Value != "") { //condObj.FIELD_TYPE = Convert.ToString(txtFIELD_TYPE.Value); if (txtIS_NULL.Value != "") { condObj.Like(TF_TB_FIELD.Attribute.IS_NULL, Convert.ToInt32(txtIS_NULL.Value)); } } if (txtNOTE.Value != "") { condObj.Like(TF_TB_FIELD.Attribute.NOTE, Convert.ToString(txtNOTE.Value)); } hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "��ϸ"; Page.Title = title; if (!IsPostBack) { try { if (!string.IsNullOrEmpty(Request["FIELD_ID"])) { valObj = BLLTable<TF_TB_FIELD>.Factory(conn).GetRowData(TF_TB_FIELD.Attribute.FIELD_ID, Request["FIELD_ID"]); if(valObj==null) return ; txtFIELD_ID.Text = Convert.ToString(valObj.FIELD_ID);//Convert.ToInt32 txtFIELD_NAME.Text = Convert.ToString(valObj.FIELD_NAME);//Convert.ToString //txtFIELD_TYPE.Text=valObj.FIELD_TYPE.ToString(); txtDB_TYPE.Text = Convert.ToString(valObj.DB_TYPE);//Convert.ToString txtIS_NULL.Text = Convert.ToString(valObj.IS_NULL);//Convert.ToInt32 txtNOTE.Text = Convert.ToString(valObj.NOTE);//Convert.ToString txtDEFAULT_VAL.Text = Convert.ToString(valObj.DEFAULT_VAL);//Convert.ToString txtTB_ID.Text = Convert.ToString(valObj.TB_ID);//Convert.ToInt32 txtCTRL_TYPE.Text = Convert.ToString(valObj.CTRL_TYPE);//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(); } } }
public int DelField(string fieldid, ref string errMsg) { try { TF_TB_FIELD field = BLLTable <TF_TB_FIELD> .Factory(conn).GetRowData(TF_TB_FIELD.Attribute.FIELD_ID, fieldid); string tbname = BLLTable <TF_TABLE> .Factory(conn).GetOneValue(TF_TABLE.Attribute.TB_ID, field.TB_ID, TF_TABLE.Attribute.TB_NAME); string msg = null; DataBaseField f1 = null; DataBaseTable t1 = null; if (DataBase.Factory(conn).TryGetValue(tbname, field.FIELD_NAME, out t1, out f1)) { if (!t1.DeleteField(field.FIELD_NAME, false, ref msg)) { errMsg += msg; return(0); } } return(1); } catch (Exception ex) { errMsg = ex.ToString(); return(-1); } }
public TF_TB_FIELD Parse(DataBaseField f2) { int sortInt = 0; TF_TB_FIELD f1 = new TF_TB_FIELD(); f1.FIELD_NAME = f2.FieldName; f1.NOTE = f2.Desc.ZhName; f1.DEFAULT_VAL = f2.DefaultValue; //f1.TB_ID; sortInt++; f1.SORT_NO = sortInt; f1.IS_KEY = (f2.IsKeyID) ? 1 : 0; f1.IS_AUTONUM = (f2.IsAutoIncrease) ? 1 : 0; f1.IS_NULL = (f2.IsAllowNull) ? 1 : 0; f1._CREATED = 1; switch (f2.Desc.Switch_CtrlType) { //case BaseCtrlType.SelectDrop: default: f1._CTRL_TYPE = f2.Desc.Switch_CtrlType == BaseCtrlType.UnKnown ? BaseCtrlType.InputString.ToString() : f2.Desc.Switch_CtrlType.ToString(); //f1._DB_TYPE = f2.DataType.TypeNameString; f1._DB_TYPE = f2.DataType.GetParamSql(); //char(8), decaml(8,0) f1.TYPE_CODE = StringHelper.HeadUpper(f2.DataType.NetType); f1.TYPE_ID = 0; break; } return(f1); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<TF_TB_FIELD>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <TF_TB_FIELD>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
public void getTemplateHtml() { string tableName = HttpUtil.GetReqStrValue("tableName"); string templateName = HttpUtil.GetReqStrValue("templateName"); if (templateName.Equals("默认")) { //默认,根据tableName取获取模板 ITableImplement itable = new ITableImplement(); itable.setConn(conn).setModule(tableName); int i = 0; string html = ""; string tr = "<tr>"; foreach (AttributeItem attr in itable.af_AttributeItemList) { if (i % 2 == 0) { html += tr + "</tr>"; tr = "<tr>"; } TF_TB_FIELD conf2 = new TF_TB_FIELD(); conf2.FIELD_NAME = attr.FieldName; TF_TB_FIELD val = BLLTable <TF_TB_FIELD> .GetRowData(conf2); if (val != null) { tr += "<td>" + val.NOTE + "</td><td>[" + tableName + "." + attr.FieldName + "]</td>"; } else { tr += "<td>" + (string.IsNullOrEmpty(attr.ZhName) ? attr.FieldName : attr.ZhName) + "</td><td>[" + tableName + "." + attr.FieldName + "]</td>"; } i++; } Response.Write(DEFAULT_TEMPLATE_START + html + DEFAULT_TEMPLATE_END); return; } TF_CUSTOM_TEMPLATE conf = new TF_CUSTOM_TEMPLATE(); conf.TEMPLATE_NAME = templateName; conf.TABLE_NAME = tableName; conf.USER_ID = Convert.ToInt32(userBase.StaffID); conf.TYPE = 0; TF_CUSTOM_TEMPLATE valObj = BLLTable <TF_CUSTOM_TEMPLATE> .GetRowData(conf); if (valObj == null) { Response.Write(""); } else { Response.Write(valObj.TEMPLATE_HTML); } }
protected void Page_Load(object sender, EventArgs e) { //在列表里点击删除按钮,通过AJAX执行这里的后台代码,删除一条记录 if (Request["DelFIELD_ID"] != null) { int re = BLLTable <TF_TB_FIELD> .Factory(conn).Delete(TF_TB_FIELD.Attribute.FIELD_ID, Request["DelFIELD_ID"]); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在列表顶部点击删除按钮,通过AJAX执行这里的后台代码,删除多条记录 if (Request["DelKeyIDS"] != null) { TF_TB_FIELD cond = new TF_TB_FIELD(); cond.In(TF_TB_FIELD.Attribute.FIELD_ID, Request["DelKeyIDS"]); int re = BLLTable <TF_TB_FIELD> .Factory(conn).Delete(cond); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在用户详细信息查看编辑页面,点保存时,通过AJAX执行这里的后台代码,实现部门字段的更新 if (Request["saveInfo"] != null) { TF_TB_FIELD val = new TF_TB_FIELD(); val.FIELD_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_TB_FIELD> .Factory(conn).Update(val, TF_TB_FIELD.Attribute.FIELD_ID); Response.Write("修改用户信息成功"); } Response.End(); }
protected void Page_Load(object sender, EventArgs e) { #region//默认隐藏的列 //hideTableColumnList = new List<AttributeItem>(); //hideTableColumnList.Add(TF_TB_FIELD.Attribute.EXP1); //hideTableColumnList.Add(TF_TB_FIELD.Attribute.EXP2); //hideTableColumnList.Add(TF_TB_FIELD.Attribute.EXP3); //valObj.LoadAllAttributes(true);//暂时加此代码,以后框架更新将不需要 //valObj.Remove(hideTableColumnList); //hideFindColumnList = new List<AttributeItem>(); //hideFindColumnList.Add(TF_TB_FIELD.Attribute.EXP1); //hideFindColumnList.Add(TF_TB_FIELD.Attribute.EXP2); //hideFindColumnList.Add(TF_TB_FIELD.Attribute.EXP3); #endregion condObj.OrderBy(TF_TB_FIELD.Attribute.FIELD_ID, Order.Desc); if (!IsPostBack) { btnFind.Text = LanguageService.GetLanguageString("btnFind", "查询"); aspPager.PageSize = 10; aspPager.CurrentPageIndex = 1; if (!string.IsNullOrEmpty(Request["ids"])) { TF_TB_FIELD roleOld = new TF_TB_FIELD(); roleOld.Where(TF_TB_FIELD.Attribute.FIELD_ID, Request["ids"].ToString()); listObj = BLLTable <TF_TB_FIELD> .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].FIELD_ID + "',Name:'" + listObj[i].FIELD_ID + "'}";//这里的Name用于显示在列表中,请自行重定义。 hidInitIDS.Value += listObj[i].FIELD_ID; } } try { listObj = BLLTable <TF_TB_FIELD> .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 Page_Load(object sender, EventArgs e) { //���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼ if (Request["DelFIELD_ID"] != null) { int re = BLLTable<TF_TB_FIELD>.Factory(conn).Delete(TF_TB_FIELD.Attribute.FIELD_ID, Request["DelFIELD_ID"]); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼ if (Request["DelKeyIDS"] != null) { TF_TB_FIELD cond = new TF_TB_FIELD(); cond.In(TF_TB_FIELD.Attribute.FIELD_ID, Request["DelKeyIDS"]); int re = BLLTable<TF_TB_FIELD>.Factory(conn).Delete(cond); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ��� if (Request["saveInfo"] != null) { TF_TB_FIELD val = new TF_TB_FIELD(); val.FIELD_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_TB_FIELD>.Factory(conn).Update(val, TF_TB_FIELD.Attribute.FIELD_ID); Response.Write("���û���Ϣ�ɹ�"); } Response.End(); }
/// <summary> /// 增加列 -废弃 /// </summary> public int AddField(TF_TB_FIELD field, ref string errMsg) { try { //TF_TABLE tbObj = BLLTable<TF_TABLE>.Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, field.TB_ID); //string tbname = tbObj.TB_NAME; //string colname = field.FIELD_NAME; //string sqlcoltype = field.DB_TYPE; //string msg = null; ////修改正式表字段名称或类型 //DataBaseTable t1 = null; //if (DataBase.Factory(conn).TryGetValue(tbname, out t1)) //{ // DataBaseField newf1 = new DataBaseField(colname); // if (field.IS_NULL == 0) // newf1.IsAllowNull = true; // newf1.DataType = FieldDataType.FromString(t1.DataBase.DataBaseType, sqlcoltype, true); // if (!t1.AddField(newf1, ref msg)) // { // errMsg += msg; return 0; // } //} //tbname = WFOBJECT_BLL.GetWFTempTBName(tbObj); //tbObj.WF_TB_NAME; ////修改正式表字段名称或类型 //t1 = null; //if (!string.IsNullOrEmpty(tbname) && DataBase.Factory(conn).TryGetValue(tbname, out t1)) //{ // DataBaseField newf1 = new DataBaseField(colname); // if (field.IS_NULL == 0) // newf1.IsAllowNull = true; // newf1.DataType = FieldDataType.FromString(t1.DataBase.DataBaseType, sqlcoltype, true); // if (!t1.AddField(newf1, ref msg)) // { // errMsg += msg; return 0; // } //} return(1); } catch (Exception ex) { errMsg = ex.ToString(); return(0); } }
/// <summary> /// 增加列 -废弃 /// </summary> public int AddField(TF_TB_FIELD field, ref string errMsg) { try { //TF_TABLE tbObj = BLLTable<TF_TABLE>.Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, field.TB_ID); //string tbname = tbObj.TB_NAME; //string colname = field.FIELD_NAME; //string sqlcoltype = field.DB_TYPE; //string msg = null; ////修改正式表字段名称或类型 //DataBaseTable t1 = null; //if (DataBase.Factory(conn).TryGetValue(tbname, out t1)) //{ // DataBaseField newf1 = new DataBaseField(colname); // if (field.IS_NULL == 0) // newf1.IsAllowNull = true; // newf1.DataType = FieldDataType.FromString(t1.DataBase.DataBaseType, sqlcoltype, true); // if (!t1.AddField(newf1, ref msg)) // { // errMsg += msg; return 0; // } //} //tbname = WFOBJECT_BLL.GetWFTempTBName(tbObj); //tbObj.WF_TB_NAME; ////修改正式表字段名称或类型 //t1 = null; //if (!string.IsNullOrEmpty(tbname) && DataBase.Factory(conn).TryGetValue(tbname, out t1)) //{ // DataBaseField newf1 = new DataBaseField(colname); // if (field.IS_NULL == 0) // newf1.IsAllowNull = true; // newf1.DataType = FieldDataType.FromString(t1.DataBase.DataBaseType, sqlcoltype, true); // if (!t1.AddField(newf1, ref msg)) // { // errMsg += msg; return 0; // } //} return 1; } catch (Exception ex) { errMsg = ex.ToString(); return 0; } }
public void getTemplateHtml() { string tableName = HttpUtil.GetReqStrValue("tableName"); string templateName = HttpUtil.GetReqStrValue("templateName"); if (templateName.Equals("默认")) { //默认,根据tableName取获取模板 ITableImplement itable = new ITableImplement(); itable.setConn(conn).setModule(tableName); int i = 0; string html = ""; string tr = "<tr>"; foreach(AttributeItem attr in itable.af_AttributeItemList){ if (i % 2 == 0) { html += tr+"</tr>"; tr = "<tr>"; } TF_TB_FIELD conf2 = new TF_TB_FIELD(); conf2.FIELD_NAME = attr.FieldName; TF_TB_FIELD val = BLLTable<TF_TB_FIELD>.GetRowData(conf2); if (val != null) { tr += "<td>" + val.NOTE + "</td><td>[" + tableName + "." + attr.FieldName + "]</td>"; } else { tr += "<td>" + (string.IsNullOrEmpty(attr.ZhName) ? attr.FieldName : attr.ZhName )+ "</td><td>[" + tableName + "." + attr.FieldName + "]</td>"; } i++; } Response.Write(DEFAULT_TEMPLATE_START + html + DEFAULT_TEMPLATE_END); return; } TF_CUSTOM_TEMPLATE conf = new TF_CUSTOM_TEMPLATE(); conf.TEMPLATE_NAME = templateName; conf.TABLE_NAME = tableName; conf.USER_ID = Convert.ToInt32(userBase.StaffID); conf.TYPE = 0; TF_CUSTOM_TEMPLATE valObj=BLLTable<TF_CUSTOM_TEMPLATE>.GetRowData(conf); if (valObj == null) { Response.Write(""); } else { Response.Write(valObj.TEMPLATE_HTML); } }
/// <summary> /// 根据已存在的表,将物理字段,保存入 TF_TB_FIELD 表中 /// </summary> /// <param name="tb1"></param> /// <param name="tbObj"></param> /// <returns></returns> public int SaveToTF_TB_FIELD(string TB_NAME, int TB_ID, ref string errMsg) { errMsg = ""; string tbname = TB_NAME; DataBaseTable tb1 = null; DataBaseTable tb2 = new DataBaseTable(); DataBaseTable tb3 = new DataBaseTable(); if (DataBase.Factory(conn).TryGetValue(tbname, out tb1))//如果表不存在,则新建表,带默认字段 { foreach (DataBaseField f2 in tb1.DataFields) { DataBase.Factory(conn).Master().TryGetValue("af_GROUP_WF_2014", out tb2); DataBase.Factory(conn).Master().TryGetValue("af_GROUP_WF_MX_2014", out tb3); if (!tb2.DataFields.Contains(f2.FieldName) && !tb3.DataFields.Contains(f2.FieldName)) { TF_TB_FIELD f1 = Parse(f2); f1.TB_ID = TB_ID; int count1 = 0; TF_TB_FIELD cond1 = new TF_TB_FIELD(); cond1.TB_ID = f1.TB_ID; cond1.FIELD_NAME = f1.FIELD_NAME; //count1 = BLLTable<TF_TB_FIELD>.Factory(conn).SaveOrUpdate(f1, cond1, TF_TB_FIELD.Attribute.FIELD_ID); if (BLLTable <TF_TB_FIELD> .Factory(conn).Exists(cond1)) { count1 = BLLTable <TF_TB_FIELD> .Factory(conn).Update(f1, TF_TB_FIELD.Attribute.FIELD_ID); } else { count1 = BLLTable <TF_TB_FIELD> .Factory(conn).Insert(f1, TF_TB_FIELD.Attribute.FIELD_ID); } if (count1 < 1) { Cs.Error("插入 TF_TB_FIELD 失败"); } } } return(1); } return(-1); }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new TF_TB_FIELD(); if(txtFIELD_ID.Value !="" ) condObj.Like_OR(TF_TB_FIELD.Attribute.FIELD_ID, Convert.ToInt32(txtFIELD_ID.Value)); if(txtFIELD_NAME.Value !="" ) condObj.Like_OR(TF_TB_FIELD.Attribute.FIELD_NAME, Convert.ToString(txtFIELD_NAME.Value)); if(txtFIELD_TYPE.Value !="" ) //condObj.FIELD_TYPE = Convert.ToString(txtFIELD_TYPE.Value); if(txtDB_TYPE.Value !="" ) condObj.Like_OR(TF_TB_FIELD.Attribute.DB_TYPE, Convert.ToString(txtDB_TYPE.Value)); if(txtIS_NULL.Value !="" ) condObj.Like_OR(TF_TB_FIELD.Attribute.IS_NULL, Convert.ToInt32(txtIS_NULL.Value)); if(txtNOTE.Value !="" ) condObj.Like_OR(TF_TB_FIELD.Attribute.NOTE, Convert.ToString(txtNOTE.Value)); if(txtDEFAULT_VAL.Value !="" ) condObj.Like_OR(TF_TB_FIELD.Attribute.DEFAULT_VAL, Convert.ToString(txtDEFAULT_VAL.Value)); if(txtTB_ID.Value !="" ) condObj.Like_OR(TF_TB_FIELD.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value)); if(txtCTRL_TYPE.Value !="" ) condObj.Like_OR(TF_TB_FIELD.Attribute.CTRL_TYPE, Convert.ToString(txtCTRL_TYPE.Value)); if(txtSORT_NO.Value !="" ) condObj.Like_OR(TF_TB_FIELD.Attribute.SORT_NO, Convert.ToInt32(txtSORT_NO.Value)); try { hidCondition.Value = condObj.ToJson(20); listObj = BLLTable<TF_TB_FIELD>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
private void getTemplateOptionsAndField() { string tableName = HttpUtil.GetReqStrValue("tableName"); TF_CUSTOM_TEMPLATE conf = new TF_CUSTOM_TEMPLATE(); conf.TABLE_NAME = tableName; conf.USER_ID = Convert.ToInt32(userBase.StaffID); conf.TYPE = 0; List <TF_CUSTOM_TEMPLATE> templateList = BLLTable <TF_CUSTOM_TEMPLATE> .Select(new TF_CUSTOM_TEMPLATE(), conf); string html = "<option value='-1'>--无--</option>"; if (tableName.Equals("-1")) { Response.Write("{\"html\":\"" + html + "\"}"); return; } foreach (TF_CUSTOM_TEMPLATE template in templateList) { html += "<option value='" + template.ID + "'>" + template.TEMPLATE_NAME + "</option>"; } ITableImplement itable = new ITableImplement(); itable.setConn(conn).setModule(tableName); DataBaseField[] dataBaseFields = itable.af_GetAvailableDataBaseField(); string fieldHtml = "<ul>"; foreach (DataBaseField dataBaseField in dataBaseFields) { TF_TB_FIELD conf2 = new TF_TB_FIELD(); conf2.FIELD_NAME = dataBaseField.FieldName; TF_TB_FIELD val2 = BLLTable <TF_TB_FIELD> .GetRowData(conf2); if (val2 != null) { fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + (string.IsNullOrEmpty(val2.NOTE)? dataBaseField.FieldName : val2.NOTE) + "</div></li>"; } else { fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + dataBaseField.FieldName + "</div></li>"; } } fieldHtml += "</ul>"; Response.Write("{\"html\":\"" + html + "\",\"fieldHtml\":\"" + fieldHtml + "\"}"); }
protected void aspPager_PageChanged(object sender, EventArgs e) { try { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<TF_TB_FIELD>(hidCondition.Value); } listObj = BLLTable<TF_TB_FIELD>.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_TB_FIELD>(hidCondition.Value); } List <TF_TB_FIELD> listVal = BLLTable <TF_TB_FIELD> .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_TB_FIELD(); if(txtFIELD_NAME.Value !="" ) condObj.Like(TF_TB_FIELD.Attribute.FIELD_NAME, Convert.ToString(txtFIELD_NAME.Value)); if(txtFIELD_TYPE.Value !="" ) //condObj.FIELD_TYPE = Convert.ToString(txtFIELD_TYPE.Value); if(txtIS_NULL.Value !="" ) condObj.Like(TF_TB_FIELD.Attribute.IS_NULL, Convert.ToInt32(txtIS_NULL.Value)); if(txtNOTE.Value !="" ) condObj.Like(TF_TB_FIELD.Attribute.NOTE, Convert.ToString(txtNOTE.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_TB_FIELD>(hidCondition.Value); } if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ����������������� condObj.af_PageBy(TF_TB_FIELD.Attribute.FIELD_ID, Order.Desc); listObj = BLLTable<TF_TB_FIELD>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected string checkDB(TF_TB_FIELD fdObj, TF_TABLE tbObj) { if (string.IsNullOrEmpty(tbObj.TB_NAME)) { return(null); } string ret = ""; DataBaseTable dt1; DataBaseField df1; if (!DataBaseHelper.dbMain.TryGetValue(tbObj.TB_NAME, fdObj.FIELD_NAME, out dt1, out df1)) { ret = string.Format("<font color='red'>物理字段不存在</font><a href='FIELDEdit.aspx?KeyID={0}&tree=" + DateTime.Now.Millisecond + "'>新增</a>", fdObj.FIELD_ID); } string FORM_TB = WFOBJECT_BLL.GetWFTempTBName(tbObj); if (!string.IsNullOrEmpty(FORM_TB) && !DataBaseHelper.dbMain.TryGetValue(FORM_TB, fdObj.FIELD_NAME, out dt1, out df1)) { ret = string.Format("<font color='red'>流程表中,物理字段不存在</font><a href='FIELDEdit.aspx?KeyID={0}&tree=" + DateTime.Now.Millisecond + "'>新增</a>", fdObj.FIELD_ID); } return(ret); }
protected void aspPager_PageChanged(object sender, EventArgs e) { try { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <TF_TB_FIELD>(hidCondition.Value); } if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序 { condObj.af_PageBy(TF_TB_FIELD.Attribute.FIELD_ID, Order.Desc); } listObj = BLLTable <TF_TB_FIELD> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount); repCus.DataSource = listObj; repCus.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
private void BindList(TF_TB_FIELD condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序 { condObj.af_PageBy(TF_TB_FIELD.Attribute.SORT_NO, Order.Asc); } if (Request["defaultfield"] != null) { condObj.TB_ID = 0; } else { condObj.TB_ID = tbid; } //condObj.PID = decimal.Parse(pid); listObj = BLLTable <TF_TB_FIELD> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; TF_TB_FIELD ccc = new TF_TB_FIELD(); if (Request["ntype"] == "TF_TABLE-mx") { ccc.TB_ID = -1; } else { ccc.TB_ID = 0; } listObj = BLLTable <TF_TB_FIELD> .Factory(conn).Select(valObj, ccc); repDefault.DataSource = listObj; repDefault.DataBind(); }
/// <summary> /// 根据字段名,更新或插入字段 到物理表 /// </summary> /// <param name="field"></param> /// <param name="oldbame"></param> /// <param name="errMsg"></param> /// <returns></returns> public int SaveOrUpdateField(TF_TB_FIELD field, string oldbame, ref string errMsg) { int ret = 0; if (string.IsNullOrEmpty(oldbame))//插入 { //ret = AddField(field, ref errMsg); ret = InsertOrUpdateField(field, oldbame, ref errMsg); if (ret <= 0) { errMsg = "物理数据库中新增字段失败!" + errMsg; } } else { ret = InsertOrUpdateField(field, oldbame, ref errMsg); if (ret <= 0) { errMsg = "物理数据库中编辑字段失败!" + errMsg; } } return(ret); }
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 Page_Load(object sender, EventArgs e) { ////id=1612&pid=161&no=1&name=%u8BE6%u7EC6%u5E03%u5C40&sc=0&ntype=TF_DESIGN_DETAIL&level=0111& // string id = HttpUtil.GetReqStrValue("id"); string pid = HttpUtil.GetReqStrValue("pid"); // string no = HttpUtil.GetReqStrValue("no"); // string name = HttpUtil.GetReqStrValue("name"); // string sc = HttpUtil.GetReqStrValue("sc"); // string ntype = HttpUtil.GetReqStrValue("ntype"); //DataBase db = DataBase.Factory(conn); //foreach (DataBaseTable dt1 in db.DataTables_USER) //{ // tableMap.Add(dt1.TableName,dt1.ZhName); //} TF_FORM conf1 = new TF_FORM(); conf1.FORM_ID = Convert.ToInt32(pid); TF_FORM val1 = new TF_FORM(); val1.TB_ID = 1; TF_FORM valObj1 = BLLTable <TF_FORM> .GetRowData(val1, conf1); TF_TABLE conf2 = new TF_TABLE(); conf2.TB_ID = valObj1.TB_ID; TF_TABLE val2 = new TF_TABLE(); val2.TB_NAME = ""; val2.CH_NAME = ""; val2.TB_ID = 0; TF_TABLE valObj2 = BLLTable <TF_TABLE> .GetRowData(val2, conf2); currTable = valObj2.TB_NAME; currZhTable = valObj2.CH_NAME; currTableId = valObj2.TB_ID; V_TF_TEMPLATE_TABLENAME conf = new V_TF_TEMPLATE_TABLENAME(); conf.Distinct = true; conf.USER_ID = Convert.ToInt32(userBase.StaffID); List <V_TF_TEMPLATE_TABLENAME> templateList = BLLTable <V_TF_TEMPLATE_TABLENAME> .Select(new V_TF_TEMPLATE_TABLENAME(), conf); foreach (V_TF_TEMPLATE_TABLENAME temp in templateList) { ITableImplement itable = new ITableImplement(); itable.setConn(conn).setModule(temp.TABLE_NAME); if (!tableMap.ContainsKey(temp.TABLE_NAME)) { tableMap.Add(temp.TABLE_NAME, temp.CH_NAME); } } TF_CUSTOM_TEMPLATE conf3 = new TF_CUSTOM_TEMPLATE(); conf3.TABLE_NAME = valObj2.TB_NAME; conf3.USER_ID = Convert.ToInt32(userBase.StaffID); conf3.TYPE = 0; List <TF_CUSTOM_TEMPLATE> templateList2 = BLLTable <TF_CUSTOM_TEMPLATE> .Select(new TF_CUSTOM_TEMPLATE(), conf3); html = "<option value='-1'>--无--</option>"; foreach (TF_CUSTOM_TEMPLATE template in templateList2) { if (template.STATUS == 1)//被选中 { selectedTempName = template.TEMPLATE_NAME; html += "<option value='" + template.ID + "' selected='selected'>" + template.TEMPLATE_NAME + "</option>"; } else { html += "<option value='" + template.ID + "'>" + template.TEMPLATE_NAME + "</option>"; } } ITableImplement itable2 = new ITableImplement(); itable2.setConn(conn).setModule(valObj2.TB_NAME); DataBaseField[] dataBaseFields = itable2.af_GetAvailableDataBaseField(); fieldHtml = "<ul>"; foreach (DataBaseField dataBaseField in dataBaseFields) { TF_TB_FIELD conf4 = new TF_TB_FIELD(); conf4.FIELD_NAME = dataBaseField.FieldName; TF_TB_FIELD val4 = BLLTable <TF_TB_FIELD> .GetRowData(conf4); if (val4 != null) { fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + (string.IsNullOrEmpty(val4.NOTE)? dataBaseField.FieldName : val4.NOTE) + "</div></li>"; } else { fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + dataBaseField.FieldName + "</div></li>"; } } fieldHtml += "</ul>"; // Response.Write("{\"html\":\"" + html + "\",\"fieldHtml\":\"" + fieldHtml + "\"}"); }
protected string checkDB(TF_TB_FIELD fdObj, TF_TABLE tbObj) { if (string.IsNullOrEmpty(tbObj.TB_NAME)) return null; string ret = ""; DataBaseTable dt1; DataBaseField df1; if (!DataBaseHelper.dbMain.TryGetValue(tbObj.TB_NAME, fdObj.FIELD_NAME, out dt1, out df1)) { ret = string.Format("<font color='red'>�����ֶβ�����</font><a href='FIELDEdit.aspx?KeyID={0}&tree=" + DateTime.Now.Millisecond + "'>����</a>", fdObj.FIELD_ID); } string FORM_TB = WFOBJECT_BLL.GetWFTempTBName(tbObj); if (!string.IsNullOrEmpty(FORM_TB) && !DataBaseHelper.dbMain.TryGetValue(FORM_TB, fdObj.FIELD_NAME, out dt1, out df1)) { ret = string.Format("<font color='red'>���̱��У������ֶβ�����</font><a href='FIELDEdit.aspx?KeyID={0}&tree=" + DateTime.Now.Millisecond + "'>����</a>", fdObj.FIELD_ID); } 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; //} }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "详细"; Page.Title = title; if (!IsPostBack) { try { if (!string.IsNullOrEmpty(Request["FIELD_ID"])) { valObj = BLLTable <TF_TB_FIELD> .Factory(conn).GetRowData(TF_TB_FIELD.Attribute.FIELD_ID, Request["FIELD_ID"]); if (valObj == null) { return; } txtFIELD_ID.Text = Convert.ToString(valObj.FIELD_ID);//Convert.ToInt32 txtFIELD_NAME.Text = Convert.ToString(valObj.FIELD_NAME);//Convert.ToString //txtFIELD_TYPE.Text=valObj.FIELD_TYPE.ToString(); txtDB_TYPE.Text = Convert.ToString(valObj.DB_TYPE);//Convert.ToString txtIS_NULL.Text = Convert.ToString(valObj.IS_NULL);//Convert.ToInt32 txtNOTE.Text = Convert.ToString(valObj.NOTE);//Convert.ToString txtDEFAULT_VAL.Text = Convert.ToString(valObj.DEFAULT_VAL);//Convert.ToString txtTB_ID.Text = Convert.ToString(valObj.TB_ID);//Convert.ToInt32 txtCTRL_TYPE.Text = Convert.ToString(valObj.CTRL_TYPE);//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(); } } }
private void getTemplateOptionsAndField() { string tableName = HttpUtil.GetReqStrValue("tableName"); TF_CUSTOM_TEMPLATE conf = new TF_CUSTOM_TEMPLATE(); conf.TABLE_NAME = tableName; conf.USER_ID = Convert.ToInt32(userBase.StaffID); conf.TYPE = 0; List<TF_CUSTOM_TEMPLATE> templateList = BLLTable<TF_CUSTOM_TEMPLATE>.Select(new TF_CUSTOM_TEMPLATE(), conf); string html = "<option value='-1'>--无--</option>"; if (tableName.Equals("-1")) { Response.Write("{\"html\":\"" + html + "\"}"); return; } foreach(TF_CUSTOM_TEMPLATE template in templateList){ html += "<option value='"+template.ID+"'>"+template.TEMPLATE_NAME+"</option>"; } ITableImplement itable = new ITableImplement(); itable.setConn(conn).setModule(tableName); DataBaseField[] dataBaseFields = itable.af_GetAvailableDataBaseField(); string fieldHtml = "<ul>"; foreach (DataBaseField dataBaseField in dataBaseFields) { TF_TB_FIELD conf2 = new TF_TB_FIELD(); conf2.FIELD_NAME = dataBaseField.FieldName; TF_TB_FIELD val2 = BLLTable<TF_TB_FIELD>.GetRowData(conf2); if (val2 != null) { fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + (string.IsNullOrEmpty(val2.NOTE)? dataBaseField.FieldName : val2.NOTE) + "</div></li>"; } else { fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + dataBaseField.FieldName + "</div></li>"; } } fieldHtml += "</ul>"; Response.Write("{\"html\":\"" + html + "\",\"fieldHtml\":\"" + fieldHtml + "\"}"); }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new TF_TB_FIELD(); if (txtFIELD_ID.Value != "") { condObj.Like_OR(TF_TB_FIELD.Attribute.FIELD_ID, Convert.ToInt32(txtFIELD_ID.Value)); } if (txtFIELD_NAME.Value != "") { condObj.Like_OR(TF_TB_FIELD.Attribute.FIELD_NAME, Convert.ToString(txtFIELD_NAME.Value)); } if (txtFIELD_TYPE.Value != "") { //condObj.FIELD_TYPE = Convert.ToString(txtFIELD_TYPE.Value); if (txtDB_TYPE.Value != "") { condObj.Like_OR(TF_TB_FIELD.Attribute.DB_TYPE, Convert.ToString(txtDB_TYPE.Value)); } } if (txtIS_NULL.Value != "") { condObj.Like_OR(TF_TB_FIELD.Attribute.IS_NULL, Convert.ToInt32(txtIS_NULL.Value)); } if (txtNOTE.Value != "") { condObj.Like_OR(TF_TB_FIELD.Attribute.NOTE, Convert.ToString(txtNOTE.Value)); } if (txtDEFAULT_VAL.Value != "") { condObj.Like_OR(TF_TB_FIELD.Attribute.DEFAULT_VAL, Convert.ToString(txtDEFAULT_VAL.Value)); } if (txtTB_ID.Value != "") { condObj.Like_OR(TF_TB_FIELD.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value)); } if (txtCTRL_TYPE.Value != "") { condObj.Like_OR(TF_TB_FIELD.Attribute.CTRL_TYPE, Convert.ToString(txtCTRL_TYPE.Value)); } if (txtSORT_NO.Value != "") { condObj.Like_OR(TF_TB_FIELD.Attribute.SORT_NO, Convert.ToInt32(txtSORT_NO.Value)); } try { hidCondition.Value = condObj.ToJson(20); listObj = BLLTable <TF_TB_FIELD> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
/// <summary> /// 操作物理表字段,插入或更新 /// </summary> public int InsertOrUpdateField(TF_TB_FIELD field, string oldbame, ref string errMsg) { try { if (string.IsNullOrEmpty(oldbame)) oldbame = field.FIELD_NAME; int tb_id = field.TB_ID; int FIELD_ID = field.FIELD_ID; if (FIELD_ID != 0)//修改的时候 { if (tb_id == 0) { errMsg = "物理数据库中新增字段失败!"; tb_id = Convert.ToInt32(BLLTable<TF_TB_FIELD>.Factory(conn).GetOneValue(TF_TB_FIELD.Attribute.FIELD_ID, field.FIELD_ID, TF_TB_FIELD.Attribute.TB_ID)); field.TB_ID = tb_id; } } TF_TABLE tbObj = null; if (tb_id != 0)//插入的时候 { errMsg = "物理数据库中编辑字段失败!"; tbObj = BLLTable<TF_TABLE>.Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, tb_id); } string tbname = tbObj.TB_NAME; string colname = field.FIELD_NAME; string sqlcoltype = field.DB_TYPE;//decimal(10,0) string msg = null; //修改正式表字段名称或类型 DataBaseField f1 = null; DataBaseTable t1 = null; if (DataBase.Factory(conn).TryGetValue(tbname, oldbame.Trim(), out t1, out f1)) { DataBaseField newf1 = f1.Clone(); if (field.IS_NULL == 0) newf1.IsAllowNull = true; newf1.FieldName = field.FIELD_NAME; newf1.DataType = FieldDataType.FromString(t1.DataBase.DataBaseType, sqlcoltype, true); if (!newf1.Update(f1, true, ref msg)) { errMsg += msg; return 0; } } else//如果没有存在,则新增 { DataBaseField newf1 = new DataBaseField(); if (field.IS_NULL == 0) newf1.IsAllowNull = true; newf1.FieldName = field.FIELD_NAME; newf1.DataType = FieldDataType.FromString(t1.DataBase.DataBaseType, sqlcoltype, true); if (!t1.AddField(newf1, ref msg)) { errMsg += msg; return 0; } if (!DataBase.Factory(conn).TryGetValue(tbname, newf1.FieldName, out t1, out f1)) { errMsg += "未存在"; } } #region//流程对应流程的临时表对应的字段信息 tbname = WFOBJECT_BLL.GetWFTempTBName(tbObj); //tbObj.WF_TB_NAME; //修改正式表字段名称或类型 f1 = null; t1 = null; //CHG START 为空条件判断有误 jin-shenjian 2013/10/12 //if (!string.IsNullOrEmpty(tbname) && DataBase.Factory(conn).TryGetValue(tbname, oldbame, out t1, out f1)) if (!string.IsNullOrEmpty(tbname)) { if (DataBase.Factory(conn).TryGetValue(tbname, oldbame, out t1, out f1)) //CHG END 为空条件判断有误 jin-shenjian 2013/10/12 { DataBaseField newf1 = f1.Clone(); if (field.IS_NULL == 0) newf1.IsAllowNull = true; newf1.FieldName = field.FIELD_NAME; newf1.DataType = FieldDataType.FromString(t1.DataBase.DataBaseType, sqlcoltype, true); if (!newf1.Update(f1, true, ref msg)) { errMsg += msg; return 0; } } else//如果没有存在,则新增 { DataBaseField newf1 = new DataBaseField(); if (field.IS_NULL == 0) newf1.IsAllowNull = true; newf1.FieldName = field.FIELD_NAME; newf1.DataType = FieldDataType.FromString(t1.DataBase.DataBaseType, sqlcoltype, true); if (!t1.AddField(newf1, ref msg)) { errMsg += msg; return 0; } if (!DataBase.Factory(conn).TryGetValue(tbname, newf1.FieldName, out t1, out f1)) { errMsg += "未存在"; } } } #endregion return 1; } catch (Exception ex) { errMsg = ex.ToString(); return 0; } }
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; //} }
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; //} } }
/// <summary> /// TF_FORM 从配置中获得表单布局 /// </summary> /// <param name="conn"></param> /// <param name="cond"></param> /// <returns></returns> public bool Parse(TF_TABLE cond, out ITableImplement valObj, out ITableImplement condObj, out List<Relation> relationList, out List<ITableImplement> otherValueList, out List<ITableImplement> condList, ref string msg) { valObj = new ITableImplement(); condObj = new ITableImplement(); //载入关系 otherValueList = new List<ITableImplement>(); condList = new List<ITableImplement>(); relationList = new List<Relation>(); msg = "条件不存在"; if (string.IsNullOrEmpty(cond.TB_NAME)) return false; DataBaseTable tb1; List<DataBaseField> listf1 = new List<DataBaseField>(); List<DataBaseTable> listTb1 = new List<DataBaseTable>(); bool ret = true; tb1 = null; //TF_TABLE val = BLLTable<TF_TABLE>.Factory(conn).GetRowData(new TF_TABLE(), cond); TF_TB_FIELD val1 = new TF_TB_FIELD(); TF_F_COLUMN val2 = new TF_F_COLUMN(); TF_TABLE val3 = new TF_TABLE(); TF_TB_FIELD cond1 = new TF_TB_FIELD(); TF_F_COLUMN cond2 = new TF_F_COLUMN(); TF_FORM cond3 = new TF_FORM(); List<ITableImplement> otherValueList1 = new List<ITableImplement>(); List<ITableImplement> condList1 = new List<ITableImplement>(); otherValueList1.Add(val2); otherValueList1.Add(val3); condList1.Add(cond); List<Relation> relationList1 = new List<Relation>(); relationList1.Add(RelationFactory.TF_TABLE_TF_FORM); relationList1.Add(RelationFactory.TF_TABLE_TF_TB_FIELD); relationList1.Add(RelationFactory.TF_TB_FIELD_TF_F_COLUMN); int pageSize = 100; int pageIndex = 1; int recount = -1; string cachekey = null; List<TF_TB_FIELD> list1 = BLLTable<TF_TB_FIELD>.Factory(conn).SelectByPage(val1, relationList1, otherValueList1, condList1, pageSize, pageIndex, ref recount, out cachekey); if (list1.Count == 0) { DataBaseTable dt1 = null; dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[cond.TB_NAME]; msg = cond.TB_NAME + " 数据表不存在"; if (dt1 == null) { ret = false; ConsoleService.Warn(msg); } return ret; } if (list1.Count > 90) { msg = "条件错误,所配置的字段记录超过90"; return false; } //生成布局模版用 tb1 = new DataBaseTable(); foreach (TF_TB_FIELD item in list1) { string tbName = Convert.ToString(item.GetValue(TF_TABLE.Attribute.TB_NAME)).ToLower(); #region 表操作 DataBaseTable dt1 = null; dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[tbName]; msg = tbName + " 数据表不存在"; ret = false; if (dt1 == null) { ConsoleService.Warn(msg); return ret; } tb1 = dt1; listTb1.Add(dt1); //是否显示 object obj1 = null; object obj2 = null; object obj3 = null; if (item.TryGetValue(TF_FORM.Attribute.FORM_ID, out obj1)) { dt1.IsVisable = true; } #endregion string fieldName = item.FIELD_NAME.ToLower(); #region 列操作 DataBaseField f1 = null; msg = string.Format("数据表{0},数据字段{1}不存在", tbName, fieldName); if (!dt1.DataFields.TryGetValue(fieldName, out f1)) { ret = false; ConsoleService.Warn(msg); continue; } //是否显示 obj1 = null; obj2 = null; obj3 = null; if (item.TryGetValue(TF_F_COLUMN.Attribute.COLUMN_ID, out obj1) && item.TryGetValue(TF_F_COLUMN.Attribute.SHOW_NAME, out obj2) && item.TryGetValue(TF_F_COLUMN.Attribute.CTRL_TYPE, out obj3)) { //f1.IsVisable = true; } #endregion listf1.Add(f1); } //取值对象 valObj = ITableImplement.Factory(tb1); //其他取值对象 foreach (DataBaseTable tb2 in listTb1) { if (tb2.TableName == tb1.TableName) continue; otherValueList.Add(ITableImplement.Factory(tb2)); } //关系呢 return ret; }
public TF_TB_FIELD Parse(DataBaseField f2) { int sortInt = 0; TF_TB_FIELD f1 = new TF_TB_FIELD(); f1.FIELD_NAME = f2.FieldName; f1.NOTE = f2.Desc.ZhName; f1.DEFAULT_VAL = f2.DefaultValue; //f1.TB_ID; sortInt++; f1.SORT_NO = sortInt; f1.IS_KEY = (f2.IsKeyID) ? 1 : 0; f1.IS_AUTONUM = (f2.IsAutoIncrease) ? 1 : 0; f1.IS_NULL = (f2.IsAllowNull) ? 1 : 0; f1._CREATED = 1; switch (f2.Desc.Switch_CtrlType) { //case BaseCtrlType.SelectDrop: default: f1._CTRL_TYPE = f2.Desc.Switch_CtrlType == BaseCtrlType.UnKnown ? BaseCtrlType.InputString.ToString() : f2.Desc.Switch_CtrlType.ToString(); //f1._DB_TYPE = f2.DataType.TypeNameString; f1._DB_TYPE = f2.DataType.GetParamSql();//char(8), decaml(8,0) f1.TYPE_CODE = StringHelper.HeadUpper(f2.DataType.NetType); f1.TYPE_ID = 0; break; } return f1; }
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> /// 根据字段名,更新或插入字段 到物理表 /// </summary> /// <param name="field"></param> /// <param name="oldbame"></param> /// <param name="errMsg"></param> /// <returns></returns> public int SaveOrUpdateField(TF_TB_FIELD field, string oldbame, ref string errMsg) { int ret = 0; if (string.IsNullOrEmpty(oldbame))//插入 { //ret = AddField(field, ref errMsg); ret = InsertOrUpdateField(field, oldbame, ref errMsg); if (ret <= 0) errMsg = "物理数据库中新增字段失败!" + errMsg; } else { ret = InsertOrUpdateField(field, oldbame, ref errMsg); if (ret <= 0) errMsg = "物理数据库中编辑字段失败!" + errMsg; } return ret; }
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 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 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> /// //自身为树,可以按照类型进行 树节点外观区别 /// //子相关对象 /// </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 (!string.IsNullOrEmpty(Request["FIELD_ID"])) { keyid = Request["FIELD_ID"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (Request["tree"] != null) { if (Request["edit"] != null) { keyid = Request["id"]; tbid = Request["pid"]; } else { tbid = Request["id"]; } } if (!IsPostBack) { if (keyid != "") { valObj = BLLTable<TF_TB_FIELD>.Factory(conn).GetRowData(TF_TB_FIELD.Attribute.FIELD_ID, keyid); //Response.Write(valObj.TYPE_CODE); } List<TF_FIELD_DBTYPE> lstDBType = BLLTable<TF_FIELD_DBTYPE>.Factory(conn).Select(new TF_FIELD_DBTYPE(),new TF_FIELD_DBTYPE()); Dictionary<string, List<TF_CTRL_TYPE>> json1 = new Dictionary<string, List<TF_CTRL_TYPE>>(); for (int i = 0; i < lstDBType.Count; i++) { ListItem li = new ListItem(lstDBType[i].TYPE_NAME, lstDBType[i].TYPE_CODE); if (lstDBType[i].TYPE_CODE == null) continue; if (valObj != null && valObj.TYPE_CODE != null && lstDBType[i].TYPE_CODE == valObj.TYPE_CODE) { li.Selected = true; } txtFIELD_TYPE.Items.Add(li); json1.Add(lstDBType[i].TYPE_CODE, new List<TF_CTRL_TYPE>()); if (lstDBType[i].CTRL_TYPES == null) continue; TF_CTRL_TYPE ccc = new TF_CTRL_TYPE(); ccc.In(TF_CTRL_TYPE.Attribute.CTRL_TYPE, lstDBType[i].CTRL_TYPES); List<TF_CTRL_TYPE> lstCtrl = BLLTable<TF_CTRL_TYPE>.Factory(conn).Select(new TF_CTRL_TYPE(), ccc); json1[lstDBType[i].TYPE_CODE].AddRange(lstCtrl); } StringBuilder sb = new StringBuilder("({"); foreach (string key1 in json1.Keys) { if (sb.Length > 2) { sb.Append(","); } sb.Append("'o_" + key1 + "':["); for (int a = 0; a < json1[key1].Count; a++) { if (a > 0) { sb.Append(","); } sb.Append("{name:'" + json1[key1][a].CTRL_NAME + "',val:'" + json1[key1][a].CTRL_TYPE + "'}"); } sb.Append("]"); } sb.Append("})"); hidCtrlTypeData.Value = sb.ToString(); //txtFIELD_TYPE.Items.AddRange(FormHelper.GetListItem(TF_TB_FIELD.Attribute.FIELD_TYPE)); this.txtFIELD_ID.Disabled = true; this.txtFIELD_ID.Attributes["class"] = "dis"; try { ViewState["OLDNAME"] = ""; if (keyid != "") { if(valObj==null) return ; txtFIELD_ID.Value = Convert.ToString(valObj.FIELD_ID);//Convert.ToInt32 ViewState["OLDNAME"] = valObj.FIELD_NAME; txtFIELD_NAME.Value = valObj.FIELD_NAME.Trim(); txtFIELD_TYPE.Value=valObj.TYPE_ID.ToString(); //txtDB_TYPE.Value = Convert.ToString(valObj.DB_TYPE);//Convert.ToString txtIS_NULL.Checked = valObj.IS_NULL == 1; txtNOTE.Value = Convert.ToString(valObj.NOTE);//Convert.ToString txtDEFAULT_VAL.Value = Convert.ToString(valObj.DEFAULT_VAL);//Convert.ToString //txtTB_ID.Value = Convert.ToString(valObj.TB_ID);//Convert.ToInt32 txtCTRL_TYPE.Value = valObj.CTRL_TYPE;//Convert.ToString txtSORT_NO.Value = Convert.ToString(valObj.SORT_NO);//Convert.ToInt32 } } catch (Exception ex) { litWarn.Text = ex.Message; } } }
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(); }
/// <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 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; //} } }
private void BindList(TF_TB_FIELD condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ����������������� condObj.af_PageBy(TF_TB_FIELD.Attribute.SORT_NO, Order.Asc); if (Request["defaultfield"] != null) { condObj.TB_ID = 0; } else { condObj.TB_ID = tbid; } //condObj.PID = decimal.Parse(pid); listObj = BLLTable<TF_TB_FIELD>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; TF_TB_FIELD ccc = new TF_TB_FIELD(); if (Request["ntype"] == "TF_TABLE-mx") { ccc.TB_ID = -1; } else { ccc.TB_ID = 0; } listObj = BLLTable<TF_TB_FIELD>.Factory(conn).Select(valObj, ccc); repDefault.DataSource = listObj; repDefault.DataBind(); }
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 Page_Load(object sender, EventArgs e) { #region//Ĭ�����ص��� //hideTableColumnList = new List<AttributeItem>(); //hideTableColumnList.Add(TF_TB_FIELD.Attribute.EXP1); //hideTableColumnList.Add(TF_TB_FIELD.Attribute.EXP2); //hideTableColumnList.Add(TF_TB_FIELD.Attribute.EXP3); //valObj.LoadAllAttributes(true);//��ʱ�Ӵ˴��룬�Ժ��ܸ��½�����Ҫ //valObj.Remove(hideTableColumnList); //hideFindColumnList = new List<AttributeItem>(); //hideFindColumnList.Add(TF_TB_FIELD.Attribute.EXP1); //hideFindColumnList.Add(TF_TB_FIELD.Attribute.EXP2); //hideFindColumnList.Add(TF_TB_FIELD.Attribute.EXP3); #endregion condObj.OrderBy(TF_TB_FIELD.Attribute.FIELD_ID, Order.Desc); if (!IsPostBack) { btnFind.Text = LanguageService.GetLanguageString("btnFind", "��ѯ"); aspPager.PageSize = 10; aspPager.CurrentPageIndex = 1; if (!string.IsNullOrEmpty(Request["ids"])) { TF_TB_FIELD roleOld = new TF_TB_FIELD(); roleOld.Where(TF_TB_FIELD.Attribute.FIELD_ID, Request["ids"].ToString()); listObj = BLLTable<TF_TB_FIELD>.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].FIELD_ID + "',Name:'" + listObj[i].FIELD_ID + "'}";//�����Name������ʾ���б��У��������ض��塣 hidInitIDS.Value += listObj[i].FIELD_ID; } } try { listObj = BLLTable<TF_TB_FIELD>.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> public int InsertOrUpdateField(TF_TB_FIELD field, string oldbame, ref string errMsg) { try { if (string.IsNullOrEmpty(oldbame)) { oldbame = field.FIELD_NAME; } int tb_id = field.TB_ID; int FIELD_ID = field.FIELD_ID; if (FIELD_ID != 0)//修改的时候 { if (tb_id == 0) { errMsg = "物理数据库中新增字段失败!"; tb_id = Convert.ToInt32(BLLTable <TF_TB_FIELD> .Factory(conn).GetOneValue(TF_TB_FIELD.Attribute.FIELD_ID, field.FIELD_ID, TF_TB_FIELD.Attribute.TB_ID)); field.TB_ID = tb_id; } } TF_TABLE tbObj = null; if (tb_id != 0)//插入的时候 { errMsg = "物理数据库中编辑字段失败!"; tbObj = BLLTable <TF_TABLE> .Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, tb_id); } string tbname = tbObj.TB_NAME; string colname = field.FIELD_NAME; string sqlcoltype = field.DB_TYPE;//decimal(10,0) string msg = null; //修改正式表字段名称或类型 DataBaseField f1 = null; DataBaseTable t1 = null; if (DataBase.Factory(conn).TryGetValue(tbname, oldbame.Trim(), out t1, out f1)) { DataBaseField newf1 = f1.Clone(); if (field.IS_NULL == 0) { newf1.IsAllowNull = true; } newf1.FieldName = field.FIELD_NAME; newf1.DataType = FieldDataType.FromString(t1.DataBase.DataBaseType, sqlcoltype, true); if (!newf1.Update(f1, true, ref msg)) { errMsg += msg; return(0); } } else//如果没有存在,则新增 { DataBaseField newf1 = new DataBaseField(); if (field.IS_NULL == 0) { newf1.IsAllowNull = true; } newf1.FieldName = field.FIELD_NAME; newf1.DataType = FieldDataType.FromString(t1.DataBase.DataBaseType, sqlcoltype, true); if (!t1.AddField(newf1, ref msg)) { errMsg += msg; return(0); } if (!DataBase.Factory(conn).TryGetValue(tbname, newf1.FieldName, out t1, out f1)) { errMsg += "未存在"; } } #region //流程对应流程的临时表对应的字段信息 tbname = WFOBJECT_BLL.GetWFTempTBName(tbObj); //tbObj.WF_TB_NAME; //修改正式表字段名称或类型 f1 = null; t1 = null; //CHG START 为空条件判断有误 jin-shenjian 2013/10/12 //if (!string.IsNullOrEmpty(tbname) && DataBase.Factory(conn).TryGetValue(tbname, oldbame, out t1, out f1)) if (!string.IsNullOrEmpty(tbname)) { if (DataBase.Factory(conn).TryGetValue(tbname, oldbame, out t1, out f1)) //CHG END 为空条件判断有误 jin-shenjian 2013/10/12 { DataBaseField newf1 = f1.Clone(); if (field.IS_NULL == 0) { newf1.IsAllowNull = true; } newf1.FieldName = field.FIELD_NAME; newf1.DataType = FieldDataType.FromString(t1.DataBase.DataBaseType, sqlcoltype, true); if (!newf1.Update(f1, true, ref msg)) { errMsg += msg; return(0); } } else//如果没有存在,则新增 { DataBaseField newf1 = new DataBaseField(); if (field.IS_NULL == 0) { newf1.IsAllowNull = true; } newf1.FieldName = field.FIELD_NAME; newf1.DataType = FieldDataType.FromString(t1.DataBase.DataBaseType, sqlcoltype, true); if (!t1.AddField(newf1, ref msg)) { errMsg += msg; return(0); } if (!DataBase.Factory(conn).TryGetValue(tbname, newf1.FieldName, out t1, out f1)) { errMsg += "未存在"; } } } #endregion return(1); } catch (Exception ex) { errMsg = ex.ToString(); return(0); } }
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; } }
/// <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 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; //} }
/// <summary> /// 根据已存在的表,将物理字段,保存入 TF_TB_FIELD 表中 /// </summary> /// <param name="tb1"></param> /// <param name="tbObj"></param> /// <returns></returns> public int SaveToTF_TB_FIELD(string TB_NAME, int TB_ID, ref string errMsg) { errMsg = ""; string tbname = TB_NAME; DataBaseTable tb1 = null; DataBaseTable tb2 = new DataBaseTable(); DataBaseTable tb3 = new DataBaseTable(); if (DataBase.Factory(conn).TryGetValue(tbname, out tb1))//如果表不存在,则新建表,带默认字段 { foreach (DataBaseField f2 in tb1.DataFields) { DataBase.Factory(conn).Master().TryGetValue("af_GROUP_WF_2014", out tb2); DataBase.Factory(conn).Master().TryGetValue("af_GROUP_WF_MX_2014", out tb3); if (!tb2.DataFields.Contains(f2.FieldName) && !tb3.DataFields.Contains(f2.FieldName)) { TF_TB_FIELD f1 = Parse(f2); f1.TB_ID = TB_ID; int count1 = 0; TF_TB_FIELD cond1 = new TF_TB_FIELD(); cond1.TB_ID = f1.TB_ID; cond1.FIELD_NAME = f1.FIELD_NAME; //count1 = BLLTable<TF_TB_FIELD>.Factory(conn).SaveOrUpdate(f1, cond1, TF_TB_FIELD.Attribute.FIELD_ID); if (BLLTable<TF_TB_FIELD>.Factory(conn).Exists(cond1)) { count1 = BLLTable<TF_TB_FIELD>.Factory(conn).Update(f1, TF_TB_FIELD.Attribute.FIELD_ID); } else { count1 = BLLTable<TF_TB_FIELD>.Factory(conn).Insert(f1, TF_TB_FIELD.Attribute.FIELD_ID); } if (count1 < 1) { Cs.Error("插入 TF_TB_FIELD 失败"); } } } return 1; } return -1; }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "编辑"; Page.Title = title; if (!string.IsNullOrEmpty(Request["FIELD_ID"])) { keyid = Request["FIELD_ID"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (Request["tree"] != null) { if (Request["edit"] != null) { keyid = Request["id"]; tbid = Request["pid"]; } else { tbid = Request["id"]; } } if (!IsPostBack) { if (keyid != "") { valObj = BLLTable <TF_TB_FIELD> .Factory(conn).GetRowData(TF_TB_FIELD.Attribute.FIELD_ID, keyid); //Response.Write(valObj.TYPE_CODE); } List <TF_FIELD_DBTYPE> lstDBType = BLLTable <TF_FIELD_DBTYPE> .Factory(conn).Select(new TF_FIELD_DBTYPE(), new TF_FIELD_DBTYPE()); Dictionary <string, List <TF_CTRL_TYPE> > json1 = new Dictionary <string, List <TF_CTRL_TYPE> >(); for (int i = 0; i < lstDBType.Count; i++) { ListItem li = new ListItem(lstDBType[i].TYPE_NAME, lstDBType[i].TYPE_CODE); if (lstDBType[i].TYPE_CODE == null) { continue; } if (valObj != null && valObj.TYPE_CODE != null && lstDBType[i].TYPE_CODE == valObj.TYPE_CODE) { li.Selected = true; } txtFIELD_TYPE.Items.Add(li); json1.Add(lstDBType[i].TYPE_CODE, new List <TF_CTRL_TYPE>()); if (lstDBType[i].CTRL_TYPES == null) { continue; } TF_CTRL_TYPE ccc = new TF_CTRL_TYPE(); ccc.In(TF_CTRL_TYPE.Attribute.CTRL_TYPE, lstDBType[i].CTRL_TYPES); List <TF_CTRL_TYPE> lstCtrl = BLLTable <TF_CTRL_TYPE> .Factory(conn).Select(new TF_CTRL_TYPE(), ccc); json1[lstDBType[i].TYPE_CODE].AddRange(lstCtrl); } StringBuilder sb = new StringBuilder("({"); foreach (string key1 in json1.Keys) { if (sb.Length > 2) { sb.Append(","); } sb.Append("'o_" + key1 + "':["); for (int a = 0; a < json1[key1].Count; a++) { if (a > 0) { sb.Append(","); } sb.Append("{name:'" + json1[key1][a].CTRL_NAME + "',val:'" + json1[key1][a].CTRL_TYPE + "'}"); } sb.Append("]"); } sb.Append("})"); hidCtrlTypeData.Value = sb.ToString(); //txtFIELD_TYPE.Items.AddRange(FormHelper.GetListItem(TF_TB_FIELD.Attribute.FIELD_TYPE)); this.txtFIELD_ID.Disabled = true; this.txtFIELD_ID.Attributes["class"] = "dis"; try { ViewState["OLDNAME"] = ""; if (keyid != "") { if (valObj == null) { return; } txtFIELD_ID.Value = Convert.ToString(valObj.FIELD_ID);//Convert.ToInt32 ViewState["OLDNAME"] = valObj.FIELD_NAME; txtFIELD_NAME.Value = valObj.FIELD_NAME.Trim(); txtFIELD_TYPE.Value = valObj.TYPE_ID.ToString(); //txtDB_TYPE.Value = Convert.ToString(valObj.DB_TYPE);//Convert.ToString txtIS_NULL.Checked = valObj.IS_NULL == 1; txtNOTE.Value = Convert.ToString(valObj.NOTE); //Convert.ToString txtDEFAULT_VAL.Value = Convert.ToString(valObj.DEFAULT_VAL); //Convert.ToString //txtTB_ID.Value = Convert.ToString(valObj.TB_ID);//Convert.ToInt32 txtCTRL_TYPE.Value = valObj.CTRL_TYPE; //Convert.ToString txtSORT_NO.Value = Convert.ToString(valObj.SORT_NO); //Convert.ToInt32 } } 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 = "该表字段已经被某栏目使用。"; 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 { 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 Page_Load(object sender, EventArgs e) { ////id=1612&pid=161&no=1&name=%u8BE6%u7EC6%u5E03%u5C40&sc=0&ntype=TF_DESIGN_DETAIL&level=0111& // string id = HttpUtil.GetReqStrValue("id"); string pid = HttpUtil.GetReqStrValue("pid"); // string no = HttpUtil.GetReqStrValue("no"); // string name = HttpUtil.GetReqStrValue("name"); // string sc = HttpUtil.GetReqStrValue("sc"); // string ntype = HttpUtil.GetReqStrValue("ntype"); //DataBase db = DataBase.Factory(conn); //foreach (DataBaseTable dt1 in db.DataTables_USER) //{ // tableMap.Add(dt1.TableName,dt1.ZhName); //} TF_FORM conf1 = new TF_FORM(); conf1.FORM_ID = Convert.ToInt32(pid); TF_FORM val1 = new TF_FORM(); val1.TB_ID = 1; TF_FORM valObj1 = BLLTable<TF_FORM>.GetRowData(val1, conf1); TF_TABLE conf2 = new TF_TABLE(); conf2.TB_ID = valObj1.TB_ID; TF_TABLE val2 = new TF_TABLE(); val2.TB_NAME = ""; val2.CH_NAME = ""; val2.TB_ID = 0; TF_TABLE valObj2 = BLLTable<TF_TABLE>.GetRowData(val2, conf2); currTable = valObj2.TB_NAME; currZhTable = valObj2.CH_NAME; currTableId = valObj2.TB_ID; V_TF_TEMPLATE_TABLENAME conf = new V_TF_TEMPLATE_TABLENAME(); conf.Distinct = true; conf.USER_ID = Convert.ToInt32(userBase.StaffID); List<V_TF_TEMPLATE_TABLENAME> templateList = BLLTable<V_TF_TEMPLATE_TABLENAME>.Select(new V_TF_TEMPLATE_TABLENAME(), conf); foreach (V_TF_TEMPLATE_TABLENAME temp in templateList) { ITableImplement itable = new ITableImplement(); itable.setConn(conn).setModule(temp.TABLE_NAME); if (!tableMap.ContainsKey(temp.TABLE_NAME)) { tableMap.Add(temp.TABLE_NAME, temp.CH_NAME); } } TF_CUSTOM_TEMPLATE conf3 = new TF_CUSTOM_TEMPLATE(); conf3.TABLE_NAME = valObj2.TB_NAME; conf3.USER_ID = Convert.ToInt32(userBase.StaffID); conf3.TYPE = 0; List<TF_CUSTOM_TEMPLATE> templateList2 = BLLTable<TF_CUSTOM_TEMPLATE>.Select(new TF_CUSTOM_TEMPLATE(), conf3); html = "<option value='-1'>--无--</option>"; foreach (TF_CUSTOM_TEMPLATE template in templateList2) { if (template.STATUS == 1)//被选中 { selectedTempName = template.TEMPLATE_NAME; html += "<option value='" + template.ID + "' selected='selected'>" + template.TEMPLATE_NAME + "</option>"; } else { html += "<option value='" + template.ID + "'>" + template.TEMPLATE_NAME + "</option>"; } } ITableImplement itable2 = new ITableImplement(); itable2.setConn(conn).setModule(valObj2.TB_NAME); DataBaseField[] dataBaseFields = itable2.af_GetAvailableDataBaseField(); fieldHtml = "<ul>"; foreach (DataBaseField dataBaseField in dataBaseFields) { TF_TB_FIELD conf4 = new TF_TB_FIELD(); conf4.FIELD_NAME = dataBaseField.FieldName; TF_TB_FIELD val4 = BLLTable<TF_TB_FIELD>.GetRowData(conf4); if (val4 != null) { fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + (string.IsNullOrEmpty(val4.NOTE)? dataBaseField.FieldName : val4.NOTE) + "</div></li>"; } else { fieldHtml += "<li><div fieldname='" + dataBaseField.FieldName + "'>" + dataBaseField.FieldName + "</div></li>"; } } fieldHtml += "</ul>"; // Response.Write("{\"html\":\"" + html + "\",\"fieldHtml\":\"" + fieldHtml + "\"}"); }