private void RptBind(string _strWhere, string _orderby) { this.page = DTRequest.GetQueryInt("page", 1); txtTelPhone.Text = this.telphone; txtNickname.Text = this.nickname; BLL.t_customer bll = new BLL.t_customer(); this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount); this.rptList.DataBind(); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("sys_customer_list.aspx", "telphone={0}&nickname={1}&page={2}", telphone, nickname, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(LingLong.Admin.Model.t_templatemessage model) { //发送消息 BLL.t_message meaagebll = new BLL.t_message(); if (model.Type == 1) { //服务人员 需要门店信息 BLL.t_business businessbll = new BLL.t_business(); var result = businessbll.GetListOther(string.Format(" b.OpenId='{0}' ", model.OpenId)); if (result.Tables[0].Rows.Count == 0) { meaagebll.Add(new Model.t_message { StoreId = 1, SendOpenId = "System", SendUserId = 1, AcceptOpenId = model.OpenId, AcceptUserId = 1, Content = model.Message, MessageType = 0, SendTime = DateTime.Now, State = 0, IsDeleted = 0, CreationTime = DateTime.Now }); } else { for (int i = 0; i < result.Tables[0].Rows.Count; i++) { var openid = result.Tables[0].Rows[i]["OpenId"].ToString(); var storeid = result.Tables[0].Rows[i]["StoreId"].ToString(); var id = result.Tables[0].Rows[i]["BusinessId"].ToString(); meaagebll.Add(new Model.t_message { StoreId = int.Parse(storeid), SendOpenId = "System", SendUserId = 1, AcceptOpenId = openid, AcceptUserId = int.Parse(id), Content = model.Message, MessageType = 0, SendTime = DateTime.Now, State = 0, IsDeleted = 0, CreationTime = DateTime.Now }); } } } if (model.Type == 2) { //客户 BLL.t_customer customerbll = new BLL.t_customer(); var result = customerbll.GetList(" IsDeleted=0 and CustomerType=0"); for (int i = 0; i < result.Tables[0].Rows.Count; i++) { var openid = result.Tables[0].Rows[i]["OpenId"].ToString(); var id = result.Tables[0].Rows[i]["ID"].ToString(); meaagebll.Add(new Model.t_message { StoreId = 1, SendOpenId = "System", SendUserId = 1, AcceptOpenId = openid, AcceptUserId = int.Parse(id), Content = model.Message, MessageType = 0, SendTime = DateTime.Now, State = 0, IsDeleted = 0, CreationTime = DateTime.Now }); } } if (model.Type == 3) { //服务人员 需要门店信息 BLL.t_business businessbll = new BLL.t_business(); var result = businessbll.GetListOther(""); for (int i = 0; i < result.Tables[0].Rows.Count; i++) { var openid = result.Tables[0].Rows[i]["OpenId"].ToString(); var storeid = result.Tables[0].Rows[i]["StoreId"].ToString(); var id = result.Tables[0].Rows[i]["BusinessId"].ToString(); meaagebll.Add(new Model.t_message { StoreId = int.Parse(storeid), SendOpenId = "System", SendUserId = 1, AcceptOpenId = openid, AcceptUserId = int.Parse(id), Content = model.Message, MessageType = 0, SendTime = DateTime.Now, State = 0, IsDeleted = 0, CreationTime = DateTime.Now }); } } return(dal.Add(model)); }