protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "详细";
Page.Title = title;
if (!IsPostBack)
{
try
{
if (!string.IsNullOrEmpty(Request["CTRL_TYPE"]))
{
valObj = BLLTable <TF_CTRL_TYPE> .Factory(conn).GetRowData(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Request["CTRL_TYPE"]);
if (valObj == null)
{
return;
}
txtCTRL_TYPE.Text = Convert.ToString(valObj.CTRL_TYPE);//Convert.ToString
txtP_CTRL_TYPE.Text = Convert.ToString(valObj.P_CTRL_TYPE);//Convert.ToString
txtCTRL_NAME.Text = Convert.ToString(valObj.CTRL_NAME);//Convert.ToString
txtEL_HTML.Text = Convert.ToString(valObj.EL_HTML);//Convert.ToString
txtSORT_NO.Text = Convert.ToString(valObj.SORT_NO);//Convert.ToInt32
txtJS_CODE.Text = Convert.ToString(valObj.JS_CODE);//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 btnFind_Click(object sender, EventArgs e)
{
condObj = new TF_CTRL_TYPE();
if(txtCTRL_TYPE.Value !="" )
condObj.Like(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Convert.ToString(txtCTRL_TYPE.Value));
if(txtP_CTRL_TYPE.Value !="" )
condObj.Like(TF_CTRL_TYPE.Attribute.P_CTRL_TYPE, Convert.ToString(txtP_CTRL_TYPE.Value));
if(txtCTRL_NAME.Value !="" )
condObj.Like(TF_CTRL_TYPE.Attribute.CTRL_NAME, Convert.ToString(txtCTRL_NAME.Value));
if(txtEL_HTML.Value !="" )
condObj.Like(TF_CTRL_TYPE.Attribute.EL_HTML, Convert.ToString(txtEL_HTML.Value));
if(txtSORT_NO.Value !="" )
condObj.Like(TF_CTRL_TYPE.Attribute.SORT_NO, Convert.ToInt32(txtSORT_NO.Value));
if(txtJS_CODE.Value !="" )
condObj.Like(TF_CTRL_TYPE.Attribute.JS_CODE, Convert.ToString(txtJS_CODE.Value));
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
protected void btnFind_Click(object sender, EventArgs e)
{
try
{
condObj = new TF_CTRL_TYPE();
if(txtCTRL_TYPE.Value !="" )
condObj.Like(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Convert.ToString(txtCTRL_TYPE.Value));
if(txtP_CTRL_TYPE.Value !="" )
condObj.Like(TF_CTRL_TYPE.Attribute.P_CTRL_TYPE, Convert.ToString(txtP_CTRL_TYPE.Value));
if(txtCTRL_NAME.Value !="" )
condObj.Like(TF_CTRL_TYPE.Attribute.CTRL_NAME, Convert.ToString(txtCTRL_NAME.Value));
if(txtEL_HTML.Value !="" )
condObj.Like(TF_CTRL_TYPE.Attribute.EL_HTML, Convert.ToString(txtEL_HTML.Value));
if(txtSORT_NO.Value !="" )
condObj.Like(TF_CTRL_TYPE.Attribute.SORT_NO, Convert.ToInt32(txtSORT_NO.Value));
if(txtJS_CODE.Value !="" )
condObj.Like(TF_CTRL_TYPE.Attribute.JS_CODE, Convert.ToString(txtJS_CODE.Value));
listObj = BLLTable<TF_CTRL_TYPE>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repCus.DataSource = listObj;
repCus.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
aspPager.RecordCount = recount;
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <TF_CTRL_TYPE>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<TF_CTRL_TYPE>(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_CTRL_TYPE>(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_CTRL_TYPE>(hidCondition.Value);
}
BindList(condObj, aspPager.CurrentPageIndex);
}
protected void Page_Load(object sender, EventArgs e)
{
#region//默认隐藏的列
//hideTableColumnList = new List<AttributeItem>();
//hideTableColumnList.Add(TF_CTRL_TYPE.Attribute.EXP1);
//hideTableColumnList.Add(TF_CTRL_TYPE.Attribute.EXP2);
//hideTableColumnList.Add(TF_CTRL_TYPE.Attribute.EXP3);
//valObj.LoadAllAttributes(true);//暂时加此代码，以后框架更新将不需要
//valObj.Remove(hideTableColumnList);
//hideFindColumnList = new List<AttributeItem>();
//hideFindColumnList.Add(TF_CTRL_TYPE.Attribute.EXP1);
//hideFindColumnList.Add(TF_CTRL_TYPE.Attribute.EXP2);
//hideFindColumnList.Add(TF_CTRL_TYPE.Attribute.EXP3);
#endregion
condObj.OrderBy(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Order.Desc);
if (!IsPostBack)
{
btnFind.Text = LanguageService.GetLanguageString("btnFind", "查询");
aspPager.PageSize = 10;
aspPager.CurrentPageIndex = 1;
if (!string.IsNullOrEmpty(Request["ids"]))
{
TF_CTRL_TYPE roleOld = new TF_CTRL_TYPE();
roleOld.Where(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Request["ids"].ToString());
listObj = BLLTable <TF_CTRL_TYPE> .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].CTRL_TYPE + "',Name:'" + listObj[i].CTRL_TYPE + "'}";//这里的Name用于显示在列表中，请自行重定义。
hidInitIDS.Value += listObj[i].CTRL_TYPE;
}
}
try
{
listObj = BLLTable <TF_CTRL_TYPE> .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 btnFind_Click(object sender, EventArgs e)
{
try
{
condObj = new TF_CTRL_TYPE();
if (txtCTRL_TYPE.Value != "")
{
condObj.Like(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Convert.ToString(txtCTRL_TYPE.Value));
}
if (txtP_CTRL_TYPE.Value != "")
{
condObj.Like(TF_CTRL_TYPE.Attribute.P_CTRL_TYPE, Convert.ToString(txtP_CTRL_TYPE.Value));
}
if (txtCTRL_NAME.Value != "")
{
condObj.Like(TF_CTRL_TYPE.Attribute.CTRL_NAME, Convert.ToString(txtCTRL_NAME.Value));
}
if (txtEL_HTML.Value != "")
{
condObj.Like(TF_CTRL_TYPE.Attribute.EL_HTML, Convert.ToString(txtEL_HTML.Value));
}
if (txtSORT_NO.Value != "")
{
condObj.Like(TF_CTRL_TYPE.Attribute.SORT_NO, Convert.ToInt32(txtSORT_NO.Value));
}
if (txtJS_CODE.Value != "")
{
condObj.Like(TF_CTRL_TYPE.Attribute.JS_CODE, Convert.ToString(txtJS_CODE.Value));
}
listObj = BLLTable <TF_CTRL_TYPE> .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)
{
//在列表里点击删除按钮，通过AJAX执行这里的后台代码，删除一条记录
if (Request["DelCTRL_TYPE"] != null)
{
int re = BLLTable <TF_CTRL_TYPE> .Factory(conn).Delete(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Request["DelCTRL_TYPE"]);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在列表顶部点击删除按钮，通过AJAX执行这里的后台代码，删除多条记录
if (Request["DelKeyIDS"] != null)
{
TF_CTRL_TYPE cond = new TF_CTRL_TYPE();
cond.In(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Request["DelKeyIDS"]);
int re = BLLTable <TF_CTRL_TYPE> .Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在用户详细信息查看编辑页面，点保存时，通过AJAX执行这里的后台代码，实现部门字段的更新
if (Request["saveInfo"] != null)
{
TF_CTRL_TYPE val = new TF_CTRL_TYPE();
val.CTRL_TYPE = 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_CTRL_TYPE> .Factory(conn).Update(val, TF_CTRL_TYPE.Attribute.CTRL_TYPE);
Response.Write("修改用户信息成功");
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "��ϸ";
Page.Title = title;
if (!IsPostBack)
{
try
{
if (!string.IsNullOrEmpty(Request["CTRL_TYPE"]))
{
valObj = BLLTable<TF_CTRL_TYPE>.Factory(conn).GetRowData(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Request["CTRL_TYPE"]);
if(valObj==null) return ;
txtCTRL_TYPE.Text = Convert.ToString(valObj.CTRL_TYPE);//Convert.ToString
txtP_CTRL_TYPE.Text = Convert.ToString(valObj.P_CTRL_TYPE);//Convert.ToString
txtCTRL_NAME.Text = Convert.ToString(valObj.CTRL_NAME);//Convert.ToString
txtEL_HTML.Text = Convert.ToString(valObj.EL_HTML);//Convert.ToString
txtSORT_NO.Text = Convert.ToString(valObj.SORT_NO);//Convert.ToInt32
txtJS_CODE.Text = Convert.ToString(valObj.JS_CODE);//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)
{
//���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼
if (Request["DelCTRL_TYPE"] != null)
{
int re = BLLTable<TF_CTRL_TYPE>.Factory(conn).Delete(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Request["DelCTRL_TYPE"]);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼
if (Request["DelKeyIDS"] != null)
{
TF_CTRL_TYPE cond = new TF_CTRL_TYPE();
cond.In(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Request["DelKeyIDS"]);
int re = BLLTable<TF_CTRL_TYPE>.Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ���
if (Request["saveInfo"] != null)
{
TF_CTRL_TYPE val = new TF_CTRL_TYPE();
val.CTRL_TYPE = 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_CTRL_TYPE>.Factory(conn).Update(val, TF_CTRL_TYPE.Attribute.CTRL_TYPE);
Response.Write("���û���Ϣ�ɹ�");
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "±à¼";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["CTRL_TYPE"]))
{
keyid = Request["CTRL_TYPE"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!IsPostBack)
{
this.txtCTRL_TYPE.Disabled = true;
this.txtCTRL_TYPE.Attributes["class"] = "dis";
try
{
if (keyid != "")
{
valObj = BLLTable <TF_CTRL_TYPE> .Factory(conn).GetRowData(TF_CTRL_TYPE.Attribute.CTRL_TYPE, keyid);
if (valObj == null)
{
return;
}
txtCTRL_TYPE.Value = Convert.ToString(valObj.CTRL_TYPE); //Convert.ToString
txtP_CTRL_TYPE.Value = Convert.ToString(valObj.P_CTRL_TYPE); //Convert.ToString
txtCTRL_NAME.Value = Convert.ToString(valObj.CTRL_NAME); //Convert.ToString
txtEL_HTML.Value = Convert.ToString(valObj.EL_HTML); //Convert.ToString
txtSORT_NO.Value = Convert.ToString(valObj.SORT_NO); //Convert.ToInt32
txtJS_CODE.Value = Convert.ToString(valObj.JS_CODE); //Convert.ToString
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new TF_CTRL_TYPE();
if (txtCTRL_TYPE.Value != "")
{
condObj.Like(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Convert.ToString(txtCTRL_TYPE.Value));
}
if (txtP_CTRL_TYPE.Value != "")
{
condObj.Like(TF_CTRL_TYPE.Attribute.P_CTRL_TYPE, Convert.ToString(txtP_CTRL_TYPE.Value));
}
if (txtCTRL_NAME.Value != "")
{
condObj.Like(TF_CTRL_TYPE.Attribute.CTRL_NAME, Convert.ToString(txtCTRL_NAME.Value));
}
if (txtEL_HTML.Value != "")
{
condObj.Like(TF_CTRL_TYPE.Attribute.EL_HTML, Convert.ToString(txtEL_HTML.Value));
}
if (txtSORT_NO.Value != "")
{
condObj.Like(TF_CTRL_TYPE.Attribute.SORT_NO, Convert.ToInt32(txtSORT_NO.Value));
}
if (txtJS_CODE.Value != "")
{
condObj.Like(TF_CTRL_TYPE.Attribute.JS_CODE, Convert.ToString(txtJS_CODE.Value));
}
hidCondition.Value = condObj.ToJson(20);
BindList(condObj, 1);
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
try
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<TF_CTRL_TYPE>(hidCondition.Value);
}
listObj = BLLTable<TF_CTRL_TYPE>.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
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <TF_CTRL_TYPE>(hidCondition.Value);
}
listObj = BLLTable <TF_CTRL_TYPE> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount);
repCus.DataSource = listObj;
repCus.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
private void BindList(TF_CTRL_TYPE condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
{
condObj.af_PageBy(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Order.Desc);
}
#region//数据权限条件
#endregion
//condObj.PID = decimal.Parse(pid);
listObj = BLLTable <TF_CTRL_TYPE> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "编辑";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["FIELD_ID"]))
{
keyid = Request["FIELD_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (Request["tree"] != null)
{
if (Request["edit"] != null)
{
keyid = Request["id"];
tbid = Request["pid"];
}
else
{
tbid = Request["id"];
}
}
if (!IsPostBack)
{
if (keyid != "")
{
valObj = BLLTable <TF_TB_FIELD> .Factory(conn).GetRowData(TF_TB_FIELD.Attribute.FIELD_ID, keyid);
//Response.Write(valObj.TYPE_CODE);
}
List <TF_FIELD_DBTYPE> lstDBType = BLLTable <TF_FIELD_DBTYPE> .Factory(conn).Select(new TF_FIELD_DBTYPE(), new TF_FIELD_DBTYPE());
Dictionary <string, List <TF_CTRL_TYPE> > json1 = new Dictionary <string, List <TF_CTRL_TYPE> >();
for (int i = 0; i < lstDBType.Count; i++)
{
ListItem li = new ListItem(lstDBType[i].TYPE_NAME, lstDBType[i].TYPE_CODE);
if (lstDBType[i].TYPE_CODE == null)
{
continue;
}
if (valObj != null && valObj.TYPE_CODE != null && lstDBType[i].TYPE_CODE == valObj.TYPE_CODE)
{
li.Selected = true;
}
txtFIELD_TYPE.Items.Add(li);
json1.Add(lstDBType[i].TYPE_CODE, new List <TF_CTRL_TYPE>());
if (lstDBType[i].CTRL_TYPES == null)
{
continue;
}
TF_CTRL_TYPE ccc = new TF_CTRL_TYPE();
ccc.In(TF_CTRL_TYPE.Attribute.CTRL_TYPE, lstDBType[i].CTRL_TYPES);
List <TF_CTRL_TYPE> lstCtrl = BLLTable <TF_CTRL_TYPE> .Factory(conn).Select(new TF_CTRL_TYPE(), ccc);
json1[lstDBType[i].TYPE_CODE].AddRange(lstCtrl);
}
StringBuilder sb = new StringBuilder("({");
foreach (string key1 in json1.Keys)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("'o_" + key1 + "':[");
for (int a = 0; a < json1[key1].Count; a++)
{
if (a > 0)
{
sb.Append(",");
}
sb.Append("{name:'" + json1[key1][a].CTRL_NAME + "',val:'" + json1[key1][a].CTRL_TYPE + "'}");
}
sb.Append("]");
}
sb.Append("})");
hidCtrlTypeData.Value = sb.ToString();
//txtFIELD_TYPE.Items.AddRange(FormHelper.GetListItem(TF_TB_FIELD.Attribute.FIELD_TYPE));
this.txtFIELD_ID.Disabled = true;
this.txtFIELD_ID.Attributes["class"] = "dis";
try
{
ViewState["OLDNAME"] = "";
if (keyid != "")
{
if (valObj == null)
{
return;
}
txtFIELD_ID.Value = Convert.ToString(valObj.FIELD_ID);//Convert.ToInt32
ViewState["OLDNAME"] = valObj.FIELD_NAME;
txtFIELD_NAME.Value = valObj.FIELD_NAME.Trim();
txtFIELD_TYPE.Value = valObj.TYPE_ID.ToString();
//txtDB_TYPE.Value = Convert.ToString(valObj.DB_TYPE);//Convert.ToString
txtIS_NULL.Checked = valObj.IS_NULL == 1;
txtNOTE.Value = Convert.ToString(valObj.NOTE); //Convert.ToString
txtDEFAULT_VAL.Value = Convert.ToString(valObj.DEFAULT_VAL); //Convert.ToString
//txtTB_ID.Value = Convert.ToString(valObj.TB_ID);//Convert.ToInt32
txtCTRL_TYPE.Value = valObj.CTRL_TYPE; //Convert.ToString
txtSORT_NO.Value = Convert.ToString(valObj.SORT_NO); //Convert.ToInt32
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
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 btnOK_Click(object sender, EventArgs e)
{
try
{
TF_CTRL_TYPE valObj = new TF_CTRL_TYPE();
if(txtCTRL_TYPE.Value !="" )
valObj.CTRL_TYPE = Convert.ToString(txtCTRL_TYPE.Value);
if(txtP_CTRL_TYPE.Value !="" )
valObj.P_CTRL_TYPE = Convert.ToString(txtP_CTRL_TYPE.Value);
if(txtCTRL_NAME.Value !="" )
valObj.CTRL_NAME = Convert.ToString(txtCTRL_NAME.Value);
if(txtEL_HTML.Value !="" )
valObj.EL_HTML = Convert.ToString(txtEL_HTML.Value);
if(txtSORT_NO.Value !="" )
valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value);
if(txtJS_CODE.Value !="" )
valObj.JS_CODE = Convert.ToString(txtJS_CODE.Value);
if (keyid != "")
{
valObj.CTRL_TYPE = keyid;
count = BLLTable<TF_CTRL_TYPE>.Factory(conn).Update(valObj, TF_CTRL_TYPE.Attribute.CTRL_TYPE);
}
else
{
count = BLLTable<TF_CTRL_TYPE>.Factory(conn).Insert(valObj, TF_CTRL_TYPE.Attribute.CTRL_TYPE);
keyid = valObj.CTRL_TYPE.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("})");
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
{
txtCTRL_TYPE.Value ="";
txtP_CTRL_TYPE.Value ="";
txtCTRL_NAME.Value ="";
txtEL_HTML.Value ="";
txtSORT_NO.Value ="";
txtJS_CODE.Value ="";
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "�༭";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["CTRL_TYPE"]))
{
keyid = Request["CTRL_TYPE"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!IsPostBack)
{
this.txtCTRL_TYPE.Disabled = true;
this.txtCTRL_TYPE.Attributes["class"] = "dis";
try
{
if (keyid != "")
{
valObj = BLLTable<TF_CTRL_TYPE>.Factory(conn).GetRowData(TF_CTRL_TYPE.Attribute.CTRL_TYPE, keyid);
if(valObj==null) return ;
txtCTRL_TYPE.Value = Convert.ToString(valObj.CTRL_TYPE);//Convert.ToString
txtP_CTRL_TYPE.Value = Convert.ToString(valObj.P_CTRL_TYPE);//Convert.ToString
txtCTRL_NAME.Value = Convert.ToString(valObj.CTRL_NAME);//Convert.ToString
txtEL_HTML.Value = Convert.ToString(valObj.EL_HTML);//Convert.ToString
txtSORT_NO.Value = Convert.ToString(valObj.SORT_NO);//Convert.ToInt32
txtJS_CODE.Value = Convert.ToString(valObj.JS_CODE);//Convert.ToString
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
TF_CTRL_TYPE valObj = new TF_CTRL_TYPE();
if (txtCTRL_TYPE.Value != "")
{
valObj.CTRL_TYPE = Convert.ToString(txtCTRL_TYPE.Value);
}
if (txtP_CTRL_TYPE.Value != "")
{
valObj.P_CTRL_TYPE = Convert.ToString(txtP_CTRL_TYPE.Value);
}
if (txtCTRL_NAME.Value != "")
{
valObj.CTRL_NAME = Convert.ToString(txtCTRL_NAME.Value);
}
if (txtEL_HTML.Value != "")
{
valObj.EL_HTML = Convert.ToString(txtEL_HTML.Value);
}
if (txtSORT_NO.Value != "")
{
valObj.SORT_NO = Convert.ToInt32(txtSORT_NO.Value);
}
if (txtJS_CODE.Value != "")
{
valObj.JS_CODE = Convert.ToString(txtJS_CODE.Value);
}
if (keyid != "")
{
valObj.CTRL_TYPE = keyid;
count = BLLTable <TF_CTRL_TYPE> .Factory(conn).Update(valObj, TF_CTRL_TYPE.Attribute.CTRL_TYPE);
}
else
{
count = BLLTable <TF_CTRL_TYPE> .Factory(conn).Insert(valObj, TF_CTRL_TYPE.Attribute.CTRL_TYPE);
keyid = valObj.CTRL_TYPE.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("})");
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
{
txtCTRL_TYPE.Value = "";
txtP_CTRL_TYPE.Value = "";
txtCTRL_NAME.Value = "";
txtEL_HTML.Value = "";
txtSORT_NO.Value = "";
txtJS_CODE.Value = "";
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region//Ĭ�����ص���
//hideTableColumnList = new List<AttributeItem>();
//hideTableColumnList.Add(TF_CTRL_TYPE.Attribute.EXP1);
//hideTableColumnList.Add(TF_CTRL_TYPE.Attribute.EXP2);
//hideTableColumnList.Add(TF_CTRL_TYPE.Attribute.EXP3);
//valObj.LoadAllAttributes(true);//��ʱ�Ӵ˴��룬�Ժ��ܸ��½�����Ҫ
//valObj.Remove(hideTableColumnList);
//hideFindColumnList = new List<AttributeItem>();
//hideFindColumnList.Add(TF_CTRL_TYPE.Attribute.EXP1);
//hideFindColumnList.Add(TF_CTRL_TYPE.Attribute.EXP2);
//hideFindColumnList.Add(TF_CTRL_TYPE.Attribute.EXP3);
#endregion
condObj.OrderBy(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Order.Desc);
if (!IsPostBack)
{
btnFind.Text = LanguageService.GetLanguageString("btnFind", "��ѯ");
aspPager.PageSize = 10;
aspPager.CurrentPageIndex = 1;
if (!string.IsNullOrEmpty(Request["ids"]))
{
TF_CTRL_TYPE roleOld = new TF_CTRL_TYPE();
roleOld.Where(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Request["ids"].ToString());
listObj = BLLTable<TF_CTRL_TYPE>.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].CTRL_TYPE + "',Name:'" + listObj[i].CTRL_TYPE + "'}";//�����Name������ʾ���б��У��������ض��塣
hidInitIDS.Value += listObj[i].CTRL_TYPE;
}
}
try
{
listObj = BLLTable<TF_CTRL_TYPE>.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)
{
title = valObj._ZhName + "�༭";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["FIELD_ID"]))
{
keyid = Request["FIELD_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (Request["tree"] != null)
{
if (Request["edit"] != null)
{
keyid = Request["id"];
tbid = Request["pid"];
}
else {
tbid = Request["id"];
}
}
if (!IsPostBack)
{
if (keyid != "")
{
valObj = BLLTable<TF_TB_FIELD>.Factory(conn).GetRowData(TF_TB_FIELD.Attribute.FIELD_ID, keyid);
//Response.Write(valObj.TYPE_CODE);
}
List<TF_FIELD_DBTYPE> lstDBType = BLLTable<TF_FIELD_DBTYPE>.Factory(conn).Select(new TF_FIELD_DBTYPE(),new TF_FIELD_DBTYPE());
Dictionary<string, List<TF_CTRL_TYPE>> json1 = new Dictionary<string, List<TF_CTRL_TYPE>>();
for (int i = 0; i < lstDBType.Count; i++)
{
ListItem li = new ListItem(lstDBType[i].TYPE_NAME, lstDBType[i].TYPE_CODE);
if (lstDBType[i].TYPE_CODE == null) continue;
if (valObj != null && valObj.TYPE_CODE != null && lstDBType[i].TYPE_CODE == valObj.TYPE_CODE)
{
li.Selected = true;
}
txtFIELD_TYPE.Items.Add(li);
json1.Add(lstDBType[i].TYPE_CODE, new List<TF_CTRL_TYPE>());
if (lstDBType[i].CTRL_TYPES == null) continue;
TF_CTRL_TYPE ccc = new TF_CTRL_TYPE();
ccc.In(TF_CTRL_TYPE.Attribute.CTRL_TYPE, lstDBType[i].CTRL_TYPES);
List<TF_CTRL_TYPE> lstCtrl = BLLTable<TF_CTRL_TYPE>.Factory(conn).Select(new TF_CTRL_TYPE(), ccc);
json1[lstDBType[i].TYPE_CODE].AddRange(lstCtrl);
}
StringBuilder sb = new StringBuilder("({");
foreach (string key1 in json1.Keys)
{
if (sb.Length > 2)
{
sb.Append(",");
}
sb.Append("'o_" + key1 + "':[");
for (int a = 0; a < json1[key1].Count; a++)
{
if (a > 0)
{
sb.Append(",");
}
sb.Append("{name:'" + json1[key1][a].CTRL_NAME + "',val:'" + json1[key1][a].CTRL_TYPE + "'}");
}
sb.Append("]");
}
sb.Append("})");
hidCtrlTypeData.Value = sb.ToString();
//txtFIELD_TYPE.Items.AddRange(FormHelper.GetListItem(TF_TB_FIELD.Attribute.FIELD_TYPE));
this.txtFIELD_ID.Disabled = true;
this.txtFIELD_ID.Attributes["class"] = "dis";
try
{
ViewState["OLDNAME"] = "";
if (keyid != "")
{
if(valObj==null) return ;
txtFIELD_ID.Value = Convert.ToString(valObj.FIELD_ID);//Convert.ToInt32
ViewState["OLDNAME"] = valObj.FIELD_NAME;
txtFIELD_NAME.Value = valObj.FIELD_NAME.Trim();
txtFIELD_TYPE.Value=valObj.TYPE_ID.ToString();
//txtDB_TYPE.Value = Convert.ToString(valObj.DB_TYPE);//Convert.ToString
txtIS_NULL.Checked = valObj.IS_NULL == 1;
txtNOTE.Value = Convert.ToString(valObj.NOTE);//Convert.ToString
txtDEFAULT_VAL.Value = Convert.ToString(valObj.DEFAULT_VAL);//Convert.ToString
//txtTB_ID.Value = Convert.ToString(valObj.TB_ID);//Convert.ToInt32
txtCTRL_TYPE.Value = valObj.CTRL_TYPE;//Convert.ToString
txtSORT_NO.Value = Convert.ToString(valObj.SORT_NO);//Convert.ToInt32
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
title = valObj._ZhName + "�༭";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["COLUMN_ID"]))
{
keyid = Request["COLUMN_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!string.IsNullOrEmpty(Request["edit"]) && Request["ntype"]=="TF_F_COLUMN")
{
keyid = Request["id"];
}
if (Request["ntype"] == "TF_FORM" || Request["ntype"] == "TF_FORM-mx")
{
formid = Request["id"];
txtFORM_ID.Value = formid;
}
if (!string.IsNullOrEmpty(Request["formid"]))
{
formid = Request["formid"];
txtFORM_ID.Value = formid;
}
if (!IsPostBack)
{
dlCAL_FORMULA.Style.Value="display:none";//.Visible = false;
dlSUM_FIELD_ID.Style.Value="display:none";//.Visible = false;
//try
//{
ViewState["txtFIELD_ID"] = "";
if (keyid != "")
{
valObj = BLLTable<TF_F_COLUMN>.Factory(conn).GetRowData(TF_F_COLUMN.Attribute.COLUMN_ID, keyid);
if (valObj == null) return;
txtCOLUMN_ID.Value = Convert.ToString(valObj.COLUMN_ID);//Convert.ToInt32
formid = valObj.FORM_ID.ToString();
txtFORM_ID.Value = Convert.ToString(valObj.FORM_ID);//Convert.ToInt32
txtTB_ID.Value = Convert.ToString(valObj.TB_ID);//Convert.ToInt32
hidFIELD_ID.Value = Convert.ToString(valObj.FIELD_ID);//Convert.ToInt32
txtFIELD_ID.Value = BLLTable<TF_TB_FIELD>.Factory(conn).GetOneValue(TF_TB_FIELD.Attribute.FIELD_ID, valObj.FIELD_ID, TF_TB_FIELD.Attribute.NOTE);
ViewState["txtFIELD_ID"] = txtFIELD_ID.Value;
ViewState["hidFIELD_ID"] = hidFIELD_ID.Value;
txtSHOW_NAME.Value = Convert.ToString(valObj.SHOW_NAME);//Convert.ToString
//txtCTRL_TYPE.Value = Convert.ToString(valObj.CTRL_TYPE);//Convert.ToString
txtMAX_VAL.Value = Convert.ToString(valObj.MAX_VAL);//Convert.ToInt32
txtMIN_VAL.Value = Convert.ToString(valObj.MIN_VAL);//Convert.ToInt32
txtDEFAULT_VAL.Value = Convert.ToString(valObj.DEFAULT_VAL);//Convert.ToString
txtIS_NEED.Checked = valObj.IS_NEED == 1 ? true : false;//Convert.ToInt32
//txtCAL_FORMULA.Value = Convert.ToString(valObj.CAL_FORMULA);//Convert.ToString
txtSUM_FIELD_ID.Value = Convert.ToString(valObj.SUM_FIELD_ID);//Convert.ToString
txtSORT_NO.Value = Convert.ToString(valObj.SORT_NO);//Convert.ToInt32
txtCAL_FORMULA.Value = valObj.CAL_FORMULA;
if (valObj.SHOWIN_HEADER == "1")
{
txtSHOWIN_HEADR.Checked = true;
}
else {
txtSHOWIN_HEADR.Checked = false;
}
txtSHOWIN_FORM.Checked = valObj.SHOWIN_FORM == "1" ? true : false;
TF_TB_FIELD fieldObj = BLLTable<TF_TB_FIELD>.Factory(conn).GetRowData(TF_TB_FIELD.Attribute.FIELD_ID, valObj.FIELD_ID);
if (fieldObj != null)
{
if (fieldObj.TYPE_CODE == TF_ENUM.FieldTypeCode.Decimal.ToString() ||
fieldObj.TYPE_CODE == TF_ENUM.FieldTypeCode.Number.ToString())
{
//dlCAL_FORMULA.Style.Value = "display:block";//.Visible = true;
}
else
{
dlCAL_FORMULA.Visible = false;
dlSUM_FIELD_ID.Visible = false;
}
}
else {
litWarn.Text = "��Ӧ�ֶι�������ȷ��";
}
// Response.Write(fieldObj.TYPE_CODE);
}
if (txtFORM_ID.Value != "")
{
#region//��ʼ�����ڱ�д��ʽ�Ŀ�ѡ�ֶ��б�
TF_FORM formObj = BLLTable<TF_FORM>.Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, txtFORM_ID.Value);
if (formObj != null)
txtTB_ID.Value = formObj.TB_ID.ToString();
if (formObj.M_FORM_ID > 0)
{
TF_TB_FIELD numccc = new TF_TB_FIELD();
numccc.In(TF_TB_FIELD.Attribute.TYPE_CODE, TF_ENUM.FieldTypeCode.Decimal.ToString() + "," + TF_ENUM.FieldTypeCode.Number.ToString());
numccc.TB_ID = formObj.TB_ID;
List<TF_TB_FIELD> fieldList = BLLTable<TF_TB_FIELD>.Factory(conn).Select(new TF_TB_FIELD(), numccc);
if (fieldList != null && fieldList.Count > 0)
{
StringBuilder sbnumcols = new StringBuilder();
fieldList.ForEach(f =>
{
sbnumcols.Append("<a data='" + f.FIELD_NAME + "' onclick='selColToCalInput(this);'>" + f.NOTE + "(" + f.FIELD_NAME + ")</a>");
});
litNumberFields.Text = sbnumcols.ToString();
if (keyid != "")
{
dlCAL_FORMULA.Style.Value = "display:block";//.Visible = true;
}
//dlCAL_FORMULA.Visible = true;
}
#endregion
#region//��ʼ���ۺϿ���������Ϊ����ij���ֶε�ֵ���ֶ��б�,��Щ�ֶ�������ϸ��
formObj = BLLTable<TF_FORM>.Factory(conn).GetRowData(TF_FORM.Attribute.FORM_ID, formObj.M_FORM_ID);
if (formObj != null)
{
numccc = new TF_TB_FIELD();
numccc.In(TF_TB_FIELD.Attribute.TYPE_CODE, TF_ENUM.FieldTypeCode.Decimal.ToString() + "," + TF_ENUM.FieldTypeCode.Number.ToString());
numccc.TB_ID = formObj.TB_ID;
TF_TABLE tbObj = BLLTable<TF_TABLE>.Factory(conn).GetRowData(TF_TABLE.Attribute.TB_ID, formObj.TB_ID);
fieldList = new List<TF_TB_FIELD>();
fieldList = BLLTable<TF_TB_FIELD>.Factory(conn).Select(new TF_TB_FIELD(), numccc);
if (fieldList != null && fieldList.Count > 0)
{
StringBuilder sbnumcols = new StringBuilder();
fieldList.ForEach(f =>
{
sbnumcols.Append("<a class='cansel' data='" + tbObj.TB_NAME + "." + f.FIELD_NAME + "' onclick='selColToSum(this);'>" + f.NOTE + "(" + f.FIELD_NAME + ")</a>");
});
litSUM_FIELD_ID.Text = sbnumcols.ToString();
if (keyid != "")
{
dlSUM_FIELD_ID.Style.Value = "display:block";//.Visible = true;
}
//dlSUM_FIELD_ID.Visible = true;
}
}
}
#endregion
}
#region//��ʼ���ؼ�����
TF_CTRL_TYPE ctrlCond = new TF_CTRL_TYPE();
ctrlCond.OrderBy(TF_CTRL_TYPE.Attribute.SORT_NO, Order.Asc);
DataTable dtCtrl = BLLTable<TF_CTRL_TYPE>.SelectForDataTable(new TF_CTRL_TYPE(), ctrlCond);
ViewState["CTRL_TYPE"] = valObj.CTRL_TYPE;
DataView dv1 = new DataView();
dv1.Table = dtCtrl;
dv1.RowFilter = "P_CTRL_TYPE='0'";
dv1.Sort = "SORT_NO asc";
for (int i = 0; i < dv1.Count; i++)
{
litCTRL_TYPE.Text += "<optgroup label='" + dv1[i]["CTRL_NAME"].ToString() + "'>";
DataView dv2 = new DataView();
dv2.Table = dtCtrl;
dv2.RowFilter = "P_CTRL_TYPE='" + dv1[i]["CTRL_TYPE"].ToString() + "'";
dv2.Sort = "SORT_NO asc";
for (int a = 0; a < dv2.Count; a++)
{
if (valObj != null && valObj.CTRL_TYPE == dv2[a]["CTRL_TYPE"].ToString())
{
litCTRL_TYPE.Text += "<option value='" + dv2[a]["CTRL_TYPE"].ToString() + "' selected='selected'>" + dv2[a]["CTRL_NAME"].ToString() + "</option>";
}
else
{
litCTRL_TYPE.Text += "<option value='" + dv2[a]["CTRL_TYPE"].ToString() + "'>" + dv2[a]["CTRL_NAME"].ToString() + "</option>";
}
}
litCTRL_TYPE.Text += "</optgroup>";
}
#endregion
//}
//catch (Exception ex)
//{
// litWarn.Text = ex.Message;
//}
}
}
private void BindList(TF_CTRL_TYPE condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
condObj.af_PageBy(TF_CTRL_TYPE.Attribute.CTRL_TYPE, Order.Desc);
#region//����Ȩ������
#endregion
//condObj.PID = decimal.Parse(pid);
listObj = BLLTable<TF_CTRL_TYPE>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
