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)
{
//���б�����ɾ����ť��ͨ��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["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["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;
}
}
}
