protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new TF_TABLE();
if (txtTB_ID.Value != "")
{
condObj.Like_OR(TF_TABLE.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value));
}
if (txtTB_NAME.Value != "")
{
condObj.Like_OR(TF_TABLE.Attribute.TB_NAME, Convert.ToString(txtTB_NAME.Value));
}
if (txtCH_NAME.Value != "")
{
condObj.Like_OR(TF_TABLE.Attribute.CH_NAME, Convert.ToString(txtCH_NAME.Value));
}
if (txtM_TB_ID.Value != "")
{
condObj.Like_OR(TF_TABLE.Attribute.M_TB_ID, Convert.ToInt32(txtM_TB_ID.Value));
}
if (txtSORT_NO.Value != "")
{
condObj.Like_OR(TF_TABLE.Attribute.SORT_NO, Convert.ToInt32(txtSORT_NO.Value));
}
if (txtTB_TYPE.Value != "")
{
condObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);
}
if (txtNOTE.Value != "")
{
condObj.Like_OR(TF_TABLE.Attribute.NOTE, Convert.ToString(txtNOTE.Value));
}
try
{
hidCondition.Value = condObj.ToJson(20);
listObj = BLLTable <TF_TABLE> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repList.DataSource = listObj;
repList.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void btnFind_Click(object sender, EventArgs e)
{
try
{
condObj = new TF_TABLE();
if (txtTB_NAME.Value != "")
{
condObj.Like(TF_TABLE.Attribute.TB_NAME, Convert.ToString(txtTB_NAME.Value));
}
if (txtCH_NAME.Value != "")
{
condObj.Like(TF_TABLE.Attribute.CH_NAME, Convert.ToString(txtCH_NAME.Value));
}
if (txtTB_TYPE.Value != "")
{
condObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);
}
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)
{
condObj = new TF_TABLE();
if(txtTB_ID.Value !="" )
condObj.Like(TF_TABLE.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value));
if(txtTB_NAME.Value !="" )
condObj.Like(TF_TABLE.Attribute.TB_NAME, Convert.ToString(txtTB_NAME.Value));
if(txtCH_NAME.Value !="" )
condObj.Like(TF_TABLE.Attribute.CH_NAME, Convert.ToString(txtCH_NAME.Value));
if(txtM_TB_ID.Value !="" )
condObj.Like(TF_TABLE.Attribute.M_TB_ID, Convert.ToInt32(txtM_TB_ID.Value));
if(txtSORT_NO.Value !="" )
condObj.Like(TF_TABLE.Attribute.SORT_NO, Convert.ToInt32(txtSORT_NO.Value));
if(txtTB_TYPE.Value !="" )
condObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);
if(txtNOTE.Value !="" )
condObj.Like(TF_TABLE.Attribute.NOTE, Convert.ToString(txtNOTE.Value));
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
protected void btnFind_Click(object sender, EventArgs e)
{
try
{
condObj = new TF_TABLE();
if(txtTB_NAME.Value !="" )
condObj.Like(TF_TABLE.Attribute.TB_NAME, Convert.ToString(txtTB_NAME.Value));
if(txtCH_NAME.Value !="" )
condObj.Like(TF_TABLE.Attribute.CH_NAME, Convert.ToString(txtCH_NAME.Value));
if(txtTB_TYPE.Value !="" )
condObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);
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;
}
private void BindList(TF_TABLE condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
{
condObj.af_PageBy(TF_TABLE.Attribute.TB_ID, Order.Desc);
}
#region//数据权限条件
#endregion
//condObj.PID = decimal.Parse(pid);
listObj = BLLTable <TF_TABLE> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
head_TB_ID.Visible = false;
foreach (RepeaterItem item in repList.Items)
{
Label lblid = item.FindControl("lid") as Label;
Repeater rp = item.FindControl("repx") as Repeater;
//rp.DataSource = listObj;
//rp.DataBind();
//DataTable dt2 = bll.GetList(0, "Classid=" + lblid.Text + "", "SortId asc").Tables[0];
//if (dt2.Rows.Count != 0)
//{
// rp.DataSource = dt2;
// rp.DataBind();
//}
}
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<TF_TABLE>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <TF_TABLE>(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_TABLE>(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_TABLE>(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["TB_ID"]) || !string.IsNullOrEmpty(Request["ID"]))
{
string tbid = Request["TB_ID"];
if (!string.IsNullOrEmpty(Request["ID"]))
tbid = Request["ID"];
valObj = BLLTable<TF_TABLE>.Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, tbid);
if(valObj==null) return ;
txtTB_ID.Text = Convert.ToString(valObj.TB_ID);//Convert.ToInt32
txtTB_NAME.Text = Convert.ToString(valObj.TB_NAME);//Convert.ToString
txtCH_NAME.Text = Convert.ToString(valObj.CH_NAME);//Convert.ToString
txtM_TB_ID.Text = Convert.ToString(valObj.M_TB_ID);//Convert.ToInt32
txtSORT_NO.Text = Convert.ToString(valObj.SORT_NO);//Convert.ToInt32
txtTB_TYPE.Text=valObj.TB_TYPE.ToString();
txtNOTE.Text = Convert.ToString(valObj.NOTE);//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>
/// 表id为条件的相关对象 取得所有相关对象 的所有表
/// </summary>
/// <param name="conn"></param>
/// <param name="cond"></param>
/// <returns></returns>
public List <TF_TABLE> GetRelationTable(TF_TABLE cond)
{
TF_TABLE val1 = new TF_TABLE();
TF_TABLE val2 = new TF_TABLE();
List <Relation> relationlist = new List <Relation>();
relationlist.Add(RelationFactory.TF_TABLE_TF_TABLE);
List <TF_TABLE> list1 = BLLTable <TF_TABLE> .Factory(conn).Select(val1, RelationFactory.TF_TABLE_TF_TABLE, val2, cond);
return(list1);
}
protected void Page_Load(object sender, EventArgs e)
{
//在列表里点击删除按钮，通过AJAX执行这里的后台代码，删除一条记录
if (Request["DelTB_ID"] != null)
{
int re = BLLTable <TF_TABLE> .Factory(conn).Delete(TF_TABLE.Attribute.TB_ID, Request["DelTB_ID"]);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在列表顶部点击删除按钮，通过AJAX执行这里的后台代码，删除多条记录
if (Request["DelKeyIDS"] != null)
{
TF_TABLE cond = new TF_TABLE();
cond.In(TF_TABLE.Attribute.TB_ID, Request["DelKeyIDS"]);
int re = BLLTable <TF_TABLE> .Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在用户详细信息查看编辑页面，点保存时，通过AJAX执行这里的后台代码，实现部门字段的更新
if (Request["saveInfo"] != null)
{
TF_TABLE val = new TF_TABLE();
val.TB_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_TABLE> .Factory(conn).Update(val, TF_TABLE.Attribute.TB_ID);
Response.Write("修改信息成功");
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
#region//默认隐藏的列
//hideTableColumnList = new List<AttributeItem>();
//hideTableColumnList.Add(TF_TABLE.Attribute.EXP1);
//hideTableColumnList.Add(TF_TABLE.Attribute.EXP2);
//hideTableColumnList.Add(TF_TABLE.Attribute.EXP3);
//valObj.LoadAllAttributes(true);//暂时加此代码，以后框架更新将不需要
//valObj.Remove(hideTableColumnList);
//hideFindColumnList = new List<AttributeItem>();
//hideFindColumnList.Add(TF_TABLE.Attribute.EXP1);
//hideFindColumnList.Add(TF_TABLE.Attribute.EXP2);
//hideFindColumnList.Add(TF_TABLE.Attribute.EXP3);
#endregion
condObj.OrderBy(TF_TABLE.Attribute.TB_ID, Order.Desc);
if (!IsPostBack)
{
btnFind.Text = LanguageService.GetLanguageString("btnFind", "查询");
aspPager.PageSize = 10;
aspPager.CurrentPageIndex = 1;
if (!string.IsNullOrEmpty(Request["ids"]))
{
TF_TABLE roleOld = new TF_TABLE();
roleOld.Where(TF_TABLE.Attribute.TB_ID, Request["ids"].ToString());
listObj = BLLTable <TF_TABLE> .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].TB_ID + "',Name:'" + listObj[i].TB_ID + "'}";//这里的Name用于显示在列表中，请自行重定义。
hidInitIDS.Value += listObj[i].TB_ID;
}
}
try
{
listObj = BLLTable <TF_TABLE> .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;
}
}
}
public string GengerateHtml(string template, TF_TABLE valObj, TF_TABLE condObj)
{
// 生成列表页
Match mRepeat = regRepeat.Match(template);
while (mRepeat.Success)
{
// 替换Repeat控件
template = template.Replace(mRepeat.Value, GengerateRepeat2(mRepeat.Value));
mRepeat = mRepeat.NextMatch();
}
return(template);
}
protected void Page_Load(object sender, EventArgs e)
{
//���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼
if (Request["DelTB_ID"] != null)
{
int re = BLLTable<TF_TABLE>.Factory(conn).Delete(TF_TABLE.Attribute.TB_ID, Request["DelTB_ID"]);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼
if (Request["DelKeyIDS"] != null)
{
TF_TABLE cond = new TF_TABLE();
cond.In(TF_TABLE.Attribute.TB_ID, Request["DelKeyIDS"]);
int re = BLLTable<TF_TABLE>.Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ���
if (Request["saveInfo"] != null)
{
TF_TABLE val = new TF_TABLE();
val.TB_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_TABLE>.Factory(conn).Update(val, TF_TABLE.Attribute.TB_ID);
Response.Write("���û���Ϣ�ɹ�");
}
Response.End();
}
protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new TF_TABLE();
if (txtTB_ID.Value != "")
{
condObj.Like(TF_TABLE.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value));
}
if (txtTB_NAME.Value != "")
{
condObj.Like(TF_TABLE.Attribute.TB_NAME, Convert.ToString(txtTB_NAME.Value));
}
if (txtCH_NAME.Value != "")
{
condObj.Like(TF_TABLE.Attribute.CH_NAME, Convert.ToString(txtCH_NAME.Value));
}
if (txtM_TB_ID.Value != "")
{
condObj.Like(TF_TABLE.Attribute.M_TB_ID, Convert.ToInt32(txtM_TB_ID.Value));
}
if (txtSORT_NO.Value != "")
{
condObj.Like(TF_TABLE.Attribute.SORT_NO, Convert.ToInt32(txtSORT_NO.Value));
}
if (txtTB_TYPE.Value != "")
{
condObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);
}
if (txtNOTE.Value != "")
{
condObj.Like(TF_TABLE.Attribute.NOTE, Convert.ToString(txtNOTE.Value));
}
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
/// <summary>
/// 创建表
/// </summary>
public int AddTableWithDefaultCols(TF_TABLE tbObj, string sourceTable, string sourceConn, ref string errMsg)
{
string tbname = tbObj.TB_NAME;
DataBaseTable tb1 = null;
if (!DataBase.Factory(conn).TryGetValue(tbname, out tb1))//如果表不存在，则新建表，带默认字段
{
DataBaseTable tb2 = null;
if (tbObj.M_TB_ID > 0)
{
//if (!DataBase.Factory(conn).Master().TryGetValue("GROUP_WF_MX", out tb2))
// return 0;
if (!DataBase.Factory(conn).Master().TryGetValue("af_GROUP_WF_MX_2014", out tb2))
{
return(0);
}
}
else
{
//if (!DataBase.Factory(conn).Master().TryGetValue("GROUP_WF", out tb2))
// return 0;
if (!DataBase.Factory(conn).Master().TryGetValue("af_GROUP_WF_2014", out tb2))
{
return(0);
}
}
DataBaseTable tb3 = new DataBaseTable(tbname, tb2);
DataBaseTable tbsource = null;
if (!string.IsNullOrEmpty(sourceTable) && DataBase.Factory(sourceConn).TryGetValue(sourceTable, out tbsource))
{
foreach (DataBaseField f2 in tbsource.DataFields)
{
tb3.DataFields.Add(f2);
}
}
if (DataBase.Factory(conn).AddTable(tb3, ref errMsg))
{
return(1);
}
else
{
return(0);
}
}
//else
//{
// SaveToTF_TB_FIELD(tbObj, ref errMsg);
//}
return(1);
}
private void BindList(TF_TABLE condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
{
condObj.af_PageBy(TF_TABLE.Attribute.TB_ID, Order.Desc);
}
#region//数据权限条件
#endregion
//condObj.PID = decimal.Parse(pid);
listObj = BLLTable <TF_TABLE> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
try
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <TF_TABLE>(hidCondition.Value);
}
listObj = BLLTable <TF_TABLE> .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_TABLE>(hidCondition.Value);
}
List<TF_TABLE> listVal = BLLTable<TF_TABLE>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount);
repList.DataSource = listVal;
repList.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
/// <summary>
/// 编辑表 2 为建表成功，无需改名，1为存在旧表，-1为异常。
/// </summary>
public int EditTable(string oldname, TF_TABLE tbObj, ref string errMsg)
{
int ret = 0;
try
{
string newname = tbObj.TB_NAME;
if (oldname == newname)
{
return(2);
}
//修改正式表字段名称或类型
DataBaseTable oldt1 = null;
DataBaseTable newt1 = null;
bool oldExist = DataBase.Factory(conn).TryGetValue(oldname, out oldt1);
errMsg = "被修改的表不存在";
if (!oldExist)
{
return(0);
}
bool newExist = DataBase.Factory(conn).TryGetValue(tbObj.TB_NAME, out newt1);
errMsg = "新表名已被其他用户使用，请重新命名";
if (newExist)
{
return(0);
}
if (oldt1.ChangeName(newname))
{
return(1);
}
else
{
return(0);
}
}
catch (Exception ex)
{
errMsg = ex.ToString();
return(-1);
}
return(ret);
}
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 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 (!IsPostBack)
{
//txtTB_TYPE.Items.AddRange(FormHelper.GetListItem(TF_TABLE.Attribute.TB_TYPE));
//this.txtTB_ID.Disabled = true; this.txtTB_ID.Value = "0";
//this.txtTB_ID.Attributes["class"] = "dis";
try
{
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
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new TF_TABLE();
if(txtTB_ID.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value));
if(txtTB_NAME.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.TB_NAME, Convert.ToString(txtTB_NAME.Value));
if(txtCH_NAME.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.CH_NAME, Convert.ToString(txtCH_NAME.Value));
if(txtM_TB_ID.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.M_TB_ID, Convert.ToInt32(txtM_TB_ID.Value));
if(txtSORT_NO.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.SORT_NO, Convert.ToInt32(txtSORT_NO.Value));
if(txtTB_TYPE.Value !="" )
condObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);
if(txtNOTE.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.NOTE, Convert.ToString(txtNOTE.Value));
try
{
hidCondition.Value = condObj.ToJson(20);
listObj = BLLTable<TF_TABLE>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repList.DataSource = listObj;
repList.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
/// <summary>
/// 表id为条件的相关对象 取得所有相关对象 的所有表
/// </summary>
/// <param name="conn"></param>
/// <param name="cond"></param>
/// <returns></returns>
public List<TF_TABLE> GetRelationTable(TF_TABLE cond)
{
TF_TABLE val1 = new TF_TABLE();
TF_TABLE val2 = new TF_TABLE();
List<Relation> relationlist = new List<Relation>();
relationlist.Add(RelationFactory.TF_TABLE_TF_TABLE);
List<TF_TABLE> list1 = BLLTable<TF_TABLE>.Factory(conn).Select(val1, RelationFactory.TF_TABLE_TF_TABLE, val2, cond);
return list1;
}
public string DetailHtml(string template, TF_TABLE valObj, TF_TABLE condObj)
{
StringBuilder sb = new StringBuilder();
List <string> types = new List <string>();
List <int> heads = new List <int>();
List <int> ends = new List <int>();
List <string> templateStatic = new List <string>();
List <string> innerTemplateList = new List <string>();
//对全局进行解析，循环外
Parse(template, "Repeat", ref types, ref heads, ref ends, ref templateStatic, ref innerTemplateList);
if (heads.Count == 0)
{
return(template);
}
int head = heads[0];
int end = ends[0];
sb.Append(template.Substring(0, heads[0]));
for (int i = 0; i < heads.Count; i++)
{
end = ends[i];
if (i > 0)
{
sb.Append(template.Substring(end, head));
}
head = heads[i];
string oneTable = innerTemplateList[i];
//对oneTable进行解析
List <AttributeItem> listObj = valObj.af_GetAttributes();
for (int j = 0; j < listObj.Count; j++)
{
AttributeItem attr = listObj[j];
List <string> types1 = new List <string>();
List <int> heads1 = new List <int>();
List <int> ends1 = new List <int>();
List <string> oneTables1 = new List <string>();
List <string> templateStatic1 = new List <string>();
List <string> innerTemplateList1 = new List <string>();
Parse(template, "Switch", ref types1, ref heads1, ref ends1, ref templateStatic1, ref innerTemplateList1);
List <string> types2 = new List <string>();
List <int> heads2 = new List <int>();
List <int> ends2 = new List <int>();
List <string> oneTables2 = new List <string>();
List <string> templateStatic2 = new List <string>();
List <string> innerTemplateList2 = new List <string>();
Parse(innerTemplateList1[0], "Case", ref types2, ref heads2, ref ends2, ref templateStatic2, ref innerTemplateList2);
string oneField1 = getCtrlHtml(attr.FieldAnotherName);
//
sb.Append(oneField1);
}
sb.Append(oneTable);
}
return(sb.ToString());
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
#region 输入参数：数据模型、采用此布局模型展示
if (Request["ModuleType"] != null)
{
string ModuleType = "";
if (Request["ModuleType"] != null)
{
ModuleType = Convert.ToString(Request["ModuleType"]);
}
//是模块，则设置 取值、条件对象 等。
if (ModuleType == "TF_TABLE")
{
msg = "未制定表名";
string ModuleTbName = Convert.ToString(Request["moduleName"]);
if (string.IsNullOrEmpty(ModuleTbName))
{
Response.Write(msg);
Response.End();
}
TF_TABLE condObj1 = new TF_TABLE();
condObj1.TB_NAME = ModuleTbName;
SetRequest(condObj1);
bool ret1 = AgileFrame.Common.TF_TABLEHelper.Factory(conn).Parse(condObj1, out valObj, out condObj, out relationList,
out otherValueList, out condList, ref msg);//获取数据域(不是显示域)
msg = "制定模块的数据模型未存在，请安装此模块";
if (!ret1)
{
Response.Write(msg);
Response.End();
}
//设置条件对象
SetRequest(condObj);
SetRequest(condList);
}
}
else
{
valObj = new ITableImplementHelper(conn).Factory("TF_TABLE");
condObj = new ITableImplementHelper(conn).Factory("TF_TABLE"); //(ITableImplement)valObj.Clone();//
}
#endregion
title = valObj._ZhName + "管理";
Page.Title = title;
if (Request["PID"] != null)
{
pid = Request["PID"];
}
if (Request["submit"] != null)
{
}
if (!IsPostBack)
{
#region //默认属性初始化
aspPager.CurrentPageIndex = 1;
aspPager.ShowInputBox = AgileFrame.Core.WebSystem.ShowInputBox.Auto; //.WebCtrls
//txtPageSize.Value = "2";
aspPager.PageSize = 30;
//if (pid == "" || pid == "0")
//{
// a_top.Visible = false;
//}
#endregion
#region//条件
BindCondition();
#endregion
#region//数据初始化
//txtTB_TYPE.Items.AddRange(FormHelper.GetListItem(TF_TABLE.Attribute.TB_TYPE));
#endregion
BindList(1);
}
//Lit_ToolLeftButton;
}
catch (Exception ex)
{
HandleError(ex);
}
}
/// <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_TABLE valObj = new TF_TABLE();
//if(txtTB_ID.Value !="" )
// valObj.TB_ID = Convert.ToInt32(txtTB_ID.Value);
if (keyid != "")
{
valObj.TB_ID = Convert.ToInt32(keyid);
count = BLLTable<TF_TABLE>.Factory(conn).Update(valObj, TF_TABLE.Attribute.TB_ID);
}
else
{
count = BLLTable<TF_TABLE>.Factory(conn).Insert(valObj, TF_TABLE.Attribute.TB_ID);
keyid = valObj.TB_ID.ToString();
}
if (count > 0)
{
StringBuilder sbData = new StringBuilder("{valObj:''");
List<AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("}");
if (ViewState["sbData"] == null)
{
ViewState["sbData"] = sbData.ToString();
}
else {
ViewState["sbData"] += ","+sbData.ToString();
}
Button btn = (Button)sender;
if (btn.ID.IndexOf("btnOK")!=-1)
{
if (ViewState["sbData"] == null)
{
string dataStr = "[" + ViewState["sbData"] .ToString()+ "]";
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + dataStr + "';}else{window.returnValue = '" + dataStr + "';}window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true);
}
}
else
{
//txtTB_ID.Value ="";
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
public string GengerateHtml(string template, TF_TABLE valObj, TF_TABLE condObj)
{
// 生成列表页
Match mRepeat = regRepeat.Match(template);
while (mRepeat.Success)
{
// 替换Repeat控件
template = template.Replace(mRepeat.Value, GengerateRepeat2(mRepeat.Value));
mRepeat = mRepeat.NextMatch();
}
return template;
}
/// <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);
}
private void BindList(TF_TABLE condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
condObj.af_PageBy(TF_TABLE.Attribute.TB_ID, Order.Desc);
#region//����Ȩ������
#endregion
//condObj.PID = decimal.Parse(pid);
listObj = BLLTable<TF_TABLE>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new TF_TABLE();
if(txtTB_ID.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value));
if(txtTB_NAME.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.TB_NAME, Convert.ToString(txtTB_NAME.Value));
if(txtWF_TB_NAME.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.WF_TB_NAME, Convert.ToString(txtWF_TB_NAME.Value));
if(txtCH_NAME.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.CH_NAME, Convert.ToString(txtCH_NAME.Value));
if(txtM_TB_ID.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.M_TB_ID, Convert.ToInt32(txtM_TB_ID.Value));
if(txtSORT_NO.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.SORT_NO, Convert.ToInt32(txtSORT_NO.Value));
if(txtTB_TYPE.Value !="" )
condObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);
if(txtNOTE.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.NOTE, Convert.ToString(txtNOTE.Value));
if(txtCREATED.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.CREATED, Convert.ToInt32(txtCREATED.Value));
if(txtDB_SRC.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.DB_SRC, Convert.ToString(txtDB_SRC.Value));
if(txtMENU_NAME.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.MENU_NAME, Convert.ToString(txtMENU_NAME.Value));
if(txtKEY_NAME.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.KEY_NAME, Convert.ToString(txtKEY_NAME.Value));
if(txtKEY_TYPE.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.KEY_TYPE, Convert.ToString(txtKEY_TYPE.Value));
if(txtAPI_NAME.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.API_NAME, Convert.ToString(txtAPI_NAME.Value));
if(txtALLOW_REPORT.Value !="" )
condObj.ALLOW_REPORT = Convert.ToBoolean(txtALLOW_REPORT.Checked);
if(txtALLOW_ACTIVITY.Value !="" )
condObj.ALLOW_ACTIVITY = Convert.ToBoolean(txtALLOW_ACTIVITY.Checked);
if(txtMODIFY_HIS.Value !="" )
condObj.MODIFY_HIS = Convert.ToBoolean(txtMODIFY_HIS.Checked);
if(txtALLOW_USER_AREA.Value !="" )
condObj.ALLOW_USER_AREA = Convert.ToBoolean(txtALLOW_USER_AREA.Checked);
if(txtALLOW_PUBLIC.Value !="" )
condObj.ALLOW_PUBLIC = Convert.ToBoolean(txtALLOW_PUBLIC.Checked);
if(txtTB_NAMESPACE.Value !="" )
condObj.Like_OR(TF_TABLE.Attribute.TB_NAMESPACE, Convert.ToString(txtTB_NAMESPACE.Value));
if(txtINSTALL_STAT.Value !="" )
condObj.INSTALL_STAT = Convert.ToBoolean(txtINSTALL_STAT.Checked);
if(txtADD_NOTE_FILE.Value !="" )
condObj.ADD_NOTE_FILE = Convert.ToBoolean(txtADD_NOTE_FILE.Checked);
if(txtHAS_WF.Value !="" )
condObj.HAS_WF = Convert.ToBoolean(txtHAS_WF.Checked);
try
{
hidCondition.Value = condObj.ToJson(20);
listObj = BLLTable<TF_TABLE>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repList.DataSource = listObj;
repList.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
TF_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;
}
}
public int SaveToTF_TB_FIELD(TF_TABLE tbObj, ref string errMsg)
{
return(SaveToTF_TB_FIELD(tbObj.TB_NAME, tbObj.TB_ID, ref errMsg));
}
private void BindList(TF_TABLE condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
condObj.af_PageBy(TF_TABLE.Attribute.TB_ID, Order.Desc);
#region//����Ȩ������
#endregion
//condObj.PID = decimal.Parse(pid);
listObj = BLLTable<TF_TABLE>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
head_TB_ID.Visible = false;
foreach (RepeaterItem item in repList.Items)
{
Label lblid = item.FindControl("lid") as Label;
Repeater rp = item.FindControl("repx") as Repeater;
//rp.DataSource = listObj;
//rp.DataBind();
//DataTable dt2 = bll.GetList(0, "Classid=" + lblid.Text + "", "SortId asc").Tables[0];
//if (dt2.Rows.Count != 0)
//{
// rp.DataSource = dt2;
// rp.DataBind();
//}
}
}
/// <summary>
/// TF_FORM 从配置中获得表单布局
/// </summary>
/// <param name="conn"></param>
/// <param name="cond"></param>
/// <returns></returns>
public bool Parse(TF_TABLE cond,
out ITableImplement valObj, out ITableImplement condObj, out List<Relation> relationList, out List<ITableImplement> otherValueList,
out List<ITableImplement> condList, ref string msg)
{
valObj = new ITableImplement();
condObj = new ITableImplement();
//载入关系
otherValueList = new List<ITableImplement>();
condList = new List<ITableImplement>();
relationList = new List<Relation>();
msg = "条件不存在";
if (string.IsNullOrEmpty(cond.TB_NAME))
return false;
DataBaseTable tb1;
List<DataBaseField> listf1 = new List<DataBaseField>();
List<DataBaseTable> listTb1 = new List<DataBaseTable>();
bool ret = true; tb1 = null;
//TF_TABLE val = BLLTable<TF_TABLE>.Factory(conn).GetRowData(new TF_TABLE(), cond);
TF_TB_FIELD val1 = new TF_TB_FIELD();
TF_F_COLUMN val2 = new TF_F_COLUMN();
TF_TABLE val3 = new TF_TABLE();
TF_TB_FIELD cond1 = new TF_TB_FIELD();
TF_F_COLUMN cond2 = new TF_F_COLUMN();
TF_FORM cond3 = new TF_FORM();
List<ITableImplement> otherValueList1 = new List<ITableImplement>();
List<ITableImplement> condList1 = new List<ITableImplement>();
otherValueList1.Add(val2); otherValueList1.Add(val3);
condList1.Add(cond);
List<Relation> relationList1 = new List<Relation>();
relationList1.Add(RelationFactory.TF_TABLE_TF_FORM);
relationList1.Add(RelationFactory.TF_TABLE_TF_TB_FIELD);
relationList1.Add(RelationFactory.TF_TB_FIELD_TF_F_COLUMN);
int pageSize = 100;
int pageIndex = 1;
int recount = -1;
string cachekey = null;
List<TF_TB_FIELD> list1 = BLLTable<TF_TB_FIELD>.Factory(conn).SelectByPage(val1, relationList1, otherValueList1, condList1,
pageSize, pageIndex, ref recount, out cachekey);
if (list1.Count == 0)
{
DataBaseTable dt1 = null;
dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[cond.TB_NAME];
msg = cond.TB_NAME + " 数据表不存在";
if (dt1 == null)
{
ret = false;
ConsoleService.Warn(msg);
}
return ret;
}
if (list1.Count > 90)
{
msg = "条件错误，所配置的字段记录超过90";
return false;
}
//生成布局模版用
tb1 = new DataBaseTable();
foreach (TF_TB_FIELD item in list1)
{
string tbName = Convert.ToString(item.GetValue(TF_TABLE.Attribute.TB_NAME)).ToLower();
#region 表操作
DataBaseTable dt1 = null;
dt1 = Runtime_PersistenceLayer.Factory(conn).DataBase.DataTables[tbName];
msg = tbName + " 数据表不存在"; ret = false;
if (dt1 == null)
{
ConsoleService.Warn(msg);
return ret;
}
tb1 = dt1;
listTb1.Add(dt1);
//是否显示
object obj1 = null;
object obj2 = null;
object obj3 = null;
if (item.TryGetValue(TF_FORM.Attribute.FORM_ID, out obj1))
{
dt1.IsVisable = true;
}
#endregion
string fieldName = item.FIELD_NAME.ToLower();
#region 列操作
DataBaseField f1 = null;
msg = string.Format("数据表{0},数据字段{1}不存在", tbName, fieldName);
if (!dt1.DataFields.TryGetValue(fieldName, out f1))
{
ret = false;
ConsoleService.Warn(msg);
continue;
}
//是否显示
obj1 = null; obj2 = null; obj3 = null;
if (item.TryGetValue(TF_F_COLUMN.Attribute.COLUMN_ID, out obj1)
&& item.TryGetValue(TF_F_COLUMN.Attribute.SHOW_NAME, out obj2)
&& item.TryGetValue(TF_F_COLUMN.Attribute.CTRL_TYPE, out obj3))
{
//f1.IsVisable = true;
}
#endregion
listf1.Add(f1);
}
//取值对象
valObj = ITableImplement.Factory(tb1);
//其他取值对象
foreach (DataBaseTable tb2 in listTb1)
{
if (tb2.TableName == tb1.TableName) continue;
otherValueList.Add(ITableImplement.Factory(tb2));
}
//关系呢
return ret;
}
/// <summary>
/// ���ձ��������ֶ�ͬ���� ���̱����¼
/// </summary>
protected void btnSyn_Click(object sender, EventArgs e)
{
string message = "";
tbid = int.Parse(Request["id"]);
tbObj = BLLTable<TF_TABLE>.Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, tbid);
if (tbObj == null)
{
return;
}
if (tbObj != null)
{
int count1 = TF_TABLEHelper.Factory(conn).SaveToTF_TB_FIELD(tbObj,ref message);
}
}
public int SaveToTF_TB_FIELD(TF_TABLE tbObj, ref string errMsg)
{
return SaveToTF_TB_FIELD(tbObj.TB_NAME, tbObj.TB_ID, ref errMsg);
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "����";
Page.Title = title;
tbid = int.Parse(Request["id"]);
tbObj = BLLTable<TF_TABLE>.Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, tbid);
if (tbObj == null)
{
return;
}
if (!IsPostBack)
{
dicCtrlType = TF_Common.GetCtrlTypeDic();
#region//Ĭ�����Գ�ʼ��
aspPager.CurrentPageIndex = 1;
aspPager.ShowInputBox = AgileFrame.Core.WebSystem.ShowInputBox.Auto;//WebCtrls.
aspPager.PageSize = 30;
#endregion
title = tbObj.CH_NAME;
#region//���ݳ�ʼ��
//txtFIELD_TYPE.Items.AddRange(FormHelper.GetListItem(TF_TB_FIELD.Attribute.FIELD_TYPE));
#endregion
if (Request["defaultfield"] != null) {
btnFind.Enabled = false;
// ulBtns.Visible = false;
}
BindList(condObj, 1);
// fangan.Columns.Add("*TableName");//����
//fangan.Columns.Add("UserId");//Ա�����
//fangan.Columns.Add("TYPE");
//fangan.Columns.Add("CheckOWA");//�������ͣ���١���١����ݡ����ٵ�
//fangan.Columns.Add("UnWorkStartTime");//����������ʼʱ��
//fangan.Columns.Add("UnWorkEndTime");//������������ʱ��
//fangan.Columns.Add("OnWorkStartTime");//����ʱ�俪ʼʱ��
//fangan.Columns.Add("OnWorkEndTime");//����ʱ�����ʱ��
string path = Server.MapPath("~" + CheckInOutHelper.CheckOnWorkAttendanceFangAnPath);
ViewState["TB_NAME"] = tbObj.TB_NAME;
DataTable dt = CheckInOutHelper.GetOneCheckOnWorkAttendanceFangAn(tbObj.TB_NAME);
if (dt.Rows.Count <= 0)
{
DataRow dr = dt.NewRow();
dr["*TableName"] = tbObj.TB_NAME;
dr["UserId"] = "STAFF_ID";
//dr["TYPE"] = "'"+tbObj.CH_NAME+"' as TYPE";
dr["CheckOWA"] = "";
dr["UnWorkStartTime"] = "";
dr["UnWorkEndTime"] = "";
dr["OnWorkStartTime"] = "";
dr["OnWorkEndTime"] = "";
dt.Rows.Add(dr);
}
repFangAn.DataSource = dt;
repFangAn.DataBind();
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
TF_TABLE valObj = new TF_TABLE();
if (txtTB_NAME.Value != "")
{
valObj.TB_NAME = txtTB_NAME_PRE.Value + txtTB_NAME.Value;
}
if (ViewState["OLDNAME"].ToString() != txtTB_NAME.Value)
{
if (BLLTable <TF_TABLE> .Exists(valObj))
{
litWarn.Text = "该表已经存在，请重新输入！";
return;
}
}
if (txtTB_ID.Value != "")
{
valObj.TB_ID = Convert.ToInt32(txtTB_ID.Value);
}
if (txtCH_NAME.Value != "")
{
valObj.CH_NAME = Convert.ToString(txtCH_NAME.Value);
}
//if (txtM_TB_ID.Value != "")
valObj.M_TB_ID = pid;
if (txtSORT_NO.Value != "")
{
valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value);
}
if (txtTB_TYPE.Value != "")
{
valObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);
}
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)
{
AgileFrame.Common.TF_TABLEHelper.Factory(conn).EditTable(ViewState["OLDNAME"].ToString(), valObj, ref errMsg);
}
}
else
{
valObj.CREATED = AgileFrame.Common.TF_TABLEHelper.Factory(conn).AddTableWithDefaultCols(valObj, "", "", ref errMsg);
count = BLLTable <TF_TABLE> .Factory(conn).Insert(valObj, TF_TABLE.Attribute.TB_ID);
keyid = valObj.TB_ID.ToString();
}
if (count > 0)
{
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.SORT_NO).Append(",sc:1,name:'");
if (valObj.M_TB_ID > 0)
{
sb.Append(valObj.CH_NAME).Append("',ntype:'table-mx'}");
}
else
{
sb.Append(valObj.CH_NAME).Append("',ntype:'table'}");
}
if (Request["edit"] == null)
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.showSubNodes(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
else
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.TV.editNodeInfo(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
}
else
{
StringBuilder sbData = new StringBuilder("({valObj:''");
List <AttributeItem> lstCol = valObj.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
object val = valObj.GetValue(lstCol[i]);
if (val != null)
{
sbData.Append(",").Append(lstCol[i].FieldName).Append(":'").Append(val.ToString()).Append("'");
}
}
sbData.Append("})");
Button btn = (Button)sender;
if (btn.ID.IndexOf("btnOK") != -1)
{
if (ViewState["hadSave"] == null)
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = '" + sbData.ToString() + "';}else{window.returnValue = '" + sbData.ToString() + "';}window.close();", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "if (window.opener){window.opener.returnValue = 're';}else{window.returnValue = 're';}window.close();", true);
}
}
else
{
txtTB_NAME.Value = "";
txtCH_NAME.Value = "";
txtNOTE.Value = "";
}
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
//try
//{
#region
TF_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;
//}
}
public string DetailHtml(string template, TF_TABLE valObj, TF_TABLE condObj)
{
StringBuilder sb = new StringBuilder();
List<string> types = new List<string>();
List<int> heads = new List<int>();
List<int> ends = new List<int>();
List<string> templateStatic = new List<string>();
List<string> innerTemplateList = new List<string>();
//对全局进行解析，循环外
Parse(template, "Repeat", ref types, ref heads, ref ends, ref templateStatic, ref innerTemplateList);
if (heads.Count == 0) return template;
int head = heads[0];
int end = ends[0];
sb.Append(template.Substring(0, heads[0]));
for (int i = 0; i < heads.Count; i++)
{
end = ends[i];
if (i > 0)
sb.Append(template.Substring(end, head));
head = heads[i];
string oneTable = innerTemplateList[i];
//对oneTable进行解析
List<AttributeItem> listObj = valObj.af_GetAttributes();
for (int j = 0; j < listObj.Count; j++)
{
AttributeItem attr = listObj[j];
List<string> types1 = new List<string>();
List<int> heads1 = new List<int>();
List<int> ends1 = new List<int>();
List<string> oneTables1 = new List<string>();
List<string> templateStatic1 = new List<string>();
List<string> innerTemplateList1 = new List<string>();
Parse(template, "Switch", ref types1, ref heads1, ref ends1, ref templateStatic1, ref innerTemplateList1);
List<string> types2 = new List<string>();
List<int> heads2 = new List<int>();
List<int> ends2 = new List<int>();
List<string> oneTables2 = new List<string>();
List<string> templateStatic2 = new List<string>();
List<string> innerTemplateList2 = new List<string>();
Parse(innerTemplateList1[0], "Case", ref types2, ref heads2, ref ends2, ref templateStatic2, ref innerTemplateList2);
string oneField1 = getCtrlHtml(attr.FieldAnotherName);
//
sb.Append(oneField1);
}
sb.Append(oneTable);
}
return sb.ToString();
}
protected void btnFind_Click(object sender, EventArgs e)
{
try
{
condObj = new TF_TABLE();
if (txtTB_ID.Value != "")
{
condObj.Like(TF_TABLE.Attribute.TB_ID, Convert.ToInt32(txtTB_ID.Value));
}
if (txtTB_NAME.Value != "")
{
condObj.Like(TF_TABLE.Attribute.TB_NAME, Convert.ToString(txtTB_NAME.Value));
}
if (txtWF_TB_NAME.Value != "")
{
condObj.Like(TF_TABLE.Attribute.WF_TB_NAME, Convert.ToString(txtWF_TB_NAME.Value));
}
if (txtCH_NAME.Value != "")
{
condObj.Like(TF_TABLE.Attribute.CH_NAME, Convert.ToString(txtCH_NAME.Value));
}
if (txtM_TB_ID.Value != "")
{
condObj.Like(TF_TABLE.Attribute.M_TB_ID, Convert.ToInt32(txtM_TB_ID.Value));
}
if (txtSORT_NO.Value != "")
{
condObj.Like(TF_TABLE.Attribute.SORT_NO, Convert.ToInt32(txtSORT_NO.Value));
}
if (txtTB_TYPE.Value != "")
{
condObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);
}
if (txtNOTE.Value != "")
{
condObj.Like(TF_TABLE.Attribute.NOTE, Convert.ToString(txtNOTE.Value));
}
if (txtCREATED.Value != "")
{
condObj.Like(TF_TABLE.Attribute.CREATED, Convert.ToInt32(txtCREATED.Value));
}
if (txtDB_SRC.Value != "")
{
condObj.Like(TF_TABLE.Attribute.DB_SRC, Convert.ToString(txtDB_SRC.Value));
}
if (txtMENU_NAME.Value != "")
{
condObj.Like(TF_TABLE.Attribute.MENU_NAME, Convert.ToString(txtMENU_NAME.Value));
}
if (txtKEY_NAME.Value != "")
{
condObj.Like(TF_TABLE.Attribute.KEY_NAME, Convert.ToString(txtKEY_NAME.Value));
}
if (txtKEY_TYPE.Value != "")
{
condObj.Like(TF_TABLE.Attribute.KEY_TYPE, Convert.ToString(txtKEY_TYPE.Value));
}
if (txtAPI_NAME.Value != "")
{
condObj.Like(TF_TABLE.Attribute.API_NAME, Convert.ToString(txtAPI_NAME.Value));
}
if (txtALLOW_REPORT.Value != "")
{
condObj.ALLOW_REPORT = Convert.ToBoolean(txtALLOW_REPORT.Checked);
}
if (txtALLOW_ACTIVITY.Value != "")
{
condObj.ALLOW_ACTIVITY = Convert.ToBoolean(txtALLOW_ACTIVITY.Checked);
}
if (txtMODIFY_HIS.Value != "")
{
condObj.MODIFY_HIS = Convert.ToBoolean(txtMODIFY_HIS.Checked);
}
if (txtALLOW_USER_AREA.Value != "")
{
condObj.ALLOW_USER_AREA = Convert.ToBoolean(txtALLOW_USER_AREA.Checked);
}
if (txtALLOW_PUBLIC.Value != "")
{
condObj.ALLOW_PUBLIC = Convert.ToBoolean(txtALLOW_PUBLIC.Checked);
}
if (txtTB_NAMESPACE.Value != "")
{
condObj.Like(TF_TABLE.Attribute.TB_NAMESPACE, Convert.ToString(txtTB_NAMESPACE.Value));
}
if (txtINSTALL_STAT.Value != "")
{
condObj.INSTALL_STAT = Convert.ToBoolean(txtINSTALL_STAT.Checked);
}
if (txtADD_NOTE_FILE.Value != "")
{
condObj.ADD_NOTE_FILE = Convert.ToBoolean(txtADD_NOTE_FILE.Checked);
}
if (txtHAS_WF.Value != "")
{
condObj.HAS_WF = Convert.ToBoolean(txtHAS_WF.Checked);
}
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 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 (!IsPostBack)
{
//txtTB_TYPE.Items.AddRange(FormHelper.GetListItem(TF_TABLE.Attribute.TB_TYPE));
//this.txtTB_ID.Disabled = true; this.txtTB_ID.Value = "0";
//this.txtTB_ID.Attributes["class"] = "dis";
try
{
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
}
}
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 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;
}
/// <summary>
/// 编辑表 2 为建表成功，无需改名，1为存在旧表，-1为异常。
/// </summary>
public int EditTable(string oldname, TF_TABLE tbObj, ref string errMsg)
{
int ret = 0;
try
{
string newname = tbObj.TB_NAME;
if (oldname == newname)
return 2;
//修改正式表字段名称或类型
DataBaseTable oldt1 = null;
DataBaseTable newt1 = null;
bool oldExist = DataBase.Factory(conn).TryGetValue(oldname, out oldt1);
errMsg = "被修改的表不存在";
if (!oldExist)
return 0;
bool newExist = DataBase.Factory(conn).TryGetValue(tbObj.TB_NAME, out newt1);
errMsg = "新表名已被其他用户使用，请重新命名";
if (newExist)
return 0;
if (oldt1.ChangeName(newname))
return 1;
else
return 0;
}
catch (Exception ex)
{
errMsg = ex.ToString();
return -1;
}
return ret;
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
TF_TABLE valObj = new TF_TABLE();
if (txtTB_NAME.Value != "")
valObj.TB_NAME = txtTB_NAME_PRE.Value + txtTB_NAME.Value;
if (ViewState["OLDNAME"].ToString() != txtTB_NAME.Value)
{
if (BLLTable<TF_TABLE>.Exists(valObj))
{
litWarn.Text = "�ñ��Ѿ����ڣ����������룡";
return;
}
}
if (txtTB_ID.Value != "")
valObj.TB_ID = Convert.ToInt32(txtTB_ID.Value);
if (txtCH_NAME.Value != "")
valObj.CH_NAME = Convert.ToString(txtCH_NAME.Value);
//if (txtM_TB_ID.Value != "")
valObj.M_TB_ID = pid;
if (txtSORT_NO.Value != "")
valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value);
if (txtTB_TYPE.Value != "")
valObj.TB_TYPE = Convert.ToInt32(txtTB_TYPE.Value);
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)
{
AgileFrame.Common.TF_TABLEHelper.Factory(conn).EditTable(ViewState["OLDNAME"].ToString(), valObj, ref errMsg);
}
}
else
{
valObj.CREATED = AgileFrame.Common.TF_TABLEHelper.Factory(conn).AddTableWithDefaultCols(valObj,"","", ref errMsg);
count = BLLTable<TF_TABLE>.Factory(conn).Insert(valObj, TF_TABLE.Attribute.TB_ID);
keyid = valObj.TB_ID.ToString();
}
if (count > 0)
{
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.SORT_NO).Append(",sc:1,name:'");
if (valObj.M_TB_ID > 0)
{
sb.Append(valObj.CH_NAME).Append("',ntype:'table-mx'}");
}
else
{
sb.Append(valObj.CH_NAME).Append("',ntype:'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();
}
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;
}
}
}
/// <summary>
/// 创建表
/// </summary>
public int AddTableWithDefaultCols(TF_TABLE tbObj,string sourceTable,string sourceConn, ref string errMsg)
{
string tbname = tbObj.TB_NAME;
DataBaseTable tb1 = null;
if (!DataBase.Factory(conn).TryGetValue(tbname, out tb1))//如果表不存在，则新建表，带默认字段
{
DataBaseTable tb2 = null;
if (tbObj.M_TB_ID > 0)
{
//if (!DataBase.Factory(conn).Master().TryGetValue("GROUP_WF_MX", out tb2))
// return 0;
if (!DataBase.Factory(conn).Master().TryGetValue("af_GROUP_WF_MX_2014", out tb2))
return 0;
}
else
{
//if (!DataBase.Factory(conn).Master().TryGetValue("GROUP_WF", out tb2))
// return 0;
if (!DataBase.Factory(conn).Master().TryGetValue("af_GROUP_WF_2014", out tb2))
return 0;
}
DataBaseTable tb3 = new DataBaseTable(tbname, tb2);
DataBaseTable tbsource = null;
if (!string.IsNullOrEmpty(sourceTable) && DataBase.Factory(sourceConn).TryGetValue(sourceTable, out tbsource))
{
foreach (DataBaseField f2 in tbsource.DataFields)
{
tb3.DataFields.Add(f2);
}
}
if (DataBase.Factory(conn).AddTable(tb3, ref errMsg))
return 1;
else
return 0;
}
//else
//{
// SaveToTF_TB_FIELD(tbObj, ref errMsg);
//}
return 1;
}
protected void Page_Load(object sender, EventArgs e)
{
dics.Add("TF_TABLE-root", "TF_TABLE");
dics.Add("TF_TABLE", "TF_TABLE");
//dics.Add("TF_TABLE", "TF_TABLE-mx");
if (!IsPostBack)
{
#region////显示子节点
if (Request["getSubNodes"] != null)
{
string nodetype = Request["ntype"];
StringBuilder sb = new StringBuilder("[");
string id = Request["id"];
if (nodetype == "TF_TABLE-root")
{
#region
TF_TABLE obj = new TF_TABLE();
TF_TABLE val = new TF_TABLE();
obj.M_TB_ID = 0;
val.OrderBy(TF_TABLE.Attribute.SORT_NO, Order.Asc);
List<TF_TABLE> lst = BLLTable<TF_TABLE>.Select(val, obj);
if (lst.Count != null)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].TB_ID);
sb.Append("',pid:'").Append("0").Append("',no:").Append(lst[i].SORT_NO);
sb.Append(",sc:").Append("-1");
sb.Append(",name:'").Append(lst[i].CH_NAME).Append("',ntype:'TF_TABLE'}");
}
}
#endregion
}
if (nodetype == "TF_TABLE" || nodetype == "TF_TABLE-mx")
{
if (nodetype == "TF_TABLE")//明细表，将不会再有子级的明细表。。。
{
#region
TF_TABLE objTB = new TF_TABLE();
TF_TABLE valTB = new TF_TABLE();
objTB.M_TB_ID = int.Parse(id);
valTB.OrderBy(TF_TABLE.Attribute.SORT_NO, Order.Asc);
List<TF_TABLE> lstTB = BLLTable<TF_TABLE>.Select(valTB, objTB);
if (lstTB.Count != null)
{
for (int i = 0; i < lstTB.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lstTB[i].TB_ID);
sb.Append("',pid:'").Append(id).Append("',no:").Append(lstTB[i].SORT_NO);
sb.Append(",sc:").Append("1");
sb.Append(",name:'").Append(lstTB[i].CH_NAME).Append("',ntype:'TF_TABLE-mx'}");
}
}
#endregion
}
#region
TF_TB_FIELD obj = new TF_TB_FIELD();
TF_TB_FIELD val = new TF_TB_FIELD();
obj.TB_ID = int.Parse(id);
val.OrderBy(TF_TB_FIELD.Attribute.SORT_NO, Order.Asc);
List<TF_TB_FIELD> lst = BLLTable<TF_TB_FIELD>.Select(val, obj);
if (lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].FIELD_ID.ToString());
sb.Append("',pid:'").Append(lst[i].TB_ID.ToString()).Append("',no:").Append(lst[i].SORT_NO);
sb.Append(",sc:").Append("0");
sb.Append(",name:'").Append(lst[i].NOTE).Append("',ntype:'TF_F_COLUMN'}");
}
}
#endregion
}
if (nodetype == "TF_FORM-root")
{
#region
TF_FORM obj = new TF_FORM();
TF_FORM val = new TF_FORM();
obj.M_FORM_ID = 0;
val.OrderBy(TF_FORM.Attribute.FORM_ID, Order.Asc);
List<TF_FORM> lst = BLLTable<TF_FORM>.Select(val, obj);
if (lst.Count != null)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].FORM_ID);
sb.Append("',pid:'").Append(lst[i].TB_ID).Append("',no:").Append(lst[i].FORM_ID);
sb.Append(",sc:").Append("1");
sb.Append(",name:'").Append(lst[i].F_NAME).Append("',ntype:'TF_FORM'}");
}
}
#endregion
}
if (nodetype == "TF_FORM" || nodetype == "TF_FORM-mx")
{
if (nodetype == "TF_FORM")
{
#region
TF_FORM objForm = new TF_FORM();
TF_FORM valForm = new TF_FORM();
objForm.M_FORM_ID = int.Parse(id);
valForm.OrderBy(TF_FORM.Attribute.FORM_ID, Order.Asc);
List<TF_FORM> lstForm = BLLTable<TF_FORM>.Select(valForm, objForm);
if (lstForm.Count != null)
{
for (int i = 0; i < lstForm.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lstForm[i].FORM_ID);
sb.Append("',pid:'").Append(id).Append("',no:").Append(lstForm[i].FORM_ID);
sb.Append(",sc:").Append("1");
sb.Append(",name:'").Append(lstForm[i].F_NAME).Append("',ntype:'TF_FORM-mx'}");
}
}
#endregion
}
#region
TF_F_COLUMN obj = new TF_F_COLUMN();
TF_F_COLUMN val = new TF_F_COLUMN();
//obj.IS_DEFAULT = "0";
obj.FORM_ID = int.Parse(id);
val.OrderBy(TF_F_COLUMN.Attribute.SORT_NO, Order.Asc);
List<TF_F_COLUMN> lst = BLLTable<TF_F_COLUMN>.Select(val, obj);
if (lst.Count != null)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("{id:'").Append(lst[i].COLUMN_ID);
sb.Append("',pid:'").Append(lst[i].FORM_ID).Append("',no:").Append(lst[i].SORT_NO);
sb.Append(",sc:").Append("0");
sb.Append(",name:'").Append(lst[i].SHOW_NAME).Append("',ntype:'TF_F_COLUMN'}");
}
}
#endregion
}
//sb.Append("{id:'").Append("1");
//sb.Append("',pid:'").Append("0").Append("',no:").Append("1");
//sb.Append(",sc:").Append("1");
//sb.Append(",name:'").Append("aaaaa(aaa)").Append("',ntype:'TF_FORM'}");
sb.Append("]");
Response.Write(sb.ToString());
}
#endregion
#region//删除节点
if (Request["deleteNode"] != null)
{
string str = "";
string delID=Request["id"];
string ntype=Request["ntype"];
if (ntype == "table" || ntype == "TF_TABLE-mx")
{
#region//删除表
int re = 0;
string msg = "删除数据库表成功！";
TF_TABLE cccSub = new TF_TABLE();
cccSub.M_TB_ID = int.Parse(delID);
if (BLLTable<TF_TABLE>.Count(cccSub) > 0)
{
msg = "存在明细表，不能删除!";
}
else
{
TF_TB_FIELD hadcol = new TF_TB_FIELD();
hadcol.TB_ID = int.Parse(delID);
if (BLLTable<TF_TB_FIELD>.Exists(hadcol))
{
msg = "存在字段，不能删除此表";
}
else
{
TF_FORM useTB = new TF_FORM();
useTB.Where("TB_ID=" + delID + " or TB_IDS like '%," + delID + ",%'");
if (BLLTable<TF_FORM>.Exists(useTB))
{
msg = "此表已被表单使用，不能删除";
}
else
{
re = new TF_TABLEHelper(conn).DelTable(delID, ref msg);// ;
if (re > 0)
{
if (BLLTable<TF_TABLE>.Delete(TF_TABLE.Attribute.TB_ID, delID) <= 0)
{
msg = "删除数据库表成功，但删除表结构信息失败！";
}
}
else
{
msg = "删除表结构信息失败！";
}
}
}
}
#endregion
str = "{re:" + re + ",msg:'" + msg + "'}";
}
else if (ntype == "field")
{
#region//删除表字段
string msg = "删除数据库表字段成功！";
int re = new TF_TABLEHelper(conn).DelField(delID, ref msg);// ;
if (re > 0)
{
if (BLLTable<TF_TB_FIELD>.Delete(TF_TB_FIELD.Attribute.FIELD_ID, delID) <= 0)
{
msg = "删除数据库表字段成功，但删除字段结构信息失败！";
}
}
else {
msg = "删除数据库表字段失败！";
}
#endregion
str = "{re:" + re + ",msg:'" + msg + "'}";
}
else if (ntype == "TF_FORM" || ntype == "TF_FORM-mx")
{
#region//删除表单
int re = 0;
string msg = "删除表单成功！";
TF_FORM cccSub = new TF_FORM();
cccSub.M_FORM_ID = int.Parse(delID);
if (BLLTable<TF_FORM>.Count(cccSub) > 0)
{
msg = "存在明细表单，不能删除!";
}
else
{
TF_F_COLUMN ccc = new TF_F_COLUMN();
ccc.FORM_ID = int.Parse(delID);
ccc.IS_DEFAULT = "0";
if (BLLTable<TF_F_COLUMN>.Count(ccc) > 0)
{
msg = "存在栏目，不能删除!";
}
else
{
re = BLLTable<TF_FORM>.Delete(TF_FORM.Attribute.FORM_ID, delID);
BLLTable<TF_F_COLUMN>.Delete(TF_F_COLUMN.Attribute.FORM_ID, delID);
if (re <= 0)
{
msg = "删除表单失败！";
}
}
}
#endregion
str = "{re:" + re+",msg:'" + msg + "'}";
}
else if (ntype == "TF_F_COLUMN")
{
string msg = "删除表单栏目成功！";
TF_F_COLUMN oldObj = BLLTable<TF_F_COLUMN>.GetRowData(TF_F_COLUMN.Attribute.COLUMN_ID, delID);
int re = BLLTable<TF_F_COLUMN>.Delete(TF_F_COLUMN.Attribute.COLUMN_ID, delID);
if (re <= 0)
{
msg = "删除表单栏目失败";
}
else {
if (oldObj != null)
{
BLLTable<TF_TB_FIELD>.Update(TF_TB_FIELD.Attribute.FIELD_ID, oldObj.FIELD_ID,
TF_TB_FIELD.Attribute.CREATED, 0);
}
}
str = "{re:" + re + ",msg:'" + msg + "'}";
}
Response.Write(str);
}
#endregion
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "编辑";
Page.Title = title;
if (!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)
{
#region//Ĭ�����ص���
//hideTableColumnList = new List<AttributeItem>();
//hideTableColumnList.Add(TF_TABLE.Attribute.EXP1);
//hideTableColumnList.Add(TF_TABLE.Attribute.EXP2);
//hideTableColumnList.Add(TF_TABLE.Attribute.EXP3);
//valObj.LoadAllAttributes(true);//��ʱ�Ӵ˴��룬�Ժ��ܸ��½�����Ҫ
//valObj.Remove(hideTableColumnList);
//hideFindColumnList = new List<AttributeItem>();
//hideFindColumnList.Add(TF_TABLE.Attribute.EXP1);
//hideFindColumnList.Add(TF_TABLE.Attribute.EXP2);
//hideFindColumnList.Add(TF_TABLE.Attribute.EXP3);
#endregion
condObj.OrderBy(TF_TABLE.Attribute.TB_ID, Order.Desc);
if (!IsPostBack)
{
btnFind.Text = LanguageService.GetLanguageString("btnFind", "��ѯ");
aspPager.PageSize = 10;
aspPager.CurrentPageIndex = 1;
if (!string.IsNullOrEmpty(Request["ids"]))
{
TF_TABLE roleOld = new TF_TABLE();
roleOld.Where(TF_TABLE.Attribute.TB_ID, Request["ids"].ToString());
listObj = BLLTable<TF_TABLE>.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].TB_ID + "',Name:'" + listObj[i].TB_ID + "'}";//�����Name������ʾ���б��У��������ض��塣
hidInitIDS.Value += listObj[i].TB_ID;
}
}
try
{
listObj = BLLTable<TF_TABLE>.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)
{
try
{
#region �������������ģ�͡����ô˲���ģ��չʾ
if (Request["ModuleType"] != null)
{
string ModuleType = "";
if (Request["ModuleType"] != null)
{
ModuleType = Convert.ToString(Request["ModuleType"]);
}
//��ģ�飬������ ȡֵ���������� �ȡ�
if (ModuleType == "TF_TABLE")
{
msg = "δ�ƶ�����";
string ModuleTbName = Convert.ToString(Request["moduleName"]);
if (string.IsNullOrEmpty(ModuleTbName))
{
Response.Write(msg);
Response.End();
}
TF_TABLE condObj1 = new TF_TABLE();
condObj1.TB_NAME = ModuleTbName;
SetRequest(condObj1);
bool ret1 = AgileFrame.Common.TF_TABLEHelper.Factory(conn).Parse(condObj1, out valObj, out condObj, out relationList,
out otherValueList, out condList, ref msg);//��ȡ������(������ʾ��)
msg = "�ƶ�ģ�������ģ��δ���ڣ��밲װ��ģ��";
if (!ret1)
{
Response.Write(msg);
Response.End();
}
//������������
SetRequest(condObj);
SetRequest(condList);
}
}
else
{
valObj = new ITableImplementHelper(conn).Factory("TF_TABLE");
condObj = new ITableImplementHelper(conn).Factory("TF_TABLE"); //(ITableImplement)valObj.Clone();//
}
#endregion
title = valObj._ZhName + "����";
Page.Title = title;
if (Request["PID"] != null)
{
pid = Request["PID"];
}
if (Request["submit"] != null)
{
}
if (!IsPostBack)
{
#region//Ĭ�����Գ�ʼ��
aspPager.CurrentPageIndex = 1;
aspPager.ShowInputBox = AgileFrame.Core.WebSystem.ShowInputBox.Auto;//.WebCtrls
//txtPageSize.Value = "2";
aspPager.PageSize = 30;
//if (pid == "" || pid == "0")
//{
// a_top.Visible = false;
//}
#endregion
#region//����
BindCondition();
#endregion
#region//���ݳ�ʼ��
//txtTB_TYPE.Items.AddRange(FormHelper.GetListItem(TF_TABLE.Attribute.TB_TYPE));
#endregion
BindList(1);
}
//Lit_ToolLeftButton;
}
catch (Exception ex)
{
HandleError(ex);
}
}
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["TB_ID"]) || !string.IsNullOrEmpty(Request["ID"]))
{
string tbid = Request["TB_ID"];
if (!string.IsNullOrEmpty(Request["ID"]))
{
tbid = Request["ID"];
}
valObj = BLLTable <TF_TABLE> .Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, tbid);
if (valObj == null)
{
return;
}
txtTB_ID.Text = Convert.ToString(valObj.TB_ID);//Convert.ToInt32
txtTB_NAME.Text = Convert.ToString(valObj.TB_NAME);//Convert.ToString
txtCH_NAME.Text = Convert.ToString(valObj.CH_NAME);//Convert.ToString
txtM_TB_ID.Text = Convert.ToString(valObj.M_TB_ID);//Convert.ToInt32
txtSORT_NO.Text = Convert.ToString(valObj.SORT_NO);//Convert.ToInt32
txtTB_TYPE.Text = valObj.TB_TYPE.ToString();
txtNOTE.Text = Convert.ToString(valObj.NOTE);//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)
{
title = valObj._ZhName + "管理";
Page.Title = title;
tbid = int.Parse(Request["id"]);
tbObj = BLLTable <TF_TABLE> .Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, tbid);
if (tbObj == null)
{
return;
}
if (!IsPostBack)
{
dicCtrlType = TF_Common.GetCtrlTypeDic();
#region //默认属性初始化
aspPager.CurrentPageIndex = 1;
aspPager.ShowInputBox = AgileFrame.Core.WebSystem.ShowInputBox.Auto; //WebCtrls.
aspPager.PageSize = 30;
#endregion
title = tbObj.CH_NAME;
#region//数据初始化
//txtFIELD_TYPE.Items.AddRange(FormHelper.GetListItem(TF_TB_FIELD.Attribute.FIELD_TYPE));
#endregion
if (Request["defaultfield"] != null)
{
btnFind.Enabled = false;
// ulBtns.Visible = false;
}
BindList(condObj, 1);
// fangan.Columns.Add("*TableName");//表名
//fangan.Columns.Add("UserId");//员工编号
//fangan.Columns.Add("TYPE");
//fangan.Columns.Add("CheckOWA");//考勤类型，请假、年假、公休、病假等
//fangan.Columns.Add("UnWorkStartTime");//抵消工作开始时间
//fangan.Columns.Add("UnWorkEndTime");//抵消工作结束时间
//fangan.Columns.Add("OnWorkStartTime");//工作时间开始时间
//fangan.Columns.Add("OnWorkEndTime");//工作时间结束时间
string path = Server.MapPath("~" + CheckInOutHelper.CheckOnWorkAttendanceFangAnPath);
ViewState["TB_NAME"] = tbObj.TB_NAME;
DataTable dt = CheckInOutHelper.GetOneCheckOnWorkAttendanceFangAn(tbObj.TB_NAME);
if (dt.Rows.Count <= 0)
{
DataRow dr = dt.NewRow();
dr["*TableName"] = tbObj.TB_NAME;
dr["UserId"] = "STAFF_ID";
//dr["TYPE"] = "'"+tbObj.CH_NAME+"' as TYPE";
dr["CheckOWA"] = "";
dr["UnWorkStartTime"] = "";
dr["UnWorkEndTime"] = "";
dr["OnWorkStartTime"] = "";
dr["OnWorkEndTime"] = "";
dt.Rows.Add(dr);
}
repFangAn.DataSource = dt;
repFangAn.DataBind();
}
}
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 + "\"}");
}
