protected void btnFind_Click(object sender, EventArgs e)
{
try
{
condObj = new TF_F_COLUMN_ITEM();
if (txtITEM_ID.Value != "")
{
condObj.Like(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Convert.ToInt32(txtITEM_ID.Value));
}
if (txtFORM_ID.Value != "")
{
condObj.Like(TF_F_COLUMN_ITEM.Attribute.FORM_ID, Convert.ToInt32(txtFORM_ID.Value));
}
if (txtCOLUMN_ID.Value != "")
{
condObj.Like(TF_F_COLUMN_ITEM.Attribute.COLUMN_ID, Convert.ToInt32(txtCOLUMN_ID.Value));
}
if (txtVALUE.Value != "")
{
condObj.Like(TF_F_COLUMN_ITEM.Attribute.VALUE, Convert.ToString(txtVALUE.Value));
}
if (txtTEXT.Value != "")
{
condObj.Like(TF_F_COLUMN_ITEM.Attribute.TEXT, Convert.ToString(txtTEXT.Value));
}
if (txtDROP_REAL.Value != "")
{
condObj.Like(TF_F_COLUMN_ITEM.Attribute.DROP_REAL, Convert.ToString(txtDROP_REAL.Value));
}
if (txtCOL_HIDE.Value != "")
{
condObj.Like(TF_F_COLUMN_ITEM.Attribute.COL_HIDE, Convert.ToString(txtCOL_HIDE.Value));
}
listObj = BLLTable <TF_F_COLUMN_ITEM> .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)
{
if (Request["ColID"] != null)
{
colid = Request["ColID"];
}
title = valObj._ZhName + "±à¼";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["ITEM_ID"]))
{
keyid = Request["ITEM_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!IsPostBack)
{
try
{
if (keyid != "")
{
valObj = BLLTable <TF_F_COLUMN_ITEM> .Factory(conn).GetRowData(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, keyid);
if (valObj == null)
{
return;
}
txtITEM_ID.Value = Convert.ToString(valObj.ITEM_ID);//Convert.ToInt32
//txtFORM_ID.Value = Convert.ToString(valObj.FORM_ID);//Convert.ToInt32
//txtCOLUMN_ID.Value = Convert.ToString(valObj.COLUMN_ID);//Convert.ToInt32
txtVALUE.Value = Convert.ToString(valObj.VALUE);//Convert.ToString
if (txtVALUE.Value != "")
{
ckSetVal.Checked = true;
}
txtTEXT.Value = Convert.ToString(valObj.TEXT); //Convert.ToString
txtDROP_REAL.Value = Convert.ToString(valObj.DROP_REAL); //Convert.ToString
txtCOL_HIDE.Value = Convert.ToString(valObj.COL_HIDE); //Convert.ToString
}
}
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["ITEM_ID"]))
{
valObj = BLLTable<TF_F_COLUMN_ITEM>.Factory(conn).GetRowData(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Request["ITEM_ID"]);
if(valObj==null) return ;
txtITEM_ID.Text = Convert.ToString(valObj.ITEM_ID);//Convert.ToInt32
txtFORM_ID.Text = Convert.ToString(valObj.FORM_ID);//Convert.ToInt32
txtCOLUMN_ID.Text = Convert.ToString(valObj.COLUMN_ID);//Convert.ToInt32
txtVALUE.Text = Convert.ToString(valObj.VALUE);//Convert.ToString
txtTEXT.Text = Convert.ToString(valObj.TEXT);//Convert.ToString
txtDROP_REAL.Text = Convert.ToString(valObj.DROP_REAL);//Convert.ToString
txtCOL_HIDE.Text = Convert.ToString(valObj.COL_HIDE);//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["DelITEM_ID"] != null)
{
int re = BLLTable <TF_F_COLUMN_ITEM> .Factory(conn).Delete(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Request["DelITEM_ID"]);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在列表顶部点击删除按钮，通过AJAX执行这里的后台代码，删除多条记录
if (Request["DelKeyIDS"] != null)
{
TF_F_COLUMN_ITEM cond = new TF_F_COLUMN_ITEM();
cond.In(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Request["DelKeyIDS"]);
int re = BLLTable <TF_F_COLUMN_ITEM> .Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在用户详细信息查看编辑页面，点保存时，通过AJAX执行这里的后台代码，实现部门字段的更新
if (Request["saveInfo"] != null)
{
TF_F_COLUMN_ITEM val = new TF_F_COLUMN_ITEM();
val.ITEM_ID = int.Parse(Request["FieldKeyID"]);
List <AttributeItem> lstCol = val.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName]))
{
val.SetValue(lstCol[i].FieldName, Request["txt" + lstCol[i].FieldName]);
}
}
BLLTable <TF_F_COLUMN_ITEM> .Factory(conn).Update(val, TF_F_COLUMN_ITEM.Attribute.ITEM_ID);
Response.Write("修改用户信息成功");
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
#region//默认隐藏的列
//hideTableColumnList = new List<AttributeItem>();
//hideTableColumnList.Add(TF_F_COLUMN_ITEM.Attribute.EXP1);
//hideTableColumnList.Add(TF_F_COLUMN_ITEM.Attribute.EXP2);
//hideTableColumnList.Add(TF_F_COLUMN_ITEM.Attribute.EXP3);
//valObj.LoadAllAttributes(true);//暂时加此代码，以后框架更新将不需要
//valObj.Remove(hideTableColumnList);
//hideFindColumnList = new List<AttributeItem>();
//hideFindColumnList.Add(TF_F_COLUMN_ITEM.Attribute.EXP1);
//hideFindColumnList.Add(TF_F_COLUMN_ITEM.Attribute.EXP2);
//hideFindColumnList.Add(TF_F_COLUMN_ITEM.Attribute.EXP3);
#endregion
condObj.OrderBy(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Order.Desc);
if (!IsPostBack)
{
btnFind.Text = LanguageService.GetLanguageString("btnFind", "查询");
aspPager.PageSize = 10;
aspPager.CurrentPageIndex = 1;
if (!string.IsNullOrEmpty(Request["ids"]))
{
TF_F_COLUMN_ITEM roleOld = new TF_F_COLUMN_ITEM();
roleOld.Where(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Request["ids"].ToString());
listObj = BLLTable <TF_F_COLUMN_ITEM> .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].ITEM_ID + "',Name:'" + listObj[i].ITEM_ID + "'}";//这里的Name用于显示在列表中，请自行重定义。
hidInitIDS.Value += listObj[i].ITEM_ID;
}
}
try
{
listObj = BLLTable <TF_F_COLUMN_ITEM> .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;
}
}
}
private void BindList(TF_F_COLUMN_ITEM condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ�����������������
condObj.af_PageBy(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Order.Desc);
if (colid!="")
{
condObj.COLUMN_ID = int.Parse(colid);
listObj = BLLTable<TF_F_COLUMN_ITEM>.Factory(conn).Select(valObj, condObj);
repList.DataSource = listObj;
repList.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼
if (Request["DelITEM_ID"] != null)
{
int re = BLLTable<TF_F_COLUMN_ITEM>.Factory(conn).Delete(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Request["DelITEM_ID"]);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼
if (Request["DelKeyIDS"] != null)
{
TF_F_COLUMN_ITEM cond = new TF_F_COLUMN_ITEM();
cond.In(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Request["DelKeyIDS"]);
int re = BLLTable<TF_F_COLUMN_ITEM>.Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ���
if (Request["saveInfo"] != null)
{
TF_F_COLUMN_ITEM val = new TF_F_COLUMN_ITEM();
val.ITEM_ID = int.Parse(Request["FieldKeyID"]);
List<AttributeItem> lstCol = val.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName])) {
val.SetValue(lstCol[i].FieldName,Request["txt" + lstCol[i].FieldName]);
}
}
BLLTable<TF_F_COLUMN_ITEM>.Factory(conn).Update(val, TF_F_COLUMN_ITEM.Attribute.ITEM_ID);
Response.Write("���û���Ϣ�ɹ�");
}
Response.End();
}
private void BindList(TF_F_COLUMN_ITEM condObj, int curPage)
{
if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性，则用主键属性排序
{
condObj.af_PageBy(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Order.Desc);
}
if (colid != "")
{
condObj.COLUMN_ID = int.Parse(colid);
listObj = BLLTable <TF_F_COLUMN_ITEM> .Factory(conn).Select(valObj, condObj);
repList.DataSource = listObj;
repList.DataBind();
}
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
try
{
recount = aspPager.RecordCount;
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson<TF_F_COLUMN_ITEM>(hidCondition.Value);
}
List<TF_F_COLUMN_ITEM> listVal = BLLTable<TF_F_COLUMN_ITEM>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount);
repList.DataSource = listVal;
repList.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void aspPager_PageChanged(object sender, EventArgs e)
{
try
{
if (hidCondition.Value != "")
{
condObj = JsonServiceBase.FromJson <TF_F_COLUMN_ITEM>(hidCondition.Value);
}
listObj = BLLTable <TF_F_COLUMN_ITEM> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, aspPager.CurrentPageIndex, ref recount);
repCus.DataSource = listObj;
repCus.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void btnFind_Click(object sender, EventArgs e)
{
condObj = new TF_F_COLUMN_ITEM();
if(txtITEM_ID.Value !="" )
condObj.Like_OR(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Convert.ToInt32(txtITEM_ID.Value));
if(txtFORM_ID.Value !="" )
condObj.Like_OR(TF_F_COLUMN_ITEM.Attribute.FORM_ID, Convert.ToInt32(txtFORM_ID.Value));
if(txtCOLUMN_ID.Value !="" )
condObj.Like_OR(TF_F_COLUMN_ITEM.Attribute.COLUMN_ID, Convert.ToInt32(txtCOLUMN_ID.Value));
if(txtVALUE.Value !="" )
condObj.Like_OR(TF_F_COLUMN_ITEM.Attribute.VALUE, Convert.ToString(txtVALUE.Value));
if(txtTEXT.Value !="" )
condObj.Like_OR(TF_F_COLUMN_ITEM.Attribute.TEXT, Convert.ToString(txtTEXT.Value));
if(txtDROP_REAL.Value !="" )
condObj.Like_OR(TF_F_COLUMN_ITEM.Attribute.DROP_REAL, Convert.ToString(txtDROP_REAL.Value));
if(txtCOL_HIDE.Value !="" )
condObj.Like_OR(TF_F_COLUMN_ITEM.Attribute.COL_HIDE, Convert.ToString(txtCOL_HIDE.Value));
try
{
hidCondition.Value = condObj.ToJson(20);
listObj = BLLTable<TF_F_COLUMN_ITEM>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repList.DataSource = listObj;
repList.DataBind();
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["ColID"] != null)
{
colid = Request["ColID"];
}
title = valObj._ZhName + "±à¼";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["ITEM_ID"]))
{
keyid = Request["ITEM_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!IsPostBack)
{
try
{
V_TF_F_COLUMN_ITEM objV = new V_TF_F_COLUMN_ITEM();
objV.Distinct = true;
objV.COLUMN_ID = 0;
objV.SHOW_NAME = "";
List <V_TF_F_COLUMN_ITEM> lst = BLLTable <V_TF_F_COLUMN_ITEM> .Select(objV);
ListItem liv = new ListItem();
liv.Value = "-1";
liv.Text = "δÁª¶¯";
txtDROP_REALF.Items.Add(liv);
foreach (V_TF_F_COLUMN_ITEM obj in lst)
{
liv = new ListItem();
liv.Value = Convert.ToString(obj.COLUMN_ID);
liv.Text = obj.SHOW_NAME;
txtDROP_REALF.Items.Add(liv);
}
// txtDROP_REALF.Items.AddRange(FormHelper.GetListItem(V_TF_F_COLUMN_ITEM.Attribute.COLUMN_ID, V_TF_F_COLUMN_ITEM.Attribute.COLUMN_ID, V_TF_F_COLUMN_ITEM.Attribute.SHOW_NAME, objv));
if (keyid != "")
{
valObj = BLLTable <TF_F_COLUMN_ITEM> .Factory(conn).GetRowData(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, keyid);
if (valObj == null)
{
return;
}
txtITEM_ID.Value = Convert.ToString(valObj.ITEM_ID);//Convert.ToInt32
//txtDROP_REAL.Value = Convert.ToString(valObj.DROP_REAL);
selVal = Convert.ToString(valObj.DROP_REAL);
TF_F_COLUMN_ITEM objsel = new TF_F_COLUMN_ITEM();
objsel = BLLTable <TF_F_COLUMN_ITEM> .GetRowData(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, valObj.DROP_REAL);
if (objsel != null)
{
txtDROP_REALF.Value = Convert.ToString(objsel.COLUMN_ID);
}
//txtFORM_ID.Value = Convert.ToString(valObj.FORM_ID);//Convert.ToInt32
//txtCOLUMN_ID.Value = Convert.ToString(valObj.COLUMN_ID);//Convert.ToInt32
txtVALUE.Value = Convert.ToString(valObj.VALUE);//Convert.ToString
if (txtVALUE.Value != "")
{
ckSetVal.Checked = true;
}
txtTEXT.Value = Convert.ToString(valObj.TEXT); //Convert.ToString
txtCOL_HIDE.Value = Convert.ToString(valObj.COL_HIDE); //Convert.ToString
}
}
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["ITEM_ID"]))
{
valObj = BLLTable <TF_F_COLUMN_ITEM> .Factory(conn).GetRowData(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Request["ITEM_ID"]);
if (valObj == null)
{
return;
}
txtITEM_ID.Text = Convert.ToString(valObj.ITEM_ID);//Convert.ToInt32
txtFORM_ID.Text = Convert.ToString(valObj.FORM_ID);//Convert.ToInt32
txtCOLUMN_ID.Text = Convert.ToString(valObj.COLUMN_ID);//Convert.ToInt32
txtVALUE.Text = Convert.ToString(valObj.VALUE);//Convert.ToString
txtTEXT.Text = Convert.ToString(valObj.TEXT);//Convert.ToString
txtDROP_REAL.Text = Convert.ToString(valObj.DROP_REAL);//Convert.ToString
txtCOL_HIDE.Text = Convert.ToString(valObj.COL_HIDE);//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["DelITEM_ID"] != null)
{
int re = BLLTable <TF_F_COLUMN_ITEM> .Factory(conn).Delete(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Request["DelITEM_ID"]);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在列表顶部点击删除按钮，通过AJAX执行这里的后台代码，删除多条记录
if (Request["DelKeyIDS"] != null)
{
TF_F_COLUMN_ITEM cond = new TF_F_COLUMN_ITEM();
cond.In(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Request["DelKeyIDS"]);
int re = BLLTable <TF_F_COLUMN_ITEM> .Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//可以输出数字 大于0 表示操作成功，也可以直接输出 字符串，客户端将弹出此字符串信息作为提示
}
else
{
Response.Write("删除失败！");
}
}
//在用户详细信息查看编辑页面，点保存时，通过AJAX执行这里的后台代码，实现部门字段的更新
if (Request["saveInfo"] != null)
{
TF_F_COLUMN_ITEM val = new TF_F_COLUMN_ITEM();
val.ITEM_ID = int.Parse(Request["FieldKeyID"]);
List <AttributeItem> lstCol = val.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName]))
{
val.SetValue(lstCol[i].FieldName, Request["txt" + lstCol[i].FieldName]);
}
}
BLLTable <TF_F_COLUMN_ITEM> .Factory(conn).Update(val, TF_F_COLUMN_ITEM.Attribute.ITEM_ID);
Response.Write("修改用户信息成功");
}
if (Request["selVal"] != null)
{
V_TF_F_COLUMN_ITEM objV = new V_TF_F_COLUMN_ITEM();
objV.Distinct = true;
objV.ITEM_ID = 0;
objV.TEXT = "";
V_TF_F_COLUMN_ITEM objVC = new V_TF_F_COLUMN_ITEM();
objVC.COLUMN_ID = Convert.ToInt32(Request["selVal"]);
List <V_TF_F_COLUMN_ITEM> lstv = BLLTable <V_TF_F_COLUMN_ITEM> .Select(objV, objVC);
string html = "";
//foreach (V_TF_F_COLUMN_ITEM obj in lstv)
//{
// html += "<option value='" + obj.ITEM_ID + "'>" + obj.TEXT + "</option>\r\n";
//}
Response.Write("{\"list\":" + JsonUtil.getJsonStr <V_TF_F_COLUMN_ITEM>(lstv) + ",\"first\":\"" + lstv[0].ITEM_ID + "\"}");
}
Response.End();
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
TF_F_COLUMN_ITEM valObj = new TF_F_COLUMN_ITEM();
if (txtITEM_ID.Value != "")
{
valObj.ITEM_ID = Convert.ToInt32(txtITEM_ID.Value);
}
if (txtVALUE.Value != "" && ckSetVal.Checked == true)
{
valObj.VALUE = Convert.ToString(txtVALUE.Value);
}
else
{
valObj.VALUE = "";
}
if (txtTEXT.Value != "")
{
valObj.TEXT = Convert.ToString(txtTEXT.Value);
}
valObj.DROP_REAL = Convert.ToString(txtDROP_REAL.Value);
valObj.COL_HIDE = Convert.ToString(txtCOL_HIDE.Value);
if (keyid != "")
{
valObj.ITEM_ID = Convert.ToInt32(keyid);
count = BLLTable <TF_F_COLUMN_ITEM> .Factory(conn).Update(valObj, TF_F_COLUMN_ITEM.Attribute.ITEM_ID);
}
else
{
TF_F_COLUMN colObj = BLLTable <TF_F_COLUMN> .Factory(conn).GetRowData(TF_F_COLUMN.Attribute.COLUMN_ID, colid);
valObj.COLUMN_ID = colObj.COLUMN_ID;
valObj.FORM_ID = colObj.FORM_ID;
count = BLLTable <TF_F_COLUMN_ITEM> .Factory(conn).Insert(valObj, TF_F_COLUMN_ITEM.Attribute.ITEM_ID);
keyid = valObj.ITEM_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"] = ViewState["sbData"].ToString() + "," + sbData.ToString();
}
else
{
ViewState["sbData"] = sbData.ToString();
}
Button btn = (Button)sender;
if (btn.ID == "btnOK")
{
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
{
txtITEM_ID.Value = "";
txtVALUE.Value = "";
txtTEXT.Value = "";
txtDROP_REAL.Value = "";
txtCOL_HIDE.Value = "";
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
try
{
TF_F_COLUMN_ITEM valObj = new TF_F_COLUMN_ITEM();
if(txtITEM_ID.Value !="" )
valObj.ITEM_ID = Convert.ToInt32(txtITEM_ID.Value);
if (txtVALUE.Value != "" && ckSetVal.Checked == true)
{
valObj.VALUE = Convert.ToString(txtVALUE.Value);
}
else {
valObj.VALUE = "";
}
if(txtTEXT.Value !="" )
valObj.TEXT = Convert.ToString(txtTEXT.Value);
valObj.DROP_REAL = Convert.ToString(hidDROP_REAL.Value);
valObj.COL_HIDE = Convert.ToString(txtCOL_HIDE.Value);
if (keyid != "")
{
valObj.ITEM_ID = Convert.ToInt32(keyid);
count = BLLTable<TF_F_COLUMN_ITEM>.Factory(conn).Update(valObj, TF_F_COLUMN_ITEM.Attribute.ITEM_ID);
}
else
{
TF_F_COLUMN colObj = BLLTable<TF_F_COLUMN>.Factory(conn).GetRowData(TF_F_COLUMN.Attribute.COLUMN_ID, colid);
valObj.COLUMN_ID = colObj.COLUMN_ID;
valObj.FORM_ID = colObj.FORM_ID;
count = BLLTable<TF_F_COLUMN_ITEM>.Factory(conn).Insert(valObj, TF_F_COLUMN_ITEM.Attribute.ITEM_ID);
keyid = valObj.ITEM_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"] = ViewState["sbData"].ToString() + "," + sbData.ToString();
}
else
{
ViewState["sbData"] = sbData.ToString();
}
Button btn = (Button)sender;
if (btn.ID == "btnOK")
{
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
{
txtITEM_ID.Value = "";
txtVALUE.Value = "";
txtTEXT.Value = "";
txtDROP_REAL.Value = "";
txtCOL_HIDE.Value = "";
}
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
protected void Page_Load(object sender, EventArgs e)
{
#region//Ĭ�����ص���
//hideTableColumnList = new List<AttributeItem>();
//hideTableColumnList.Add(TF_F_COLUMN_ITEM.Attribute.EXP1);
//hideTableColumnList.Add(TF_F_COLUMN_ITEM.Attribute.EXP2);
//hideTableColumnList.Add(TF_F_COLUMN_ITEM.Attribute.EXP3);
//valObj.LoadAllAttributes(true);//��ʱ�Ӵ˴��룬�Ժ��ܸ��½�����Ҫ
//valObj.Remove(hideTableColumnList);
//hideFindColumnList = new List<AttributeItem>();
//hideFindColumnList.Add(TF_F_COLUMN_ITEM.Attribute.EXP1);
//hideFindColumnList.Add(TF_F_COLUMN_ITEM.Attribute.EXP2);
//hideFindColumnList.Add(TF_F_COLUMN_ITEM.Attribute.EXP3);
#endregion
condObj.OrderBy(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Order.Desc);
if (!IsPostBack)
{
btnFind.Text = LanguageService.GetLanguageString("btnFind", "��ѯ");
aspPager.PageSize = 10;
aspPager.CurrentPageIndex = 1;
if (!string.IsNullOrEmpty(Request["ids"]))
{
TF_F_COLUMN_ITEM roleOld = new TF_F_COLUMN_ITEM();
roleOld.Where(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Request["ids"].ToString());
listObj = BLLTable<TF_F_COLUMN_ITEM>.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].ITEM_ID + "',Name:'" + listObj[i].ITEM_ID + "'}";//�����Name������ʾ���б��У��������ض��塣
hidInitIDS.Value += listObj[i].ITEM_ID;
}
}
try
{
listObj = BLLTable<TF_F_COLUMN_ITEM>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount);
repList.DataSource = listObj;
repList.DataBind();
aspPager.RecordCount = recount;
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼
if (Request["DelITEM_ID"] != null)
{
int re = BLLTable<TF_F_COLUMN_ITEM>.Factory(conn).Delete(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Request["DelITEM_ID"]);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼
if (Request["DelKeyIDS"] != null)
{
TF_F_COLUMN_ITEM cond = new TF_F_COLUMN_ITEM();
cond.In(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, Request["DelKeyIDS"]);
int re = BLLTable<TF_F_COLUMN_ITEM>.Factory(conn).Delete(cond);
if (re > 0)
{
Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ
}
else
{
Response.Write("ɾ��ʧ�ܣ�");
}
}
//���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ���
if (Request["saveInfo"] != null)
{
TF_F_COLUMN_ITEM val = new TF_F_COLUMN_ITEM();
val.ITEM_ID = int.Parse(Request["FieldKeyID"]);
List<AttributeItem> lstCol = val.af_AttributeItemList;
for (int i = 0; i < lstCol.Count; i++)
{
if (!string.IsNullOrEmpty(Request["txt" + lstCol[i].FieldName])) {
val.SetValue(lstCol[i].FieldName,Request["txt" + lstCol[i].FieldName]);
}
}
BLLTable<TF_F_COLUMN_ITEM>.Factory(conn).Update(val, TF_F_COLUMN_ITEM.Attribute.ITEM_ID);
Response.Write("���û���Ϣ�ɹ�");
}
if (Request["selVal"] != null)
{
V_TF_F_COLUMN_ITEM objV = new V_TF_F_COLUMN_ITEM();
objV.Distinct = true;
objV.ITEM_ID = 0;
objV.TEXT = "";
V_TF_F_COLUMN_ITEM objVC = new V_TF_F_COLUMN_ITEM();
objVC.COLUMN_ID = Convert.ToInt32 ( Request["selVal"]);
List<V_TF_F_COLUMN_ITEM> lstv = BLLTable<V_TF_F_COLUMN_ITEM>.Select(objV, objVC);
string html = "";
//foreach (V_TF_F_COLUMN_ITEM obj in lstv)
//{
// html += "<option value='" + obj.ITEM_ID + "'>" + obj.TEXT + "</option>\r\n";
//}
Response.Write("{\"list\":" + JsonUtil.getJsonStr<V_TF_F_COLUMN_ITEM>(lstv) + ",\"first\":\"" + lstv[0].ITEM_ID + "\"}");
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["ColID"] != null)
{
colid = Request["ColID"];
}
title = valObj._ZhName + "�༭";
Page.Title = title;
if (!string.IsNullOrEmpty(Request["ITEM_ID"]))
{
keyid = Request["ITEM_ID"];
}
if (!string.IsNullOrEmpty(Request["KeyID"]))
{
keyid = Request["KeyID"];
}
if (!IsPostBack)
{
try
{
V_TF_F_COLUMN_ITEM objV = new V_TF_F_COLUMN_ITEM();
objV.Distinct = true;
objV.COLUMN_ID = 0;
objV.SHOW_NAME = "";
List<V_TF_F_COLUMN_ITEM> lst = BLLTable<V_TF_F_COLUMN_ITEM>.Select(objV);
ListItem liv = new ListItem();
liv.Value = "-1";
liv.Text ="���";
txtDROP_REALF.Items.Add(liv);
foreach (V_TF_F_COLUMN_ITEM obj in lst)
{
liv = new ListItem();
liv.Value = Convert.ToString(obj.COLUMN_ID);
liv.Text = obj.SHOW_NAME;
txtDROP_REALF.Items.Add(liv);
}
// txtDROP_REALF.Items.AddRange(FormHelper.GetListItem(V_TF_F_COLUMN_ITEM.Attribute.COLUMN_ID, V_TF_F_COLUMN_ITEM.Attribute.COLUMN_ID, V_TF_F_COLUMN_ITEM.Attribute.SHOW_NAME, objv));
if (keyid != "")
{
valObj = BLLTable<TF_F_COLUMN_ITEM>.Factory(conn).GetRowData(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, keyid);
if (valObj == null) return;
txtITEM_ID.Value = Convert.ToString(valObj.ITEM_ID);//Convert.ToInt32
//txtDROP_REAL.Value = Convert.ToString(valObj.DROP_REAL);
selVal = Convert.ToString(valObj.DROP_REAL);
TF_F_COLUMN_ITEM objsel = new TF_F_COLUMN_ITEM();
objsel = BLLTable<TF_F_COLUMN_ITEM>.GetRowData(TF_F_COLUMN_ITEM.Attribute.ITEM_ID, valObj.DROP_REAL);
if (objsel != null)
{
txtDROP_REALF.Value = Convert.ToString(objsel.COLUMN_ID);
}
//txtFORM_ID.Value = Convert.ToString(valObj.FORM_ID);//Convert.ToInt32
//txtCOLUMN_ID.Value = Convert.ToString(valObj.COLUMN_ID);//Convert.ToInt32
txtVALUE.Value = Convert.ToString(valObj.VALUE);//Convert.ToString
if (txtVALUE.Value != "")
{
ckSetVal.Checked = true;
}
txtTEXT.Value = Convert.ToString(valObj.TEXT);//Convert.ToString
txtCOL_HIDE.Value = Convert.ToString(valObj.COL_HIDE);//Convert.ToString
}
}
catch (Exception ex)
{
litWarn.Text = ex.Message;
}
}
}
