protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<V_CRM_CUSTTOMER>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
protected void aspPager_PageChanged(object sender, EventArgs e) { if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson <V_CRM_CUSTTOMER>(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 <V_CRM_CUSTTOMER>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }
private void BindList(V_CRM_CUSTTOMER condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//如果不存在用户定义的分页排序属性,则用主键属性排序 { condObj.af_PageBy(V_CRM_CUSTTOMER.Attribute.Cus_ID, Order.Desc); } #region//数据权限条件 #endregion //condObj.PID = decimal.Parse(pid); listObj = BLLTable <V_CRM_CUSTTOMER> .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 V_CRM_CUSTTOMER(); if (txtCus_ID.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.Cus_ID, Convert.ToInt32(txtCus_ID.Value)); } if (txtCompanyName.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.CompanyName, Convert.ToString(txtCompanyName.Value)); } if (txtCompanyAddress.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.CompanyAddress, Convert.ToString(txtCompanyAddress.Value)); } if (txtShopName.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.ShopName, Convert.ToString(txtShopName.Value)); } if (txtShopNameURL.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.ShopNameURL, Convert.ToString(txtShopNameURL.Value)); } if (txtCustSex.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.CustSex, Convert.ToInt32(txtCustSex.Value)); } if (txtBirthday.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.Birthday, Convert.ToDateTime(txtBirthday.Value)); } if (txtWangWangId.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.WangWangId, Convert.ToString(txtWangWangId.Value)); } if (txtCustQQ.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.CustQQ, Convert.ToString(txtCustQQ.Value)); } if (txtLastEditors.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.LastEditors, Convert.ToString(txtLastEditors.Value)); } if (txtCus_Name.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.Cus_Name, Convert.ToString(txtCus_Name.Value)); } if (txtJob.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.Job, Convert.ToString(txtJob.Value)); } if (txtRelationTxt.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.RelationTxt, Convert.ToString(txtRelationTxt.Value)); } if (txtRecorder.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.Recorder, Convert.ToString(txtRecorder.Value)); } if (txtPhone.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.Phone, Convert.ToString(txtPhone.Value)); } if (txtContactName.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.ContactName, Convert.ToString(txtContactName.Value)); } if (txtEmail.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.Email, Convert.ToString(txtEmail.Value)); } if (txtAddress.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.Address, Convert.ToString(txtAddress.Value)); } if (txtTrade.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.Trade, Convert.ToString(txtTrade.Value)); } if (txtType.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.Type, Convert.ToInt32(txtType.Value)); } if (txtState.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.State, Convert.ToInt32(txtState.Value)); } if (txtIsSign.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.IsSign, Convert.ToInt32(txtIsSign.Value)); } if (txtAddTime.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.AddTime, Convert.ToDateTime(txtAddTime.Value)); } if (txtEditTime.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.EditTime, Convert.ToDateTime(txtEditTime.Value)); } if (txtLoadHighSeasTime.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.LoadHighSeasTime, Convert.ToDateTime(txtLoadHighSeasTime.Value)); } if (txtMobPhone.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.MobPhone, Convert.ToString(txtMobPhone.Value)); } if (txtPATH.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.PATH, Convert.ToString(txtPATH.Value)); } if (txtPNAME.Value != "") { condObj.Like(V_CRM_CUSTTOMER.Attribute.PNAME, Convert.ToString(txtPNAME.Value)); } hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
protected void btnFind_Click(object sender, EventArgs e) { condObj = new V_CRM_CUSTTOMER(); if(txtCus_ID.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.Cus_ID, Convert.ToInt32(txtCus_ID.Value)); if(txtCompanyName.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.CompanyName, Convert.ToString(txtCompanyName.Value)); if(txtCompanyAddress.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.CompanyAddress, Convert.ToString(txtCompanyAddress.Value)); if(txtShopName.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.ShopName, Convert.ToString(txtShopName.Value)); if(txtShopNameURL.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.ShopNameURL, Convert.ToString(txtShopNameURL.Value)); if(txtCustSex.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.CustSex, Convert.ToInt32(txtCustSex.Value)); if(txtBirthday.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.Birthday, Convert.ToDateTime(txtBirthday.Value)); if(txtWangWangId.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.WangWangId, Convert.ToString(txtWangWangId.Value)); if(txtCustQQ.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.CustQQ, Convert.ToString(txtCustQQ.Value)); if(txtLastEditors.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.LastEditors, Convert.ToString(txtLastEditors.Value)); if(txtCus_Name.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.Cus_Name, Convert.ToString(txtCus_Name.Value)); if(txtJob.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.Job, Convert.ToString(txtJob.Value)); if(txtRelationTxt.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.RelationTxt, Convert.ToString(txtRelationTxt.Value)); if(txtRecorder.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.Recorder, Convert.ToString(txtRecorder.Value)); if(txtPhone.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.Phone, Convert.ToString(txtPhone.Value)); if(txtContactName.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.ContactName, Convert.ToString(txtContactName.Value)); if(txtEmail.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.Email, Convert.ToString(txtEmail.Value)); if(txtAddress.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.Address, Convert.ToString(txtAddress.Value)); if(txtTrade.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.Trade, Convert.ToString(txtTrade.Value)); if(txtType.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.Type, Convert.ToInt32(txtType.Value)); if(txtState.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.State, Convert.ToInt32(txtState.Value)); if(txtIsSign.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.IsSign, Convert.ToInt32(txtIsSign.Value)); if(txtAddTime.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.AddTime, Convert.ToDateTime(txtAddTime.Value)); if(txtEditTime.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.EditTime, Convert.ToDateTime(txtEditTime.Value)); if(txtLoadHighSeasTime.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.LoadHighSeasTime, Convert.ToDateTime(txtLoadHighSeasTime.Value)); if(txtMobPhone.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.MobPhone, Convert.ToString(txtMobPhone.Value)); if(txtPATH.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.PATH, Convert.ToString(txtPATH.Value)); if(txtPNAME.Value !="" ) condObj.Like(V_CRM_CUSTTOMER.Attribute.PNAME, Convert.ToString(txtPNAME.Value)); hidCondition.Value = condObj.ToJson(20); BindList(condObj, 1); }
private void BindList(V_CRM_CUSTTOMER condObj, int curPage) { if (condObj.af_PageByAttributeItem == null)//����������û�����ķ�ҳ�������ԣ����������������� condObj.af_PageBy(V_CRM_CUSTTOMER.Attribute.Cus_ID, Order.Desc); #region//����Ȩ������ #endregion //condObj.PID = decimal.Parse(pid); listObj = BLLTable<V_CRM_CUSTTOMER>.Factory(conn).SelectByPage(valObj, condObj, aspPager.PageSize, curPage, ref recount); repList.DataSource = listObj; repList.DataBind(); aspPager.RecordCount = recount; }
protected void btnSetPageSize_Click(object sender, EventArgs e) { aspPager.PageSize = int.Parse(txtPageSize.Value); if (hidCondition.Value != "") { condObj = JsonServiceBase.FromJson<V_CRM_CUSTTOMER>(hidCondition.Value); } BindList(condObj, aspPager.CurrentPageIndex); }