protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<Ec_relatedlists>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <Ec_relatedlists>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void Page_Load(object sender, EventArgs e) { title = valObj._ZhName + "±à¼"; Page.Title = title; if (!string.IsNullOrEmpty(Request["Relation_id"])) { keyid = Request["Relation_id"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (!IsPostBack) { this.txtRelation_id.Disabled = true; this.txtRelation_id.Value = "0"; this.txtRelation_id.Attributes["class"] = "dis"; try { if (keyid != "") { valObj = BLLTable <Ec_relatedlists> .Factory(conn).GetRowData(Ec_relatedlists.Attribute.Relation_id, keyid); if (valObj == null) { return; } txtRelation_id.Value = Convert.ToString(valObj.Relation_id); //Convert.ToInt32 txtTabid.Value = Convert.ToString(valObj.Tabid); //Convert.ToInt32 txtRelated_tabid.Value = Convert.ToString(valObj.Related_tabid); //Convert.ToInt32 txtName.Value = Convert.ToString(valObj.Name); //Convert.ToString txtSequence.Value = Convert.ToString(valObj.Sequence); //Convert.ToInt32 txtLabel.Value = Convert.ToString(valObj.Label); //Convert.ToString txtPresence.Value = Convert.ToString(valObj.Presence); //Convert.ToInt32 txtTabTableName.Value = Convert.ToString(valObj.TabTableName); //Convert.ToString txtColumnName_PK.Value = Convert.ToString(valObj.ColumnName_PK); //Convert.ToString txtColumnName_FK.Value = Convert.ToString(valObj.ColumnName_FK); //Convert.ToString txtRelated_tabTableName.Value = Convert.ToString(valObj.Related_tabTableName); //Convert.ToString } } catch (Exception ex) { litWarn.Text = ex.Message; } } }
protected void btnSetPageSize_Click(object sender, EventArgs e) { aspPager.PageSize = int.Parse(txtPageSize.Value); if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <Ec_relatedlists>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void Page_Load(object sender, EventArgs e) { #region//默认隐藏的列 //hideTableColumnList = new List<AttributeItem>(); //hideTableColumnList.Add(Ec_relatedlists.Attribute.EXP1); //hideTableColumnList.Add(Ec_relatedlists.Attribute.EXP2); //hideTableColumnList.Add(Ec_relatedlists.Attribute.EXP3); //valObj.LoadAllAttributes(true);//暂时加此代码,以后框架更新将不需要 //valObj.Remove(hideTableColumnList); //hideFindColumnList = new List<AttributeItem>(); //hideFindColumnList.Add(Ec_relatedlists.Attribute.EXP1); //hideFindColumnList.Add(Ec_relatedlists.Attribute.EXP2); //hideFindColumnList.Add(Ec_relatedlists.Attribute.EXP3); #endregion condObj.OrderBy(Ec_relatedlists.Attribute.Relation_id, Order.Desc); if (!IsPostBack) { btnFind.Text = LanguageService.GetLanguageString("btnFind", "查询"); aspPager.PageSize = 10; aspPager.CurrentPageIndex = 1; if (!string.IsNullOrEmpty(Request["ids"])) { Ec_relatedlists roleOld = new Ec_relatedlists(); roleOld.Where(Ec_relatedlists.Attribute.Relation_id, Request["ids"].ToString()); listObj = BLLTable <Ec_relatedlists> .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].Relation_id + "',Name:'" + listObj[i].Relation_id + "'}";//这里的Name用于显示在列表中,请自行重定义。 hidInitIDS.Value += listObj[i].Relation_id; } } try { listObj = BLLTable <Ec_relatedlists> .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["DelRelation_id"] != null) { int re = BLLTable <Ec_relatedlists> .Factory(conn).Delete(Ec_relatedlists.Attribute.Relation_id, Request["DelRelation_id"]); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在列表顶部点击删除按钮,通过AJAX执行这里的后台代码,删除多条记录 if (Request["DelKeyIDS"] != null) { Ec_relatedlists cond = new Ec_relatedlists(); cond.In(Ec_relatedlists.Attribute.Relation_id, Request["DelKeyIDS"]); int re = BLLTable <Ec_relatedlists> .Factory(conn).Delete(cond); if (re > 0) { Response.Write("1");//可以输出数字 大于0 表示操作成功,也可以直接输出 字符串,客户端将弹出此字符串信息作为提示 } else { Response.Write("删除失败!"); } } //在用户详细信息查看编辑页面,点保存时,通过AJAX执行这里的后台代码,实现部门字段的更新 if (Request["saveInfo"] != null) { Ec_relatedlists val = new Ec_relatedlists(); val.Relation_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 <Ec_relatedlists> .Factory(conn).Update(val, Ec_relatedlists.Attribute.Relation_id); Response.Write("修改用户信息成功"); } Response.End(); }
protected void Page_Load(object sender, EventArgs e) { //���б�����ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��һ����¼ if (Request["DelRelation_id"] != null) { int re = BLLTable<Ec_relatedlists>.Factory(conn).Delete(Ec_relatedlists.Attribute.Relation_id, Request["DelRelation_id"]); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���б�������ɾ����ť��ͨ��AJAXִ������ĺ�̨���룬ɾ��������¼ if (Request["DelKeyIDS"] != null) { Ec_relatedlists cond = new Ec_relatedlists(); cond.In(Ec_relatedlists.Attribute.Relation_id, Request["DelKeyIDS"]); int re = BLLTable<Ec_relatedlists>.Factory(conn).Delete(cond); if (re > 0) { Response.Write("1");//����������� ����0 ��ʾ�����ɹ���Ҳ����ֱ����� �ַ������ͻ��˽��������ַ�����Ϣ��Ϊ��ʾ } else { Response.Write("ɾ��ʧ�ܣ�"); } } //���û���ϸ��Ϣ�鿴�༭ҳ�棬�㱣��ʱ��ͨ��AJAXִ������ĺ�̨���룬ʵ�ֲ����ֶεĸ��� if (Request["saveInfo"] != null) { Ec_relatedlists val = new Ec_relatedlists(); val.Relation_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<Ec_relatedlists>.Factory(conn).Update(val, Ec_relatedlists.Attribute.Relation_id); Response.Write("���û���Ϣ�ɹ�"); } Response.End(); }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new Ec_relatedlists(); if(txtRelation_id.Value !="" ) condObj.Like_OR(Ec_relatedlists.Attribute.Relation_id, Convert.ToInt32(txtRelation_id.Value)); if(txtTabid.Value !="" ) condObj.Like_OR(Ec_relatedlists.Attribute.Tabid, Convert.ToInt32(txtTabid.Value)); if(txtRelated_tabid.Value !="" ) condObj.Like_OR(Ec_relatedlists.Attribute.Related_tabid, Convert.ToInt32(txtRelated_tabid.Value)); if(txtName.Value !="" ) condObj.Like_OR(Ec_relatedlists.Attribute.Name, Convert.ToString(txtName.Value)); if(txtSequence.Value !="" ) condObj.Like_OR(Ec_relatedlists.Attribute.Sequence, Convert.ToInt32(txtSequence.Value)); if(txtLabel.Value !="" ) condObj.Like_OR(Ec_relatedlists.Attribute.Label, Convert.ToString(txtLabel.Value)); if(txtPresence.Value !="" ) condObj.Like_OR(Ec_relatedlists.Attribute.Presence, Convert.ToInt32(txtPresence.Value)); if(txtTabTableName.Value !="" ) condObj.Like_OR(Ec_relatedlists.Attribute.TabTableName, Convert.ToString(txtTabTableName.Value)); if(txtColumnName_PK.Value !="" ) condObj.Like_OR(Ec_relatedlists.Attribute.ColumnName_PK, Convert.ToString(txtColumnName_PK.Value)); if(txtColumnName_FK.Value !="" ) condObj.Like_OR(Ec_relatedlists.Attribute.ColumnName_FK, Convert.ToString(txtColumnName_FK.Value)); if(txtRelated_tabTableName.Value !="" ) condObj.Like_OR(Ec_relatedlists.Attribute.Related_tabTableName, Convert.ToString(txtRelated_tabTableName.Value)); try { hidCondition.Value = condObj.ToJson(20); listObj = BLLTable<Ec_relatedlists>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void aspPager_PageChanged(object sender, EventArgs e) { try { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <Ec_relatedlists>(hidCondition.Value); } listObj = BLLTable <Ec_relatedlists> .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(Ec_relatedlists condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序 { condObj.af_PageBy(Ec_relatedlists.Attribute.Relation_id, Order.Desc); } #region//数据权限条件 #endregion //condObj.PID = decimal.Parse(pid); listObj = BLLTable <Ec_relatedlists> .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<Ec_relatedlists>(hidCondition.Value); } listObj = BLLTable<Ec_relatedlists>.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 Ec_relatedlists(); if(txtRelation_id.Value !="" ) condObj.Like(Ec_relatedlists.Attribute.Relation_id, Convert.ToInt32(txtRelation_id.Value)); if(txtTabid.Value !="" ) condObj.Like(Ec_relatedlists.Attribute.Tabid, Convert.ToInt32(txtTabid.Value)); if(txtRelated_tabid.Value !="" ) condObj.Like(Ec_relatedlists.Attribute.Related_tabid, Convert.ToInt32(txtRelated_tabid.Value)); if(txtName.Value !="" ) condObj.Like(Ec_relatedlists.Attribute.Name, Convert.ToString(txtName.Value)); if(txtSequence.Value !="" ) condObj.Like(Ec_relatedlists.Attribute.Sequence, Convert.ToInt32(txtSequence.Value)); if(txtLabel.Value !="" ) condObj.Like(Ec_relatedlists.Attribute.Label, Convert.ToString(txtLabel.Value)); if(txtPresence.Value !="" ) condObj.Like(Ec_relatedlists.Attribute.Presence, Convert.ToInt32(txtPresence.Value)); if(txtTabTableName.Value !="" ) condObj.Like(Ec_relatedlists.Attribute.TabTableName, Convert.ToString(txtTabTableName.Value)); if(txtColumnName_PK.Value !="" ) condObj.Like(Ec_relatedlists.Attribute.ColumnName_PK, Convert.ToString(txtColumnName_PK.Value)); if(txtColumnName_FK.Value !="" ) condObj.Like(Ec_relatedlists.Attribute.ColumnName_FK, Convert.ToString(txtColumnName_FK.Value)); if(txtRelated_tabTableName.Value !="" ) condObj.Like(Ec_relatedlists.Attribute.Related_tabTableName, Convert.ToString(txtRelated_tabTableName.Value)); hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
private void BindList(Ec_relatedlists condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ����������������� condObj.af_PageBy(Ec_relatedlists.Attribute.Relation_id, Order.Desc); #region//����Ȩ������ #endregion //condObj.PID = decimal.Parse(pid); listObj = BLLTable<Ec_relatedlists>.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 Ec_relatedlists(); if (txtRelation_id.Value != "") { condObj.Like_OR(Ec_relatedlists.Attribute.Relation_id, Convert.ToInt32(txtRelation_id.Value)); } if (txtTabid.Value != "") { condObj.Like_OR(Ec_relatedlists.Attribute.Tabid, Convert.ToInt32(txtTabid.Value)); } if (txtRelated_tabid.Value != "") { condObj.Like_OR(Ec_relatedlists.Attribute.Related_tabid, Convert.ToInt32(txtRelated_tabid.Value)); } if (txtName.Value != "") { condObj.Like_OR(Ec_relatedlists.Attribute.Name, Convert.ToString(txtName.Value)); } if (txtSequence.Value != "") { condObj.Like_OR(Ec_relatedlists.Attribute.Sequence, Convert.ToInt32(txtSequence.Value)); } if (txtLabel.Value != "") { condObj.Like_OR(Ec_relatedlists.Attribute.Label, Convert.ToString(txtLabel.Value)); } if (txtPresence.Value != "") { condObj.Like_OR(Ec_relatedlists.Attribute.Presence, Convert.ToInt32(txtPresence.Value)); } if (txtTabTableName.Value != "") { condObj.Like_OR(Ec_relatedlists.Attribute.TabTableName, Convert.ToString(txtTabTableName.Value)); } if (txtColumnName_PK.Value != "") { condObj.Like_OR(Ec_relatedlists.Attribute.ColumnName_PK, Convert.ToString(txtColumnName_PK.Value)); } if (txtColumnName_FK.Value != "") { condObj.Like_OR(Ec_relatedlists.Attribute.ColumnName_FK, Convert.ToString(txtColumnName_FK.Value)); } if (txtRelated_tabTableName.Value != "") { condObj.Like_OR(Ec_relatedlists.Attribute.Related_tabTableName, Convert.ToString(txtRelated_tabTableName.Value)); } try { hidCondition.Value = condObj.ToJson(20); listObj = BLLTable <Ec_relatedlists> .Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, 1, ref recount); repList.DataSource = listObj; repList.DataBind(); } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void btnSetPageSize_Click(object sender, EventArgs e) { aspPager.PageSize = int.Parse(txtPageSize.Value); if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<Ec_relatedlists>(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["Relation_id"])) { valObj = BLLTable<Ec_relatedlists>.Factory(conn).GetRowData(Ec_relatedlists.Attribute.Relation_id, Request["Relation_id"]); if(valObj==null) return ; txtRelation_id.Text = Convert.ToString(valObj.Relation_id);//Convert.ToInt32 txtTabid.Text = Convert.ToString(valObj.Tabid);//Convert.ToInt32 txtRelated_tabid.Text = Convert.ToString(valObj.Related_tabid);//Convert.ToInt32 txtName.Text = Convert.ToString(valObj.Name);//Convert.ToString txtSequence.Text = Convert.ToString(valObj.Sequence);//Convert.ToInt32 txtLabel.Text = Convert.ToString(valObj.Label);//Convert.ToString txtPresence.Text = Convert.ToString(valObj.Presence);//Convert.ToInt32 txtTabTableName.Text = Convert.ToString(valObj.TabTableName);//Convert.ToString txtColumnName_PK.Text = Convert.ToString(valObj.ColumnName_PK);//Convert.ToString txtColumnName_FK.Text = Convert.ToString(valObj.ColumnName_FK);//Convert.ToString txtRelated_tabTableName.Text = Convert.ToString(valObj.Related_tabTableName);//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; if (!IsPostBack) { try { if (!string.IsNullOrEmpty(Request["Relation_id"])) { valObj = BLLTable <Ec_relatedlists> .Factory(conn).GetRowData(Ec_relatedlists.Attribute.Relation_id, Request["Relation_id"]); if (valObj == null) { return; } txtRelation_id.Text = Convert.ToString(valObj.Relation_id);//Convert.ToInt32 txtTabid.Text = Convert.ToString(valObj.Tabid);//Convert.ToInt32 txtRelated_tabid.Text = Convert.ToString(valObj.Related_tabid);//Convert.ToInt32 txtName.Text = Convert.ToString(valObj.Name);//Convert.ToString txtSequence.Text = Convert.ToString(valObj.Sequence);//Convert.ToInt32 txtLabel.Text = Convert.ToString(valObj.Label);//Convert.ToString txtPresence.Text = Convert.ToString(valObj.Presence);//Convert.ToInt32 txtTabTableName.Text = Convert.ToString(valObj.TabTableName);//Convert.ToString txtColumnName_PK.Text = Convert.ToString(valObj.ColumnName_PK);//Convert.ToString txtColumnName_FK.Text = Convert.ToString(valObj.ColumnName_FK);//Convert.ToString txtRelated_tabTableName.Text = Convert.ToString(valObj.Related_tabTableName);//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 btnOK_Click(object sender, EventArgs e) { try { Ec_relatedlists valObj = new Ec_relatedlists(); if (txtRelation_id.Value != "") { valObj.Relation_id = Convert.ToInt32(txtRelation_id.Value); } if (txtTabid.Value != "") { valObj.Tabid = Convert.ToInt32(txtTabid.Value); } if (txtRelated_tabid.Value != "") { valObj.Related_tabid = Convert.ToInt32(txtRelated_tabid.Value); } if (txtName.Value != "") { valObj.Name = Convert.ToString(txtName.Value); } if (txtSequence.Value != "") { valObj.Sequence = Convert.ToInt32(txtSequence.Value); } if (txtLabel.Value != "") { valObj.Label = Convert.ToString(txtLabel.Value); } if (txtPresence.Value != "") { valObj.Presence = Convert.ToInt32(txtPresence.Value); } if (txtTabTableName.Value != "") { valObj.TabTableName = Convert.ToString(txtTabTableName.Value); } if (txtColumnName_PK.Value != "") { valObj.ColumnName_PK = Convert.ToString(txtColumnName_PK.Value); } if (txtColumnName_FK.Value != "") { valObj.ColumnName_FK = Convert.ToString(txtColumnName_FK.Value); } if (txtRelated_tabTableName.Value != "") { valObj.Related_tabTableName = Convert.ToString(txtRelated_tabTableName.Value); } if (keyid != "") { valObj.Relation_id = Convert.ToInt32(keyid); count = BLLTable <Ec_relatedlists> .Factory(conn).Update(valObj, Ec_relatedlists.Attribute.Relation_id); } else { count = BLLTable <Ec_relatedlists> .Factory(conn).Insert(valObj, Ec_relatedlists.Attribute.Relation_id); keyid = valObj.Relation_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", "window.returnValue=\"" + dataStr + "\";window.close();", true); } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "window.returnValue=\"re\";window.close();", true); } } else { txtRelation_id.Value = ""; txtTabid.Value = ""; txtRelated_tabid.Value = ""; txtName.Value = ""; txtSequence.Value = ""; txtLabel.Value = ""; txtPresence.Value = ""; txtTabTableName.Value = ""; txtColumnName_PK.Value = ""; txtColumnName_FK.Value = ""; txtRelated_tabTableName.Value = ""; } } } catch (Exception ex) { litWarn.Text = ex.Message; } }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new Ec_relatedlists(); if (txtRelation_id.Value != "") { condObj.Like(Ec_relatedlists.Attribute.Relation_id, Convert.ToInt32(txtRelation_id.Value)); } if (txtTabid.Value != "") { condObj.Like(Ec_relatedlists.Attribute.Tabid, Convert.ToInt32(txtTabid.Value)); } if (txtRelated_tabid.Value != "") { condObj.Like(Ec_relatedlists.Attribute.Related_tabid, Convert.ToInt32(txtRelated_tabid.Value)); } if (txtName.Value != "") { condObj.Like(Ec_relatedlists.Attribute.Name, Convert.ToString(txtName.Value)); } if (txtSequence.Value != "") { condObj.Like(Ec_relatedlists.Attribute.Sequence, Convert.ToInt32(txtSequence.Value)); } if (txtLabel.Value != "") { condObj.Like(Ec_relatedlists.Attribute.Label, Convert.ToString(txtLabel.Value)); } if (txtPresence.Value != "") { condObj.Like(Ec_relatedlists.Attribute.Presence, Convert.ToInt32(txtPresence.Value)); } if (txtTabTableName.Value != "") { condObj.Like(Ec_relatedlists.Attribute.TabTableName, Convert.ToString(txtTabTableName.Value)); } if (txtColumnName_PK.Value != "") { condObj.Like(Ec_relatedlists.Attribute.ColumnName_PK, Convert.ToString(txtColumnName_PK.Value)); } if (txtColumnName_FK.Value != "") { condObj.Like(Ec_relatedlists.Attribute.ColumnName_FK, Convert.ToString(txtColumnName_FK.Value)); } if (txtRelated_tabTableName.Value != "") { condObj.Like(Ec_relatedlists.Attribute.Related_tabTableName, Convert.ToString(txtRelated_tabTableName.Value)); } hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
protected void btnOK_Click(object sender, EventArgs e) { try { Ec_relatedlists valObj = new Ec_relatedlists(); if(txtRelation_id.Value !="" ) valObj.Relation_id = Convert.ToInt32(txtRelation_id.Value); if(txtTabid.Value !="" ) valObj.Tabid = Convert.ToInt32(txtTabid.Value); if(txtRelated_tabid.Value !="" ) valObj.Related_tabid = Convert.ToInt32(txtRelated_tabid.Value); if(txtName.Value !="" ) valObj.Name = Convert.ToString(txtName.Value); if(txtSequence.Value !="" ) valObj.Sequence = Convert.ToInt32(txtSequence.Value); if(txtLabel.Value !="" ) valObj.Label = Convert.ToString(txtLabel.Value); if(txtPresence.Value !="" ) valObj.Presence = Convert.ToInt32(txtPresence.Value); if(txtTabTableName.Value !="" ) valObj.TabTableName = Convert.ToString(txtTabTableName.Value); if(txtColumnName_PK.Value !="" ) valObj.ColumnName_PK = Convert.ToString(txtColumnName_PK.Value); if(txtColumnName_FK.Value !="" ) valObj.ColumnName_FK = Convert.ToString(txtColumnName_FK.Value); if(txtRelated_tabTableName.Value !="" ) valObj.Related_tabTableName = Convert.ToString(txtRelated_tabTableName.Value); if (keyid != "") { valObj.Relation_id = Convert.ToInt32(keyid); count = BLLTable<Ec_relatedlists>.Factory(conn).Update(valObj, Ec_relatedlists.Attribute.Relation_id); } else { count = BLLTable<Ec_relatedlists>.Factory(conn).Insert(valObj, Ec_relatedlists.Attribute.Relation_id); keyid = valObj.Relation_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", "window.returnValue=\"" + dataStr + "\";window.close();", true); } else { ScriptManager.RegisterStartupScript(Page, this.GetType(), "goto", "window.returnValue=\"re\";window.close();", true); } } else { txtRelation_id.Value =""; txtTabid.Value =""; txtRelated_tabid.Value =""; txtName.Value =""; txtSequence.Value =""; txtLabel.Value =""; txtPresence.Value =""; txtTabTableName.Value =""; txtColumnName_PK.Value =""; txtColumnName_FK.Value =""; txtRelated_tabTableName.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["Relation_id"])) { keyid = Request["Relation_id"]; } if (!string.IsNullOrEmpty(Request["KeyID"])) { keyid = Request["KeyID"]; } if (!IsPostBack) { this.txtRelation_id.Disabled = true; this.txtRelation_id.Value = "0"; this.txtRelation_id.Attributes["class"] = "dis"; try { if (keyid != "") { valObj = BLLTable<Ec_relatedlists>.Factory(conn).GetRowData(Ec_relatedlists.Attribute.Relation_id, keyid); if(valObj==null) return ; txtRelation_id.Value = Convert.ToString(valObj.Relation_id);//Convert.ToInt32 txtTabid.Value = Convert.ToString(valObj.Tabid);//Convert.ToInt32 txtRelated_tabid.Value = Convert.ToString(valObj.Related_tabid);//Convert.ToInt32 txtName.Value = Convert.ToString(valObj.Name);//Convert.ToString txtSequence.Value = Convert.ToString(valObj.Sequence);//Convert.ToInt32 txtLabel.Value = Convert.ToString(valObj.Label);//Convert.ToString txtPresence.Value = Convert.ToString(valObj.Presence);//Convert.ToInt32 txtTabTableName.Value = Convert.ToString(valObj.TabTableName);//Convert.ToString txtColumnName_PK.Value = Convert.ToString(valObj.ColumnName_PK);//Convert.ToString txtColumnName_FK.Value = Convert.ToString(valObj.ColumnName_FK);//Convert.ToString txtRelated_tabTableName.Value = Convert.ToString(valObj.Related_tabTableName);//Convert.ToString } } catch (Exception ex) { litWarn.Text = ex.Message; } } }
protected void Page_Load(object sender, EventArgs e) { #region//Ĭ�����ص��� //hideTableColumnList = new List<AttributeItem>(); //hideTableColumnList.Add(Ec_relatedlists.Attribute.EXP1); //hideTableColumnList.Add(Ec_relatedlists.Attribute.EXP2); //hideTableColumnList.Add(Ec_relatedlists.Attribute.EXP3); //valObj.LoadAllAttributes(true);//��ʱ�Ӵ˴��룬�Ժ��ܸ��½�����Ҫ //valObj.Remove(hideTableColumnList); //hideFindColumnList = new List<AttributeItem>(); //hideFindColumnList.Add(Ec_relatedlists.Attribute.EXP1); //hideFindColumnList.Add(Ec_relatedlists.Attribute.EXP2); //hideFindColumnList.Add(Ec_relatedlists.Attribute.EXP3); #endregion condObj.OrderBy(Ec_relatedlists.Attribute.Relation_id, Order.Desc); if (!IsPostBack) { btnFind.Text = LanguageService.GetLanguageString("btnFind", "��ѯ"); aspPager.PageSize = 10; aspPager.CurrentPageIndex = 1; if (!string.IsNullOrEmpty(Request["ids"])) { Ec_relatedlists roleOld = new Ec_relatedlists(); roleOld.Where(Ec_relatedlists.Attribute.Relation_id, Request["ids"].ToString()); listObj = BLLTable<Ec_relatedlists>.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].Relation_id + "',Name:'" + listObj[i].Relation_id + "'}";//�����Name������ʾ���б��У��������ض��塣 hidInitIDS.Value += listObj[i].Relation_id; } } try { listObj = BLLTable<Ec_relatedlists>.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; } } }