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