protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new TF_FORM();
if(txtFORM_ID.Value !="" )
condObj.Like(TF_FORM.Attribute.FORM_ID, Convert.ToInt32(txtFORM_ID.Value));
if(txtF_NAME.Value !="" )
condObj.Like(TF_FORM.Attribute.F_NAME, Convert.ToString(txtF_NAME.Value));
if(txtTB_ID.Value !="" )
condObj.Like(TF_FORM.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value));
if(txtTPL_EDIT.Value !="" )
condObj.Like(TF_FORM.Attribute.TPL_EDIT, Convert.ToString(txtTPL_EDIT.Value));
if(txtTPL_SHOW.Value !="" )
condObj.Like(TF_FORM.Attribute.TPL_SHOW, Convert.ToString(txtTPL_SHOW.Value));
if(txtTPL_PRINT.Value !="" )
condObj.Like(TF_FORM.Attribute.TPL_PRINT, Convert.ToString(txtTPL_PRINT.Value));
if(txtTPL_LIST.Value !="" )
condObj.Like(TF_FORM.Attribute.TPL_LIST, Convert.ToString(txtTPL_LIST.Value));
if(txtTB_IDS.Value !="" )
condObj.Like(TF_FORM.Attribute.TB_IDS, Convert.ToString(txtTB_IDS.Value));
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
protected void Page_Load(object sender, EventArgs e)
{
valObj.OrderBy(TF_TABLE.Attribute.SORT_NO, Order.Asc);
if (Request["PID"] != null)
{
int pid = int.Parse(Request["PID"]);
TF_FORM formObj = BLLTable <TF_FORM> .Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, pid);
if (formObj != null)
{
m_tbid = formObj.TB_ID;
}
}
condObj.M_TB_ID = m_tbid;
title = valObj._ZhName + "选择";
Page.Title = title;
if (!IsPostBack)
{
aspPager.CurrentPageIndex = 1;
aspPager.PageSize = 20;
try
{
listObj = BLLTable <TF_TABLE> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repCus.DataSource = listObj;
repCus.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
aspPager.RecordCount = recount;
}
}
protected void btnFind_Click(object sender, EventArgs e)
{
try
{
condObj = new TF_FORM();
if (txtF_NAME.Value != "")
{
condObj.Like(TF_FORM.Attribute.F_NAME, Convert.ToString(txtF_NAME.Value));
}
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
{
condObj.af_PageBy(TF_FORM.Attribute.FORM_ID, Order.Desc);
}
listObj = BLLTable <TF_FORM> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repCus.DataSource = listObj;
repCus.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
aspPager.RecordCount = recount;
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "编辑";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["FORM_ID"]))
{
keyid = Request["FORM_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!string.IsNullOrEmpty(Request["edit"]))
{
keyid = Request["id"];
}
else
{
pid = int.Parse(Request["id"]);
}
if (!IsPostBack)
{
try
{
if (keyid != "")
{
valObj = BLLTable <TF_FORM> .Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, keyid);
if (valObj == null)
{
return;
}
txtFORM_ID.Value = Convert.ToString(valObj.FORM_ID); //Convert.ToInt32
txtF_NAME.Value = Convert.ToString(valObj.F_NAME); //Convert.ToString
hidTB_ID.Value = Convert.ToString(valObj.TB_ID); //Convert.ToInt32
txtTB_ID.Value = BLLTable <TF_TABLE> .Factory(conn).GetOneValue(TF_TABLE.Attribute.TB_ID, valObj.TB_ID, TF_TABLE.Attribute.CH_NAME);
txtTPL_EDIT.Value = Convert.ToString(valObj.TPL_EDIT); //Convert.ToString
txtTPL_SHOW.Value = Convert.ToString(valObj.TPL_SHOW); //Convert.ToString
txtTPL_PRINT.Value = Convert.ToString(valObj.TPL_PRINT); //Convert.ToString
txtTPL_LIST.Value = Convert.ToString(valObj.TPL_LIST); //Convert.ToString
//txtTB_IDS.Value = Convert.ToString(valObj.TB_IDS);//Convert.ToString
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<TF_FORM>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <TF_FORM>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void btnSetPageSize_Click(object sender, EventArgs e)
{
aspPager.PageSize = int.Parse(txtPageSize.Value);
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <TF_FORM>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new TF_FORM();
if (txtFORM_ID.Value != "")
{
condObj.Like(TF_FORM.Attribute.FORM_ID, Convert.ToInt32(txtFORM_ID.Value));
}
if (txtF_NAME.Value != "")
{
condObj.Like(TF_FORM.Attribute.F_NAME, Convert.ToString(txtF_NAME.Value));
}
if (txtTB_ID.Value != "")
{
condObj.Like(TF_FORM.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value));
}
if (txtTPL_EDIT.Value != "")
{
condObj.Like(TF_FORM.Attribute.TPL_EDIT, Convert.ToString(txtTPL_EDIT.Value));
}
if (txtTPL_SHOW.Value != "")
{
condObj.Like(TF_FORM.Attribute.TPL_SHOW, Convert.ToString(txtTPL_SHOW.Value));
}
if (txtTPL_PRINT.Value != "")
{
condObj.Like(TF_FORM.Attribute.TPL_PRINT, Convert.ToString(txtTPL_PRINT.Value));
}
if (txtTPL_LIST.Value != "")
{
condObj.Like(TF_FORM.Attribute.TPL_LIST, Convert.ToString(txtTPL_LIST.Value));
}
if (txtTB_IDS.Value != "")
{
condObj.Like(TF_FORM.Attribute.TB_IDS, Convert.ToString(txtTB_IDS.Value));
}
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
protected void btnSetPageSize_Click(object sender, EventArgs e)
{
aspPager.PageSize = int.Parse(txtPageSize.Value);
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<TF_FORM>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "��ϸ";
Page.Title = title;
if (!IsPostBack)
{
try
{
if (!string.IsNullOrEmpty(Request["FORM_ID"]))
{
valObj = BLLTable<TF_FORM>.Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, Request["FORM_ID"]);
if(valObj==null) return ;
txtFORM_ID.Text = Convert.ToString(valObj.FORM_ID);//Convert.ToInt32
txtF_NAME.Text = Convert.ToString(valObj.F_NAME);//Convert.ToString
txtTB_ID.Text = Convert.ToString(valObj.TB_ID);//Convert.ToInt32
txtTPL_EDIT.Text = Convert.ToString(valObj.TPL_EDIT);//Convert.ToString
txtTPL_SHOW.Text = Convert.ToString(valObj.TPL_SHOW);//Convert.ToString
txtTPL_PRINT.Text = Convert.ToString(valObj.TPL_PRINT);//Convert.ToString
txtTPL_LIST.Text = Convert.ToString(valObj.TPL_LIST);//Convert.ToString
txtTB_IDS.Text = Convert.ToString(valObj.TB_IDS);//Convert.ToString
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
if (Request["ajax"] != null)
{
Response.Clear();
Response.Buffer = true;
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//�����������������
//Response.ContentType = "html/text";
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
divC.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region//默认隐藏的列
//hideTableColumnList = new List<AttributeItem>();
//hideTableColumnList.Add(TF_FORM.Attribute.EXP1);
//hideTableColumnList.Add(TF_FORM.Attribute.EXP2);
//hideTableColumnList.Add(TF_FORM.Attribute.EXP3);
//valObj.LoadAllAttributes(true);//暂时加此代码，以后框架更新将不需要
//valObj.Remove(hideTableColumnList);
//hideFindColumnList = new List<AttributeItem>();
//hideFindColumnList.Add(TF_FORM.Attribute.EXP1);
//hideFindColumnList.Add(TF_FORM.Attribute.EXP2);
//hideFindColumnList.Add(TF_FORM.Attribute.EXP3);
#endregion
condObj.OrderBy(TF_FORM.Attribute.FORM_ID, Order.Desc);
if (!IsPostBack)
{
btnFind.Text = LanguageService.GetLanguageString("btnFind", "查询");
aspPager.PageSize = 10;
aspPager.CurrentPageIndex = 1;
if (!string.IsNullOrEmpty(Request["ids"]))
{
TF_FORM roleOld = new TF_FORM();
roleOld.Where(TF_FORM.Attribute.FORM_ID, Request["ids"].ToString());
listObj = BLLTable <TF_FORM> .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].FORM_ID + "',Name:'" + listObj[i].FORM_ID + "'}";//这里的Name用于显示在列表中，请自行重定义。
hidInitIDS.Value += listObj[i].FORM_ID;
}
}
try
{
listObj = BLLTable <TF_FORM> .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["DelFORM_ID"] != null)
{
int re = BLLTable <TF_FORM> .Factory(conn).Delete(TF_FORM.Attribute.FORM_ID, Request["DelFORM_ID"]);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在列表顶部点击删除按钮，通过AJAX执行这里的后台代码，删除多条记录
if (Request["DelKeyIDS"] != null)
{
TF_FORM cond = new TF_FORM();
cond.In(TF_FORM.Attribute.FORM_ID, Request["DelKeyIDS"]);
int re = BLLTable <TF_FORM> .Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在用户详细信息查看编辑页面，点保存时，通过AJAX执行这里的后台代码，实现部门字段的更新
if (Request["saveInfo"] != null)
{
TF_FORM val = new TF_FORM();
val.FORM_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_FORM> .Factory(conn).Update(val, TF_FORM.Attribute.FORM_ID);
Response.Write("修改用户信息成功");
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
//���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼
if (Request["DelFORM_ID"] != null)
{
int re = BLLTable<TF_FORM>.Factory(conn).Delete(TF_FORM.Attribute.FORM_ID, Request["DelFORM_ID"]);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼
if (Request["DelKeyIDS"] != null)
{
TF_FORM cond = new TF_FORM();
cond.In(TF_FORM.Attribute.FORM_ID, Request["DelKeyIDS"]);
int re = BLLTable<TF_FORM>.Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ���
if (Request["saveInfo"] != null)
{
TF_FORM val = new TF_FORM();
val.FORM_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_FORM>.Factory(conn).Update(val, TF_FORM.Attribute.FORM_ID);
Response.Write("���û���Ϣ�ɹ�");
}
Response.End();
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
try
{
recount = aspPager.RecordCount;
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<TF_FORM>(hidCondition.Value);
}
List<TF_FORM> listVal = BLLTable<TF_FORM>.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 aspPager_PageChanged(object sender, EventArgs e)
{
try
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <TF_FORM>(hidCondition.Value);
}
listObj = BLLTable <TF_FORM> .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_FORM condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
{
condObj.af_PageBy(TF_FORM.Attribute.FORM_ID, Order.Desc);
}
#region//数据权限条件
#endregion
//condObj.PID = decimal.Parse(pid);
listObj = BLLTable <TF_FORM> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request["id"]))
{
id = Convert.ToInt32(Convert.ToString(Request["id"]).Substring(0, Convert.ToString(Request["id"]).Length - 2));
}
//de
TF_FORM obj = new TF_FORM();
obj.FORM_ID = id;
obj.HTML = txtHTML.Value;
int intRet = -1;
if (id > 0)
{
intRet = BLLTable<TF_FORM>.Update(obj, TF_FORM.Attribute.FORM_ID);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request["id"]))
{
id = Convert.ToInt32(Convert.ToString(Request["id"]).Substring(0, Convert.ToString(Request["id"]).Length - 2));
}
//de
TF_FORM obj = new TF_FORM();
obj.FORM_ID = id;
obj.HTML = txtHTML.Value;
int intRet = -1;
if (id > 0)
{
intRet = BLLTable <TF_FORM> .Update(obj, TF_FORM.Attribute.FORM_ID);
}
}
protected void btnFind_Click(object sender, EventArgs e)
{
try
{
condObj = new TF_FORM();
if(txtF_NAME.Value !="" )
condObj.Like(TF_FORM.Attribute.F_NAME, Convert.ToString(txtF_NAME.Value));
listObj = BLLTable<TF_FORM>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repCus.DataSource = listObj;
repCus.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
aspPager.RecordCount = recount;
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
try
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<TF_FORM>(hidCondition.Value);
}
if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
condObj.af_PageBy(TF_FORM.Attribute.FORM_ID, Order.Desc);
listObj = BLLTable<TF_FORM>.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 btnFind_Click(object sender, EventArgs e)
{
condObj = new TF_FORM();
if(txtFORM_ID.Value !="" )
condObj.Like_OR(TF_FORM.Attribute.FORM_ID, Convert.ToInt32(txtFORM_ID.Value));
if(txtF_NAME.Value !="" )
condObj.Like_OR(TF_FORM.Attribute.F_NAME, Convert.ToString(txtF_NAME.Value));
if(txtTB_ID.Value !="" )
condObj.Like_OR(TF_FORM.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value));
if(txtTPL_EDIT.Value !="" )
condObj.Like_OR(TF_FORM.Attribute.TPL_EDIT, Convert.ToString(txtTPL_EDIT.Value));
if(txtTPL_SHOW.Value !="" )
condObj.Like_OR(TF_FORM.Attribute.TPL_SHOW, Convert.ToString(txtTPL_SHOW.Value));
if(txtTPL_PRINT.Value !="" )
condObj.Like_OR(TF_FORM.Attribute.TPL_PRINT, Convert.ToString(txtTPL_PRINT.Value));
if(txtTPL_LIST.Value !="" )
condObj.Like_OR(TF_FORM.Attribute.TPL_LIST, Convert.ToString(txtTPL_LIST.Value));
if(txtTB_IDS.Value !="" )
condObj.Like_OR(TF_FORM.Attribute.TB_IDS, Convert.ToString(txtTB_IDS.Value));
try
{
hidCondition.Value = condObj.ToJson(20);
listObj = BLLTable<TF_FORM>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repList.DataSource = listObj;
repList.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
try
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <TF_FORM>(hidCondition.Value);
}
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
{
condObj.af_PageBy(TF_FORM.Attribute.FORM_ID, Order.Desc);
}
listObj = BLLTable <TF_FORM> .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 Page_Load(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(Request["tree"]) && !string.IsNullOrEmpty(Request["id"]))
{
formid = Request["id"];
}
title = valObj._ZhName + "管理";
Page.Title = title;
if (!IsPostBack)
{
#region //默认属性初始化
aspPager.CurrentPageIndex = 1;
aspPager.ShowInputBox = AgileFrame.Core.WebSystem.ShowInputBox.Auto; //WebCtrls.
aspPager.PageSize = 30;
#endregion
TF_FORM tbObj = BLLTable <TF_FORM> .Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, formid);
title = "表单 " + tbObj.F_NAME + " 的栏目列表";
BindList(condObj, 1);
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region//Ĭ�����ص���
//hideTableColumnList = new List<AttributeItem>();
//hideTableColumnList.Add(TF_FORM.Attribute.EXP1);
//hideTableColumnList.Add(TF_FORM.Attribute.EXP2);
//hideTableColumnList.Add(TF_FORM.Attribute.EXP3);
//valObj.LoadAllAttributes(true);//��ʱ�Ӵ˴��룬�Ժ��ܸ��½�����Ҫ
//valObj.Remove(hideTableColumnList);
//hideFindColumnList = new List<AttributeItem>();
//hideFindColumnList.Add(TF_FORM.Attribute.EXP1);
//hideFindColumnList.Add(TF_FORM.Attribute.EXP2);
//hideFindColumnList.Add(TF_FORM.Attribute.EXP3);
#endregion
condObj.OrderBy(TF_FORM.Attribute.FORM_ID, Order.Desc);
if (!IsPostBack)
{
btnFind.Text = LanguageService.GetLanguageString("btnFind", "��ѯ");
aspPager.PageSize = 10;
aspPager.CurrentPageIndex = 1;
if (!string.IsNullOrEmpty(Request["ids"]))
{
TF_FORM roleOld = new TF_FORM();
roleOld.Where(TF_FORM.Attribute.FORM_ID, Request["ids"].ToString());
listObj = BLLTable<TF_FORM>.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].FORM_ID + "',Name:'" + listObj[i].FORM_ID + "'}";//�����Name������ʾ���б��У��������ض��塣
hidInitIDS.Value += listObj[i].FORM_ID;
}
}
try
{
listObj = BLLTable<TF_FORM>.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)
{
////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 void btnOK_Click(object sender, EventArgs e)
{
try
{
TF_FORM valObj = new TF_FORM();
if(txtFORM_ID.Value !="" )
valObj.FORM_ID = Convert.ToInt32(txtFORM_ID.Value);
if(txtF_NAME.Value !="" )
valObj.F_NAME = txtF_NAME.Value;
if(txtTB_ID.Value !="" )
valObj.TB_ID = Convert.ToInt32(hidTB_ID.Value);
valObj.TPL_EDIT = txtTPL_EDIT.Value;
valObj.TPL_SHOW =txtTPL_SHOW.Value;
valObj.TPL_PRINT =txtTPL_PRINT.Value;
valObj.TPL_LIST = txtTPL_LIST.Value;
if (keyid != "")
{
valObj.FORM_ID = Convert.ToInt32(keyid);
count = BLLTable<TF_FORM>.Factory(conn).Update(valObj, TF_FORM.Attribute.FORM_ID);
}
else
{
valObj.M_FORM_ID = pid;
count = BLLTable<TF_FORM>.Factory(conn).Insert(valObj, TF_FORM.Attribute.FORM_ID);
keyid = valObj.FORM_ID.ToString();
if (count > 0)
{
#region//�Զ�����Ĭ�ϱ����Ŀ
TF_TB_FIELD cond = new TF_TB_FIELD();
cond.TB_ID = valObj.TB_ID;
//cond.In(TF_TB_FIELD.Attribute.TB_ID, valObj.TB_ID + ",0");
List<TF_TB_FIELD> lstField = BLLTable<TF_TB_FIELD>.Factory(conn).Select(new TF_TB_FIELD(), cond);
if (lstField != null)
{
TF_F_COLUMN valCol = new TF_F_COLUMN();
valCol.TB_ID = valObj.TB_ID;
valCol.FORM_ID = valObj.FORM_ID;
lstField.ForEach(f =>
{
valCol.FIELD_ID = f.FIELD_ID;
valCol.SHOW_NAME = f.NOTE;
valCol.CTRL_TYPE = f.CTRL_TYPE;
valCol.SHOWIN_FORM = "1";
valCol.MAX_VAL = 0;
if (f.TB_ID == 0)
{
valCol.IS_DEFAULT = "1";
}
else
{
valCol.IS_DEFAULT = "0";
}
valCol.MIN_VAL = 0;
valCol.IS_NEED = f.IS_NULL == 1 ? 0 : 1;
valCol.SORT_NO = f.SORT_NO;
int aaa=BLLTable<TF_F_COLUMN>.Factory(conn).Insert(valCol, TF_F_COLUMN.Attribute.COLUMN_ID);
if (aaa > 0)
{
BLLTable<TF_TB_FIELD>.Factory(conn).Update(TF_TB_FIELD.Attribute.FIELD_ID, f.FIELD_ID,
TF_TB_FIELD.Attribute.CREATED, 1);
}
});
}
#endregion
List<TF_TABLE> lstMX = BLLTable<TF_TABLE>.Factory(conn).Select(TF_TABLE.Attribute.M_TB_ID, valObj.TB_ID);
if (lstMX != null && lstMX.Count > 0)
{
lstMX.ForEach(tb =>
{
TF_FORM valMX = new TF_FORM();
valMX.F_NAME = tb.CH_NAME;
valMX.TB_ID = Convert.ToInt32(tb.TB_ID);
valMX.TPL_EDIT = "";
valMX.TPL_SHOW = "";
valMX.TPL_PRINT = "";
valMX.TPL_LIST = "";
valMX.M_FORM_ID = valObj.FORM_ID;
int addmx = BLLTable<TF_FORM>.Factory(conn).Insert(valMX, TF_FORM.Attribute.FORM_ID);
#region//�Զ�����Ĭ�ϱ����Ŀ
TF_TB_FIELD condFFF = new TF_TB_FIELD();
//condFFF.In(TF_TB_FIELD.Attribute.TB_ID, valMX.TB_ID + ",0");
condFFF.TB_ID = valMX.TB_ID;
lstField = BLLTable<TF_TB_FIELD>.Factory(conn).Select(new TF_TB_FIELD(), condFFF);
if (lstField != null)
{
TF_F_COLUMN valCol = new TF_F_COLUMN();
valCol.TB_ID = valMX.TB_ID;
valCol.FORM_ID = valMX.FORM_ID;
lstField.ForEach(f =>
{
valCol.FIELD_ID = f.FIELD_ID;
valCol.SHOW_NAME = f.NOTE;
valCol.CTRL_TYPE = f.CTRL_TYPE;
valCol.SHOWIN_FORM = "1";
valCol.MAX_VAL = 0;
if (f.TB_ID == 0)
{
valCol.IS_DEFAULT = "1";
}
else
{
valCol.IS_DEFAULT = "0";
}
valCol.MIN_VAL = 0;
valCol.IS_NEED = f.IS_NULL == 1 ? 0 : 1;
valCol.SORT_NO = f.SORT_NO;
int aaa=BLLTable<TF_F_COLUMN>.Factory(conn).Insert(valCol, TF_F_COLUMN.Attribute.COLUMN_ID);
if (aaa > 0)
{
BLLTable<TF_TB_FIELD>.Factory(conn).Update(TF_TB_FIELD.Attribute.FIELD_ID, f.FIELD_ID,
TF_TB_FIELD.Attribute.CREATED, 1);
}
});
}
#endregion
});
}
}
}
if (count > 0)
{
StringBuilder sbData = new StringBuilder("({valObj:''");
List<AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("})");
Button btn = (Button)sender;
if (btn.ID == "btnOK")
{
if (Request["tree"] != null)
{
string gotoUrl = "../../../ok.aspx";
StringBuilder sb = new StringBuilder("{");
sb.Append("id:'");
sb.Append(keyid).Append("',pid:'").Append("0").Append("',no:").Append(valObj.FORM_ID).Append(",sc:1,name:'");
//CHG START ����ڵ�ѡ��ҳ���������� jin-shenjian 2013/10/26
//sb.Append(valObj.F_NAME).Append("',ntype:'form'}");
sb.Append(valObj.F_NAME).Append("',ntype:'TF_FORM_MANAGE'}");
//CHG END ����ڵ�ѡ��ҳ���������� jin-shenjian 2013/10/26
if (Request["edit"] == null)
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
else
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
}
else
{
if (ViewState["hadSave"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true);
}
}
}
else
{
txtF_NAME.Value ="";
txtTB_ID.Value ="";
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "�༭";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["FORM_ID"]))
{
keyid = Request["FORM_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!string.IsNullOrEmpty(Request["edit"]))
{
keyid = Request["id"];
}
else {
pid = int.Parse(Request["id"]);
}
if (!IsPostBack)
{
try
{
if (keyid != "")
{
valObj = BLLTable<TF_FORM>.Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, keyid);
if(valObj==null) return ;
txtFORM_ID.Value = Convert.ToString(valObj.FORM_ID);//Convert.ToInt32
txtF_NAME.Value = Convert.ToString(valObj.F_NAME);//Convert.ToString
hidTB_ID.Value = Convert.ToString(valObj.TB_ID);//Convert.ToInt32
txtTB_ID.Value = BLLTable<TF_TABLE>.Factory(conn).GetOneValue(TF_TABLE.Attribute.TB_ID, valObj.TB_ID, TF_TABLE.Attribute.CH_NAME);
txtTPL_EDIT.Value = Convert.ToString(valObj.TPL_EDIT);//Convert.ToString
txtTPL_SHOW.Value = Convert.ToString(valObj.TPL_SHOW);//Convert.ToString
txtTPL_PRINT.Value = Convert.ToString(valObj.TPL_PRINT);//Convert.ToString
txtTPL_LIST.Value = Convert.ToString(valObj.TPL_LIST);//Convert.ToString
//txtTB_IDS.Value = Convert.ToString(valObj.TB_IDS);//Convert.ToString
}
}
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["TB_ID"]))
{
keyid = Request["TB_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (Request["tree"] != null && Request["edit"] != null)
{
keyid = Request["id"];
}
if (!string.IsNullOrEmpty(Request["mx"]))
{
pid = int.Parse(Request["id"]);
}
if (!IsPostBack)
{
txtTB_NAME_PRE.Value = BaseFunc.UserDef_TablePre;
txtTB_TYPE.Items.AddRange(FormHelper.GetListItem(TF_TABLE.Attribute.TB_TYPE));
if (txtTB_TYPE.Items.Count > 1)
{
txtTB_TYPE.SelectedIndex = 1;
}
this.txtTB_ID.Disabled = true;
this.txtTB_ID.Attributes["class"] = "dis";
try
{
if (pid > 0)
{
TF_TABLE pObj = BLLTable <TF_TABLE> .Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, pid);
if (pObj.TB_NAME.LastIndexOf('_') != -1)
{
string[] arr = pObj.TB_NAME.Split('_');
txtTB_NAME_PRE.Value = arr[0] + "_";
txtTB_NAME.Value = pObj.TB_NAME.Substring(txtTB_NAME_PRE.Value.Length) + "_MX";
litTB_NAME_PRE.Text = txtTB_NAME_PRE.Value;
}
else
{
txtTB_NAME.Value = pObj.TB_NAME + "_MX";
txtTB_NAME_PRE.Value = "";
litTB_NAME_PRE.Text = "";
}
}
ViewState["OLDNAME"] = "";
if (keyid != "")
{
selTable.Visible = false;
valObj = BLLTable <TF_TABLE> .Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, keyid);
if (valObj == null)
{
return;
}
txtTB_ID.Value = Convert.ToString(valObj.TB_ID);//Convert.ToInt32
if (valObj.TB_NAME.LastIndexOf('_') != -1)
{
string[] arr = valObj.TB_NAME.Split('_');
txtTB_NAME_PRE.Value = arr[0] + "_";
txtTB_NAME.Value = valObj.TB_NAME.Substring(txtTB_NAME_PRE.Value.Length);
litTB_NAME_PRE.Text = txtTB_NAME_PRE.Value;
}
else
{
txtTB_NAME.Value = valObj.TB_NAME;
txtTB_NAME_PRE.Value = "";
litTB_NAME_PRE.Text = "";
}
ViewState["OLDNAME"] = valObj.TB_NAME;
txtCH_NAME.Value = Convert.ToString(valObj.CH_NAME); //Convert.ToString
//txtM_TB_ID.Value = Convert.ToString(valObj.M_TB_ID);//Convert.ToInt32
txtSORT_NO.Value = Convert.ToString(valObj.SORT_NO); //Convert.ToInt32
txtTB_TYPE.Value = valObj.TB_TYPE.ToString();
txtNOTE.Value = Convert.ToString(valObj.NOTE); //Convert.ToString
TF_FORM useTB = new TF_FORM();
useTB.Where("TB_ID=" + keyid + " or TB_IDS like '%," + keyid + ",%'");
if (BLLTable <TF_FORM> .Exists(useTB))
{
txtTB_NAME.Disabled = true;
txtTB_TYPE.Disabled = true;
}
txtTB_NAME_Save.Value = valObj.SOURCE_TABLE;
txtDB_NAME_Save.Value = valObj.SOURCE_DB;
source.Visible = false;
}
}
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["FORM_ID"]))
{
valObj = BLLTable <TF_FORM> .Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, Request["FORM_ID"]);
if (valObj == null)
{
return;
}
txtFORM_ID.Text = Convert.ToString(valObj.FORM_ID);//Convert.ToInt32
txtF_NAME.Text = Convert.ToString(valObj.F_NAME);//Convert.ToString
txtTB_ID.Text = Convert.ToString(valObj.TB_ID);//Convert.ToInt32
txtTPL_EDIT.Text = Convert.ToString(valObj.TPL_EDIT);//Convert.ToString
txtTPL_SHOW.Text = Convert.ToString(valObj.TPL_SHOW);//Convert.ToString
txtTPL_PRINT.Text = Convert.ToString(valObj.TPL_PRINT);//Convert.ToString
txtTPL_LIST.Text = Convert.ToString(valObj.TPL_LIST);//Convert.ToString
txtTB_IDS.Text = Convert.ToString(valObj.TB_IDS);//Convert.ToString
}
}
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();
}
}
}
/// <summary>
/// TF_FORM 从配置中获得表单布局
/// </summary>
/// <param name="conn"></param>
/// <param name="cond"></param>
/// <returns></returns>
public bool Parse(TF_TABLE cond,
out ITableImplement valObj, out ITableImplement condObj, out List <Relation> relationList, out List <ITableImplement> otherValueList,
out List <ITableImplement> condList, ref string msg)
{
valObj = new ITableImplement();
condObj = new ITableImplement();
//载入关系
otherValueList = new List <ITableImplement>();
condList = new List <ITableImplement>();
relationList = new List <Relation>();
msg = "条件不存在";
if (string.IsNullOrEmpty(cond.TB_NAME))
{
return(false);
}
DataBaseTable tb1;
List <DataBaseField> listf1 = new List <DataBaseField>();
List <DataBaseTable> listTb1 = new List <DataBaseTable>();
bool ret = true; tb1 = null;
//TF_TABLE val = BLLTable<TF_TABLE>.Factory(conn).GetRowData(new TF_TABLE(), cond);
TF_TB_FIELD val1 = new TF_TB_FIELD();
TF_F_COLUMN val2 = new TF_F_COLUMN();
TF_TABLE val3 = new TF_TABLE();
TF_TB_FIELD cond1 = new TF_TB_FIELD();
TF_F_COLUMN cond2 = new TF_F_COLUMN();
TF_FORM cond3 = new TF_FORM();
List <ITableImplement> otherValueList1 = new List <ITableImplement>();
List <ITableImplement> condList1 = new List <ITableImplement>();
otherValueList1.Add(val2); otherValueList1.Add(val3);
condList1.Add(cond);
List <Relation> relationList1 = new List <Relation>();
relationList1.Add(RelationFactory.TF_TABLE_TF_FORM);
relationList1.Add(RelationFactory.TF_TABLE_TF_TB_FIELD);
relationList1.Add(RelationFactory.TF_TB_FIELD_TF_F_COLUMN);
int pageSize = 100;
int pageIndex = 1;
int recount = -1;
string cachekey = null;
List <TF_TB_FIELD> list1 = BLLTable <TF_TB_FIELD> .Factory(conn).SelectByPage(val1, relationList1, otherValueList1, condList1,
pageSize, pageIndex, ref recount, out cachekey);
if (list1.Count == 0)
{
DataBaseTable dt1 = null;
dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[cond.TB_NAME];
msg = cond.TB_NAME + " 数据表不存在";
if (dt1 == null)
{
ret = false;
ConsoleService.Warn(msg);
}
return(ret);
}
if (list1.Count > 90)
{
msg = "条件错误，所配置的字段记录超过90";
return(false);
}
//生成布局模版用
tb1 = new DataBaseTable();
foreach (TF_TB_FIELD item in list1)
{
string tbName = Convert.ToString(item.GetValue(TF_TABLE.Attribute.TB_NAME)).ToLower();
#region 表操作
DataBaseTable dt1 = null;
dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[tbName];
msg = tbName + " 数据表不存在"; ret = false;
if (dt1 == null)
{
ConsoleService.Warn(msg);
return(ret);
}
tb1 = dt1;
listTb1.Add(dt1);
//是否显示
object obj1 = null;
object obj2 = null;
object obj3 = null;
if (item.TryGetValue(TF_FORM.Attribute.FORM_ID, out obj1))
{
dt1.IsVisable = true;
}
#endregion
string fieldName = item.FIELD_NAME.ToLower();
#region 列操作
DataBaseField f1 = null;
msg = string.Format("数据表{0},数据字段{1}不存在", tbName, fieldName);
if (!dt1.DataFields.TryGetValue(fieldName, out f1))
{
ret = false;
ConsoleService.Warn(msg);
continue;
}
//是否显示
obj1 = null; obj2 = null; obj3 = null;
if (item.TryGetValue(TF_F_COLUMN.Attribute.COLUMN_ID, out obj1) &&
item.TryGetValue(TF_F_COLUMN.Attribute.SHOW_NAME, out obj2) &&
item.TryGetValue(TF_F_COLUMN.Attribute.CTRL_TYPE, out obj3))
{
//f1.IsVisable = true;
}
#endregion
listf1.Add(f1);
}
//取值对象
valObj = ITableImplement.Factory(tb1);
//其他取值对象
foreach (DataBaseTable tb2 in listTb1)
{
if (tb2.TableName == tb1.TableName)
{
continue;
}
otherValueList.Add(ITableImplement.Factory(tb2));
}
//关系呢
return(ret);
}
/// <summary>
/// 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)
{
dics.Add("TF_TABLE-root", "TF_TABLE");
dics.Add("TF_TABLE", "TF_TABLE");
//dics.Add("TF_TABLE", "TF_TABLE-mx");
if (!IsPostBack)
{
#region////显示子节点
if (Request["getSubNodes"] != null)
{
string nodetype = Request["ntype"];
StringBuilder sb = new StringBuilder("[");
string id = Request["id"];
if (nodetype == "TF_TABLE-root")
{
#region
TF_TABLE obj = new TF_TABLE();
TF_TABLE val = new TF_TABLE();
obj.M_TB_ID = 0;
val.OrderBy(TF_TABLE.Attribute.SORT_NO, Order.Asc);
List <TF_TABLE> lst = BLLTable <TF_TABLE> .Select(val, obj);
if (lst.Count != null)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].TB_ID);
sb.Append("',pid:'").Append("0").Append("',no:").Append(lst[i].SORT_NO);
sb.Append(",sc:").Append("-1");
sb.Append(",name:'").Append(lst[i].CH_NAME).Append("',ntype:'TF_TABLE'}");
}
}
#endregion
}
if (nodetype == "TF_TABLE" || nodetype == "TF_TABLE-mx")
{
if (nodetype == "TF_TABLE")//明细表，将不会再有子级的明细表。。。
{
#region
TF_TABLE objTB = new TF_TABLE();
TF_TABLE valTB = new TF_TABLE();
objTB.M_TB_ID = int.Parse(id);
valTB.OrderBy(TF_TABLE.Attribute.SORT_NO, Order.Asc);
List <TF_TABLE> lstTB = BLLTable <TF_TABLE> .Select(valTB, objTB);
if (lstTB.Count != null)
{
for (int i = 0; i < lstTB.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lstTB[i].TB_ID);
sb.Append("',pid:'").Append(id).Append("',no:").Append(lstTB[i].SORT_NO);
sb.Append(",sc:").Append("1");
sb.Append(",name:'").Append(lstTB[i].CH_NAME).Append("',ntype:'TF_TABLE-mx'}");
}
}
#endregion
}
#region
TF_TB_FIELD obj = new TF_TB_FIELD();
TF_TB_FIELD val = new TF_TB_FIELD();
obj.TB_ID = int.Parse(id);
val.OrderBy(TF_TB_FIELD.Attribute.SORT_NO, Order.Asc);
List <TF_TB_FIELD> lst = BLLTable <TF_TB_FIELD> .Select(val, obj);
if (lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].FIELD_ID.ToString());
sb.Append("',pid:'").Append(lst[i].TB_ID.ToString()).Append("',no:").Append(lst[i].SORT_NO);
sb.Append(",sc:").Append("0");
sb.Append(",name:'").Append(lst[i].NOTE).Append("',ntype:'TF_F_COLUMN'}");
}
}
#endregion
}
if (nodetype == "TF_FORM-root")
{
#region
TF_FORM obj = new TF_FORM();
TF_FORM val = new TF_FORM();
obj.M_FORM_ID = 0;
val.OrderBy(TF_FORM.Attribute.FORM_ID, Order.Asc);
List <TF_FORM> lst = BLLTable <TF_FORM> .Select(val, obj);
if (lst.Count != null)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].FORM_ID);
sb.Append("',pid:'").Append(lst[i].TB_ID).Append("',no:").Append(lst[i].FORM_ID);
sb.Append(",sc:").Append("1");
sb.Append(",name:'").Append(lst[i].F_NAME).Append("',ntype:'TF_FORM'}");
}
}
#endregion
}
if (nodetype == "TF_FORM" || nodetype == "TF_FORM-mx")
{
if (nodetype == "TF_FORM")
{
#region
TF_FORM objForm = new TF_FORM();
TF_FORM valForm = new TF_FORM();
objForm.M_FORM_ID = int.Parse(id);
valForm.OrderBy(TF_FORM.Attribute.FORM_ID, Order.Asc);
List <TF_FORM> lstForm = BLLTable <TF_FORM> .Select(valForm, objForm);
if (lstForm.Count != null)
{
for (int i = 0; i < lstForm.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lstForm[i].FORM_ID);
sb.Append("',pid:'").Append(id).Append("',no:").Append(lstForm[i].FORM_ID);
sb.Append(",sc:").Append("1");
sb.Append(",name:'").Append(lstForm[i].F_NAME).Append("',ntype:'TF_FORM-mx'}");
}
}
#endregion
}
#region
TF_F_COLUMN obj = new TF_F_COLUMN();
TF_F_COLUMN val = new TF_F_COLUMN();
//obj.IS_DEFAULT = "0";
obj.FORM_ID = int.Parse(id);
val.OrderBy(TF_F_COLUMN.Attribute.SORT_NO, Order.Asc);
List <TF_F_COLUMN> lst = BLLTable <TF_F_COLUMN> .Select(val, obj);
if (lst.Count != null)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].COLUMN_ID);
sb.Append("',pid:'").Append(lst[i].FORM_ID).Append("',no:").Append(lst[i].SORT_NO);
sb.Append(",sc:").Append("0");
sb.Append(",name:'").Append(lst[i].SHOW_NAME).Append("',ntype:'TF_F_COLUMN'}");
}
}
#endregion
}
//sb.Append("{id:'").Append("1");
//sb.Append("',pid:'").Append("0").Append("',no:").Append("1");
//sb.Append(",sc:").Append("1");
//sb.Append(",name:'").Append("aaaaa(aaa)").Append("',ntype:'TF_FORM'}");
sb.Append("]");
Response.Write(sb.ToString());
}
#endregion
#region//删除节点
if (Request["deleteNode"] != null)
{
string str = "";
string delID = Request["id"];
string ntype = Request["ntype"];
if (ntype == "table" || ntype == "TF_TABLE-mx")
{
#region//删除表
int re = 0;
string msg = "删除数据库表成功！";
TF_TABLE cccSub = new TF_TABLE();
cccSub.M_TB_ID = int.Parse(delID);
if (BLLTable <TF_TABLE> .Count(cccSub) > 0)
{
msg = "存在明细表，不能删除!";
}
else
{
TF_TB_FIELD hadcol = new TF_TB_FIELD();
hadcol.TB_ID = int.Parse(delID);
if (BLLTable <TF_TB_FIELD> .Exists(hadcol))
{
msg = "存在字段，不能删除此表";
}
else
{
TF_FORM useTB = new TF_FORM();
useTB.Where("TB_ID=" + delID + " or TB_IDS like '%," + delID + ",%'");
if (BLLTable <TF_FORM> .Exists(useTB))
{
msg = "此表已被表单使用，不能删除";
}
else
{
re = new TF_TABLEHelper(conn).DelTable(delID, ref msg);// ;
if (re > 0)
{
if (BLLTable <TF_TABLE> .Delete(TF_TABLE.Attribute.TB_ID, delID) <= 0)
{
msg = "删除数据库表成功，但删除表结构信息失败！";
}
}
else
{
msg = "删除表结构信息失败！";
}
}
}
}
#endregion
str = "{re:" + re + ",msg:'" + msg + "'}";
}
else if (ntype == "field")
{
#region //删除表字段
string msg = "删除数据库表字段成功！";
int re = new TF_TABLEHelper(conn).DelField(delID, ref msg); // ;
if (re > 0)
{
if (BLLTable <TF_TB_FIELD> .Delete(TF_TB_FIELD.Attribute.FIELD_ID, delID) <= 0)
{
msg = "删除数据库表字段成功，但删除字段结构信息失败！";
}
}
else
{
msg = "删除数据库表字段失败！";
}
#endregion
str = "{re:" + re + ",msg:'" + msg + "'}";
}
else if (ntype == "TF_FORM" || ntype == "TF_FORM-mx")
{
#region//删除表单
int re = 0;
string msg = "删除表单成功！";
TF_FORM cccSub = new TF_FORM();
cccSub.M_FORM_ID = int.Parse(delID);
if (BLLTable <TF_FORM> .Count(cccSub) > 0)
{
msg = "存在明细表单，不能删除!";
}
else
{
TF_F_COLUMN ccc = new TF_F_COLUMN();
ccc.FORM_ID = int.Parse(delID);
ccc.IS_DEFAULT = "0";
if (BLLTable <TF_F_COLUMN> .Count(ccc) > 0)
{
msg = "存在栏目，不能删除!";
}
else
{
re = BLLTable <TF_FORM> .Delete(TF_FORM.Attribute.FORM_ID, delID);
BLLTable <TF_F_COLUMN> .Delete(TF_F_COLUMN.Attribute.FORM_ID, delID);
if (re <= 0)
{
msg = "删除表单失败！";
}
}
}
#endregion
str = "{re:" + re + ",msg:'" + msg + "'}";
}
else if (ntype == "TF_F_COLUMN")
{
string msg = "删除表单栏目成功！";
TF_F_COLUMN oldObj = BLLTable <TF_F_COLUMN> .GetRowData(TF_F_COLUMN.Attribute.COLUMN_ID, delID);
int re = BLLTable <TF_F_COLUMN> .Delete(TF_F_COLUMN.Attribute.COLUMN_ID, delID);
if (re <= 0)
{
msg = "删除表单栏目失败";
}
else
{
if (oldObj != null)
{
BLLTable <TF_TB_FIELD> .Update(TF_TB_FIELD.Attribute.FIELD_ID, oldObj.FIELD_ID,
TF_TB_FIELD.Attribute.CREATED, 0);
}
}
str = "{re:" + re + ",msg:'" + msg + "'}";
}
Response.Write(str);
}
#endregion
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
dics.Add("TF_TABLE-root", "TF_TABLE");
dics.Add("TF_TABLE", "TF_TABLE");
//dics.Add("TF_TABLE", "TF_TABLE-mx");
if (!IsPostBack)
{
#region////显示子节点
if (Request["getSubNodes"] != null)
{
string nodetype = Request["ntype"];
StringBuilder sb = new StringBuilder("[");
string id = Request["id"];
if (nodetype == "TF_TABLE-root")
{
#region
TF_TABLE obj = new TF_TABLE();
TF_TABLE val = new TF_TABLE();
obj.M_TB_ID = 0;
val.OrderBy(TF_TABLE.Attribute.SORT_NO, Order.Asc);
List<TF_TABLE> lst = BLLTable<TF_TABLE>.Select(val, obj);
if (lst.Count != null)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].TB_ID);
sb.Append("',pid:'").Append("0").Append("',no:").Append(lst[i].SORT_NO);
sb.Append(",sc:").Append("-1");
sb.Append(",name:'").Append(lst[i].CH_NAME).Append("',ntype:'TF_TABLE'}");
}
}
#endregion
}
if (nodetype == "TF_TABLE" || nodetype == "TF_TABLE-mx")
{
if (nodetype == "TF_TABLE")//明细表，将不会再有子级的明细表。。。
{
#region
TF_TABLE objTB = new TF_TABLE();
TF_TABLE valTB = new TF_TABLE();
objTB.M_TB_ID = int.Parse(id);
valTB.OrderBy(TF_TABLE.Attribute.SORT_NO, Order.Asc);
List<TF_TABLE> lstTB = BLLTable<TF_TABLE>.Select(valTB, objTB);
if (lstTB.Count != null)
{
for (int i = 0; i < lstTB.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lstTB[i].TB_ID);
sb.Append("',pid:'").Append(id).Append("',no:").Append(lstTB[i].SORT_NO);
sb.Append(",sc:").Append("1");
sb.Append(",name:'").Append(lstTB[i].CH_NAME).Append("',ntype:'TF_TABLE-mx'}");
}
}
#endregion
}
#region
TF_TB_FIELD obj = new TF_TB_FIELD();
TF_TB_FIELD val = new TF_TB_FIELD();
obj.TB_ID = int.Parse(id);
val.OrderBy(TF_TB_FIELD.Attribute.SORT_NO, Order.Asc);
List<TF_TB_FIELD> lst = BLLTable<TF_TB_FIELD>.Select(val, obj);
if (lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].FIELD_ID.ToString());
sb.Append("',pid:'").Append(lst[i].TB_ID.ToString()).Append("',no:").Append(lst[i].SORT_NO);
sb.Append(",sc:").Append("0");
sb.Append(",name:'").Append(lst[i].NOTE).Append("',ntype:'TF_F_COLUMN'}");
}
}
#endregion
}
if (nodetype == "TF_FORM-root")
{
#region
TF_FORM obj = new TF_FORM();
TF_FORM val = new TF_FORM();
obj.M_FORM_ID = 0;
val.OrderBy(TF_FORM.Attribute.FORM_ID, Order.Asc);
List<TF_FORM> lst = BLLTable<TF_FORM>.Select(val, obj);
if (lst.Count != null)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].FORM_ID);
sb.Append("',pid:'").Append(lst[i].TB_ID).Append("',no:").Append(lst[i].FORM_ID);
sb.Append(",sc:").Append("1");
sb.Append(",name:'").Append(lst[i].F_NAME).Append("',ntype:'TF_FORM'}");
}
}
#endregion
}
if (nodetype == "TF_FORM" || nodetype == "TF_FORM-mx")
{
if (nodetype == "TF_FORM")
{
#region
TF_FORM objForm = new TF_FORM();
TF_FORM valForm = new TF_FORM();
objForm.M_FORM_ID = int.Parse(id);
valForm.OrderBy(TF_FORM.Attribute.FORM_ID, Order.Asc);
List<TF_FORM> lstForm = BLLTable<TF_FORM>.Select(valForm, objForm);
if (lstForm.Count != null)
{
for (int i = 0; i < lstForm.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lstForm[i].FORM_ID);
sb.Append("',pid:'").Append(id).Append("',no:").Append(lstForm[i].FORM_ID);
sb.Append(",sc:").Append("1");
sb.Append(",name:'").Append(lstForm[i].F_NAME).Append("',ntype:'TF_FORM-mx'}");
}
}
#endregion
}
#region
TF_F_COLUMN obj = new TF_F_COLUMN();
TF_F_COLUMN val = new TF_F_COLUMN();
//obj.IS_DEFAULT = "0";
obj.FORM_ID = int.Parse(id);
val.OrderBy(TF_F_COLUMN.Attribute.SORT_NO, Order.Asc);
List<TF_F_COLUMN> lst = BLLTable<TF_F_COLUMN>.Select(val, obj);
if (lst.Count != null)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].COLUMN_ID);
sb.Append("',pid:'").Append(lst[i].FORM_ID).Append("',no:").Append(lst[i].SORT_NO);
sb.Append(",sc:").Append("0");
sb.Append(",name:'").Append(lst[i].SHOW_NAME).Append("',ntype:'TF_F_COLUMN'}");
}
}
#endregion
}
//sb.Append("{id:'").Append("1");
//sb.Append("',pid:'").Append("0").Append("',no:").Append("1");
//sb.Append(",sc:").Append("1");
//sb.Append(",name:'").Append("aaaaa(aaa)").Append("',ntype:'TF_FORM'}");
sb.Append("]");
Response.Write(sb.ToString());
}
#endregion
#region//删除节点
if (Request["deleteNode"] != null)
{
string str = "";
string delID=Request["id"];
string ntype=Request["ntype"];
if (ntype == "table" || ntype == "TF_TABLE-mx")
{
#region//删除表
int re = 0;
string msg = "删除数据库表成功！";
TF_TABLE cccSub = new TF_TABLE();
cccSub.M_TB_ID = int.Parse(delID);
if (BLLTable<TF_TABLE>.Count(cccSub) > 0)
{
msg = "存在明细表，不能删除!";
}
else
{
TF_TB_FIELD hadcol = new TF_TB_FIELD();
hadcol.TB_ID = int.Parse(delID);
if (BLLTable<TF_TB_FIELD>.Exists(hadcol))
{
msg = "存在字段，不能删除此表";
}
else
{
TF_FORM useTB = new TF_FORM();
useTB.Where("TB_ID=" + delID + " or TB_IDS like '%," + delID + ",%'");
if (BLLTable<TF_FORM>.Exists(useTB))
{
msg = "此表已被表单使用，不能删除";
}
else
{
re = new TF_TABLEHelper(conn).DelTable(delID, ref msg);// ;
if (re > 0)
{
if (BLLTable<TF_TABLE>.Delete(TF_TABLE.Attribute.TB_ID, delID) <= 0)
{
msg = "删除数据库表成功，但删除表结构信息失败！";
}
}
else
{
msg = "删除表结构信息失败！";
}
}
}
}
#endregion
str = "{re:" + re + ",msg:'" + msg + "'}";
}
else if (ntype == "field")
{
#region//删除表字段
string msg = "删除数据库表字段成功！";
int re = new TF_TABLEHelper(conn).DelField(delID, ref msg);// ;
if (re > 0)
{
if (BLLTable<TF_TB_FIELD>.Delete(TF_TB_FIELD.Attribute.FIELD_ID, delID) <= 0)
{
msg = "删除数据库表字段成功，但删除字段结构信息失败！";
}
}
else {
msg = "删除数据库表字段失败！";
}
#endregion
str = "{re:" + re + ",msg:'" + msg + "'}";
}
else if (ntype == "TF_FORM" || ntype == "TF_FORM-mx")
{
#region//删除表单
int re = 0;
string msg = "删除表单成功！";
TF_FORM cccSub = new TF_FORM();
cccSub.M_FORM_ID = int.Parse(delID);
if (BLLTable<TF_FORM>.Count(cccSub) > 0)
{
msg = "存在明细表单，不能删除!";
}
else
{
TF_F_COLUMN ccc = new TF_F_COLUMN();
ccc.FORM_ID = int.Parse(delID);
ccc.IS_DEFAULT = "0";
if (BLLTable<TF_F_COLUMN>.Count(ccc) > 0)
{
msg = "存在栏目，不能删除!";
}
else
{
re = BLLTable<TF_FORM>.Delete(TF_FORM.Attribute.FORM_ID, delID);
BLLTable<TF_F_COLUMN>.Delete(TF_F_COLUMN.Attribute.FORM_ID, delID);
if (re <= 0)
{
msg = "删除表单失败！";
}
}
}
#endregion
str = "{re:" + re+",msg:'" + msg + "'}";
}
else if (ntype == "TF_F_COLUMN")
{
string msg = "删除表单栏目成功！";
TF_F_COLUMN oldObj = BLLTable<TF_F_COLUMN>.GetRowData(TF_F_COLUMN.Attribute.COLUMN_ID, delID);
int re = BLLTable<TF_F_COLUMN>.Delete(TF_F_COLUMN.Attribute.COLUMN_ID, delID);
if (re <= 0)
{
msg = "删除表单栏目失败";
}
else {
if (oldObj != null)
{
BLLTable<TF_TB_FIELD>.Update(TF_TB_FIELD.Attribute.FIELD_ID, oldObj.FIELD_ID,
TF_TB_FIELD.Attribute.CREATED, 0);
}
}
str = "{re:" + re + ",msg:'" + msg + "'}";
}
Response.Write(str);
}
#endregion
}
Response.End();
}
protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new TF_FORM();
if (txtFORM_ID.Value != "")
{
condObj.Like_OR(TF_FORM.Attribute.FORM_ID, Convert.ToInt32(txtFORM_ID.Value));
}
if (txtF_NAME.Value != "")
{
condObj.Like_OR(TF_FORM.Attribute.F_NAME, Convert.ToString(txtF_NAME.Value));
}
if (txtTB_ID.Value != "")
{
condObj.Like_OR(TF_FORM.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value));
}
if (txtTPL_EDIT.Value != "")
{
condObj.Like_OR(TF_FORM.Attribute.TPL_EDIT, Convert.ToString(txtTPL_EDIT.Value));
}
if (txtTPL_SHOW.Value != "")
{
condObj.Like_OR(TF_FORM.Attribute.TPL_SHOW, Convert.ToString(txtTPL_SHOW.Value));
}
if (txtTPL_PRINT.Value != "")
{
condObj.Like_OR(TF_FORM.Attribute.TPL_PRINT, Convert.ToString(txtTPL_PRINT.Value));
}
if (txtTPL_LIST.Value != "")
{
condObj.Like_OR(TF_FORM.Attribute.TPL_LIST, Convert.ToString(txtTPL_LIST.Value));
}
if (txtTB_IDS.Value != "")
{
condObj.Like_OR(TF_FORM.Attribute.TB_IDS, Convert.ToString(txtTB_IDS.Value));
}
try
{
hidCondition.Value = condObj.ToJson(20);
listObj = BLLTable <TF_FORM> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repList.DataSource = listObj;
repList.DataBind();
}
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"] == "formcol")
{
keyid = Request["id"];
}
if (Request["ntype"] == "form" || Request["ntype"] == "form-mx")
{
formid = Request["id"];
txtFORM_ID.Value = formid;
}
if (!string.IsNullOrEmpty(Request["formid"]))
{
formid = Request["formid"];
txtFORM_ID.Value = formid;
}
if (!IsPostBack)
{
dlCAL_FORMULA.Style.Value = "display:none"; //.Visible = false;
dlSUM_FIELD_ID.Style.Value = "display:none"; //.Visible = false;
//try
//{
ViewState["txtFIELD_ID"] = "";
if (keyid != "")
{
valObj = BLLTable <TF_F_COLUMN> .Factory(conn).GetRowData(TF_F_COLUMN.Attribute.COLUMN_ID, keyid);
if (valObj == null)
{
return;
}
txtCOLUMN_ID.Value = Convert.ToString(valObj.COLUMN_ID); //Convert.ToInt32
formid = valObj.FORM_ID.ToString();
txtFORM_ID.Value = Convert.ToString(valObj.FORM_ID); //Convert.ToInt32
txtTB_ID.Value = Convert.ToString(valObj.TB_ID); //Convert.ToInt32
hidFIELD_ID.Value = Convert.ToString(valObj.FIELD_ID); //Convert.ToInt32
txtFIELD_ID.Value = BLLTable <TF_TB_FIELD> .Factory(conn).GetOneValue(TF_TB_FIELD.Attribute.FIELD_ID, valObj.FIELD_ID, TF_TB_FIELD.Attribute.NOTE);
ViewState["txtFIELD_ID"] = txtFIELD_ID.Value;
txtSHOW_NAME.Value = Convert.ToString(valObj.SHOW_NAME);//Convert.ToString
//txtCTRL_TYPE.Value = Convert.ToString(valObj.CTRL_TYPE);//Convert.ToString
txtMAX_VAL.Value = Convert.ToString(valObj.MAX_VAL); //Convert.ToInt32
txtMIN_VAL.Value = Convert.ToString(valObj.MIN_VAL); //Convert.ToInt32
txtIS_NEED.Checked = valObj.IS_NEED == 1 ? true : false; //Convert.ToInt32
//txtCAL_FORMULA.Value = Convert.ToString(valObj.CAL_FORMULA);//Convert.ToString
txtSUM_FIELD_ID.Value = Convert.ToString(valObj.SUM_FIELD_ID); //Convert.ToString
txtSORT_NO.Value = Convert.ToString(valObj.SORT_NO); //Convert.ToInt32
txtCAL_FORMULA.Value = valObj.CAL_FORMULA;
if (valObj.SHOWIN_HEADER == "1")
{
txtSHOWIN_HEADR.Checked = true;
}
else
{
txtSHOWIN_HEADR.Checked = false;
}
txtSHOWIN_FORM.Checked = valObj.SHOWIN_FORM == "1" ? true : false;
TF_TB_FIELD fieldObj = BLLTable <TF_TB_FIELD> .Factory(conn).GetRowData(TF_TB_FIELD.Attribute.FIELD_ID, valObj.FIELD_ID);
if (fieldObj != null)
{
if (fieldObj.TYPE_CODE == TF_ENUM.FieldTypeCode.Decimal.ToString() ||
fieldObj.TYPE_CODE == TF_ENUM.FieldTypeCode.Number.ToString())
{
//dlCAL_FORMULA.Style.Value = "display:block";//.Visible = true;
}
else
{
dlCAL_FORMULA.Visible = false;
dlSUM_FIELD_ID.Visible = false;
}
}
else
{
litWarn.Text = "对应字段关联不正确。";
}
// Response.Write(fieldObj.TYPE_CODE);
}
if (txtFORM_ID.Value != "")
{
#region //初始化用于编写公式的可选字段列表
TF_FORM formObj = BLLTable <TF_FORM> .Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, txtFORM_ID.Value);
if (formObj != null && formObj.M_FORM_ID > 0)
{
TF_TB_FIELD numccc = new TF_TB_FIELD();
numccc.In(TF_TB_FIELD.Attribute.TYPE_CODE, TF_ENUM.FieldTypeCode.Decimal.ToString() + "," + TF_ENUM.FieldTypeCode.Number.ToString());
numccc.TB_ID = formObj.TB_ID;
List <TF_TB_FIELD> fieldList = BLLTable <TF_TB_FIELD> .Factory(conn).Select(new TF_TB_FIELD(), numccc);
if (fieldList != null && fieldList.Count > 0)
{
StringBuilder sbnumcols = new StringBuilder();
fieldList.ForEach(f => {
sbnumcols.Append("<a data='" + f.FIELD_NAME + "' onclick='selColToCalInput(this);'>" + f.NOTE + "(" + f.FIELD_NAME + ")</a>");
});
litNumberFields.Text = sbnumcols.ToString();
if (keyid != "")
{
dlCAL_FORMULA.Style.Value = "display:block"; //.Visible = true;
}
//dlCAL_FORMULA.Visible = true;
}
}
#endregion
#region //初始化综合可以用于作为主表某个字段的值的字段列表,这些字段来自明细表
if (formObj != null && formObj.M_FORM_ID > 0)
{
formObj = BLLTable <TF_FORM> .Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, formObj.M_FORM_ID);
if (formObj != null)
{
TF_TB_FIELD numccc = new TF_TB_FIELD();
numccc.In(TF_TB_FIELD.Attribute.TYPE_CODE, TF_ENUM.FieldTypeCode.Decimal.ToString() + "," + TF_ENUM.FieldTypeCode.Number.ToString());
numccc.TB_ID = formObj.TB_ID;
TF_TABLE tbObj = BLLTable <TF_TABLE> .Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, formObj.TB_ID);
List <TF_TB_FIELD> fieldList = BLLTable <TF_TB_FIELD> .Factory(conn).Select(new TF_TB_FIELD(), numccc);
if (fieldList != null && fieldList.Count > 0)
{
StringBuilder sbnumcols = new StringBuilder();
fieldList.ForEach(f =>
{
sbnumcols.Append("<a class='cansel' data='" + tbObj.TB_NAME + "." + f.FIELD_NAME + "' onclick='selColToSum(this);'>" + f.NOTE + "(" + f.FIELD_NAME + ")</a>");
});
litSUM_FIELD_ID.Text = sbnumcols.ToString();
if (keyid != "")
{
dlSUM_FIELD_ID.Style.Value = "display:block"; //.Visible = true;
}
//dlSUM_FIELD_ID.Visible = true;
}
}
}
#endregion
}
#region //初始化控件类型
TF_CTRL_TYPE ctrlCond = new TF_CTRL_TYPE();
ctrlCond.OrderBy(TF_CTRL_TYPE.Attribute.SORT_NO, Order.Asc);
DataTable dtCtrl = BLLTable <TF_CTRL_TYPE> .SelectForDataTable(new TF_CTRL_TYPE(), ctrlCond);
ViewState["CTRL_TYPE"] = valObj.CTRL_TYPE;
DataView dv1 = new DataView();
dv1.Table = dtCtrl;
dv1.RowFilter = "P_CTRL_TYPE='0'";
dv1.Sort = "SORT_NO asc";
for (int i = 0; i < dv1.Count; i++)
{
litCTRL_TYPE.Text += "<optgroup label='" + dv1[i]["CTRL_NAME"].ToString() + "'>";
DataView dv2 = new DataView();
dv2.Table = dtCtrl;
dv2.RowFilter = "P_CTRL_TYPE='" + dv1[i]["CTRL_TYPE"].ToString() + "'";
dv2.Sort = "SORT_NO asc";
for (int a = 0; a < dv2.Count; a++)
{
if (valObj != null && valObj.CTRL_TYPE == dv2[a]["CTRL_TYPE"].ToString())
{
litCTRL_TYPE.Text += "<option value='" + dv2[a]["CTRL_TYPE"].ToString() + "' selected='selected'>" + dv2[a]["CTRL_NAME"].ToString() + "</option>";
}
else
{
litCTRL_TYPE.Text += "<option value='" + dv2[a]["CTRL_TYPE"].ToString() + "'>" + dv2[a]["CTRL_NAME"].ToString() + "</option>";
}
}
litCTRL_TYPE.Text += "</optgroup>";
}
#endregion
//}
//catch (Exception ex)
//{
// litWarn.Text = ex.Message;
//}
}
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "�༭";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["TB_ID"]))
{
keyid = Request["TB_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (Request["tree"] != null && Request["edit"] != null)
{
keyid = Request["id"];
}
if (!string.IsNullOrEmpty(Request["mx"]))
{
pid = int.Parse(Request["id"]);
}
if (!IsPostBack)
{
txtTB_NAME_PRE.Value = "WFTB_";
txtTB_TYPE.Items.AddRange(FormHelper.GetListItem(TF_TABLE.Attribute.TB_TYPE));
if (txtTB_TYPE.Items.Count > 1)
{
txtTB_TYPE.SelectedIndex = 1;
}
this.txtTB_ID.Disabled = true;
this.txtTB_ID.Attributes["class"] = "dis";
try
{
if (pid > 0)
{
TF_TABLE pObj = BLLTable<TF_TABLE>.Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, pid);
if (pObj.TB_NAME.LastIndexOf('_') != -1)
{
string[] arr = pObj.TB_NAME.Split('_');
txtTB_NAME_PRE.Value = arr[0] + "_";
txtTB_NAME.Value = pObj.TB_NAME.Substring(txtTB_NAME_PRE.Value.Length) + "_MX";
litTB_NAME_PRE.Text = txtTB_NAME_PRE.Value;
}
else
{
txtTB_NAME.Value = pObj.TB_NAME + "_MX";
txtTB_NAME_PRE.Value = "";
litTB_NAME_PRE.Text = "";
}
}
ViewState["OLDNAME"] = "";
if (keyid != "")
{
valObj = BLLTable<TF_TABLE>.Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, keyid);
if (valObj == null) return;
txtTB_ID.Value = Convert.ToString(valObj.TB_ID);//Convert.ToInt32
if (valObj.TB_NAME.LastIndexOf('_') != -1)
{
string[] arr = valObj.TB_NAME.Split('_');
txtTB_NAME_PRE.Value = arr[0] + "_";
txtTB_NAME.Value = valObj.TB_NAME.Substring(txtTB_NAME_PRE.Value.Length);
litTB_NAME_PRE.Text = txtTB_NAME_PRE.Value;
}
else
{
txtTB_NAME.Value = valObj.TB_NAME;
txtTB_NAME_PRE.Value = "";
litTB_NAME_PRE.Text = "";
}
ViewState["OLDNAME"] = valObj.TB_NAME;
txtCH_NAME.Value = Convert.ToString(valObj.CH_NAME);//Convert.ToString
//txtM_TB_ID.Value = Convert.ToString(valObj.M_TB_ID);//Convert.ToInt32
txtSORT_NO.Value = Convert.ToString(valObj.SORT_NO);//Convert.ToInt32
txtTB_TYPE.Value = valObj.TB_TYPE.ToString();
txtNOTE.Value = Convert.ToString(valObj.NOTE);//Convert.ToString
TF_FORM useTB = new TF_FORM();
useTB.Where("TB_ID=" + keyid + " or TB_IDS like '%," + keyid + ",%'");
if (BLLTable<TF_FORM>.Exists(useTB))
{
txtTB_NAME.Disabled = true;
txtTB_TYPE.Disabled = true;
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
TF_FORM valObj = new TF_FORM();
if (txtFORM_ID.Value != "")
{
valObj.FORM_ID = Convert.ToInt32(txtFORM_ID.Value);
}
if (txtF_NAME.Value != "")
{
valObj.F_NAME = txtF_NAME.Value;
}
if (txtTB_ID.Value != "")
{
valObj.TB_ID = Convert.ToInt32(hidTB_ID.Value);
}
valObj.TPL_EDIT = txtTPL_EDIT.Value;
valObj.TPL_SHOW = txtTPL_SHOW.Value;
valObj.TPL_PRINT = txtTPL_PRINT.Value;
valObj.TPL_LIST = txtTPL_LIST.Value;
if (keyid != "")
{
valObj.FORM_ID = Convert.ToInt32(keyid);
count = BLLTable <TF_FORM> .Factory(conn).Update(valObj, TF_FORM.Attribute.FORM_ID);
}
else
{
valObj.M_FORM_ID = pid;
count = BLLTable <TF_FORM> .Factory(conn).Insert(valObj, TF_FORM.Attribute.FORM_ID);
keyid = valObj.FORM_ID.ToString();
if (count > 0)
{
#region//自动插入默认表单栏目
TF_TB_FIELD cond = new TF_TB_FIELD();
cond.TB_ID = valObj.TB_ID;
//cond.In(TF_TB_FIELD.Attribute.TB_ID, valObj.TB_ID + ",0");
List <TF_TB_FIELD> lstField = BLLTable <TF_TB_FIELD> .Factory(conn).Select(new TF_TB_FIELD(), cond);
if (lstField != null)
{
TF_F_COLUMN valCol = new TF_F_COLUMN();
valCol.TB_ID = valObj.TB_ID;
valCol.FORM_ID = valObj.FORM_ID;
lstField.ForEach(f =>
{
valCol.FIELD_ID = f.FIELD_ID;
valCol.SHOW_NAME = f.NOTE;
valCol.CTRL_TYPE = f.CTRL_TYPE;
valCol.SHOWIN_FORM = "1";
valCol.MAX_VAL = 0;
if (f.TB_ID == 0)
{
valCol.IS_DEFAULT = "1";
}
else
{
valCol.IS_DEFAULT = "0";
}
valCol.MIN_VAL = 0;
valCol.IS_NEED = f.IS_NULL == 1 ? 0 : 1;
valCol.SORT_NO = f.SORT_NO;
int aaa = BLLTable <TF_F_COLUMN> .Factory(conn).Insert(valCol, TF_F_COLUMN.Attribute.COLUMN_ID);
if (aaa > 0)
{
BLLTable <TF_TB_FIELD> .Factory(conn).Update(TF_TB_FIELD.Attribute.FIELD_ID, f.FIELD_ID,
TF_TB_FIELD.Attribute.CREATED, 1);
}
});
}
#endregion
List <TF_TABLE> lstMX = BLLTable <TF_TABLE> .Factory(conn).Select(TF_TABLE.Attribute.M_TB_ID, valObj.TB_ID);
if (lstMX != null && lstMX.Count > 0)
{
lstMX.ForEach(tb =>
{
TF_FORM valMX = new TF_FORM();
valMX.F_NAME = tb.CH_NAME;
valMX.TB_ID = Convert.ToInt32(tb.TB_ID);
valMX.TPL_EDIT = "";
valMX.TPL_SHOW = "";
valMX.TPL_PRINT = "";
valMX.TPL_LIST = "";
valMX.M_FORM_ID = valObj.FORM_ID;
int addmx = BLLTable <TF_FORM> .Factory(conn).Insert(valMX, TF_FORM.Attribute.FORM_ID);
#region//自动插入默认表单栏目
TF_TB_FIELD condFFF = new TF_TB_FIELD();
//condFFF.In(TF_TB_FIELD.Attribute.TB_ID, valMX.TB_ID + ",0");
condFFF.TB_ID = valMX.TB_ID;
lstField = BLLTable <TF_TB_FIELD> .Factory(conn).Select(new TF_TB_FIELD(), condFFF);
if (lstField != null)
{
TF_F_COLUMN valCol = new TF_F_COLUMN();
valCol.TB_ID = valMX.TB_ID;
valCol.FORM_ID = valMX.FORM_ID;
lstField.ForEach(f =>
{
valCol.FIELD_ID = f.FIELD_ID;
valCol.SHOW_NAME = f.NOTE;
valCol.CTRL_TYPE = f.CTRL_TYPE;
valCol.SHOWIN_FORM = "1";
valCol.MAX_VAL = 0;
if (f.TB_ID == 0)
{
valCol.IS_DEFAULT = "1";
}
else
{
valCol.IS_DEFAULT = "0";
}
valCol.MIN_VAL = 0;
valCol.IS_NEED = f.IS_NULL == 1 ? 0 : 1;
valCol.SORT_NO = f.SORT_NO;
int aaa = BLLTable <TF_F_COLUMN> .Factory(conn).Insert(valCol, TF_F_COLUMN.Attribute.COLUMN_ID);
if (aaa > 0)
{
BLLTable <TF_TB_FIELD> .Factory(conn).Update(TF_TB_FIELD.Attribute.FIELD_ID, f.FIELD_ID,
TF_TB_FIELD.Attribute.CREATED, 1);
}
});
}
#endregion
});
}
}
}
if (count > 0)
{
StringBuilder sbData = new StringBuilder("({valObj:''");
List <AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("})");
Button btn = (Button)sender;
if (btn.ID == "btnOK")
{
if (Request["tree"] != null)
{
string gotoUrl = "../../../ok.aspx";
StringBuilder sb = new StringBuilder("{");
sb.Append("id:'");
sb.Append(keyid).Append("',pid:'").Append("0").Append("',no:").Append(valObj.FORM_ID).Append(",sc:1,name:'");
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)
{
////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 + "\"}");
}
private void BindList(TF_FORM condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
condObj.af_PageBy(TF_FORM.Attribute.FORM_ID, Order.Desc);
#region//����Ȩ������
#endregion
//condObj.PID = decimal.Parse(pid);
listObj = BLLTable<TF_FORM>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
