public System.Data.DataSet GetCustomers(CustomerQueryEntity filter) { StringBuilder strSql1 = new StringBuilder(); StringBuilder strSql2 = new StringBuilder(); if (!string.IsNullOrEmpty(filter.Name.Trim())) { strSql1.AppendFormat(" Name like '%{0}%' ", filter.Name); } if (!string.IsNullOrEmpty(filter.MobileNo.Trim())) { strSql1.AppendFormat(" And MobileNO like '%{0}%' ", filter.MobileNo); } if (!string.IsNullOrEmpty(filter.ICNo.Trim())) { strSql1.AppendFormat(" And ICNo like '%{0}%' ", filter.ICNo); } strSql1.AppendFormat(" And CardFlag = {0} ", filter.CardFlag); if (!string.IsNullOrEmpty(filter.SortName.Trim())) { strSql2.Append(filter.SortName); strSql2.Append(" "); strSql2.Append(filter.SortOrder.Trim()); } string strWhere = strSql1.ToString(); string orderby = strSql2.ToString(); int startIndex = filter.Start; int endIndex = startIndex + filter.Length; return _daoCustomer.GetListByPage(strWhere, orderby, startIndex, endIndex); }
public List<CustomerVO> GetCustomers(CustomerQueryEntity filter) { CustomerData customerData = new CustomerData(); List<CustomerVO> customerVOList = new List<CustomerVO>(); DataSet ds = customerData.GetCustomers(filter); List<CustomerPO> customerPOList = ds.GetEntity<List<CustomerPO>>(); customerPOList.ForEach(i => { customerVOList.Add(Mapper.Map<CustomerPO, CustomerVO>(i)); }); return customerVOList; }
public int GetRecordCount(CustomerQueryEntity filter) { CustomerData custdata = new CustomerData(); return custdata.GetRecordCount(filter); }
public JsonResult GetCustomers() { DatatablesResult<CustomerVO> result = new DatatablesResult<CustomerVO>(); try { int start = NullHelper.Convert<int>(Request[Constants.PAGE_START], 0); int length = NullHelper.Convert<int>(Request[Constants.PAGE_LENGTH], 10); int draw = NullHelper.Convert<int>(Request[Constants.REQ_DRAW], 1); string sortOrder = NullHelper.Convert<string>(Request[Constants.SORT_ORDER], "asc"); int sortIdx = NullHelper.Convert<int>(Request[Constants.SORT_IDX], 0); string columnKey = string.Format(Constants.SORT_NAME, sortIdx); string sortName = NullHelper.Convert<string>(Request[columnKey], "Name"); string name = NullHelper.Convert<string>(Request["Name"], ""); string icNo = NullHelper.Convert<string>(Request["ICNo"], ""); string mobileNo = NullHelper.Convert<string>(Request["MobileNo"], ""); int cardFlag = NullHelper.Convert<int>(Request["CardFlag"], -1); CustomerQueryEntity filter = new CustomerQueryEntity(){ Start = start, Length = length, SortOrder = sortOrder, SortName = sortName, Name = name, ICNo = icNo, MobileNo = mobileNo, CardFlag = cardFlag }; var mocker = new BizMocker(); var list = mocker.GetCustomers(filter); int recordsTotal = list.Count; foreach (var item in list) { item.DT_RowId = item.CustomerID.ToString(); if (item.CardFlag == 1) { item.CardFlagDesc = "<i class='fa fa-check fa-lg' style='color:green;'></i>"; item.ClubCardDesc = "<a href='javascript:void(0)'><i class='fa fa-search'></i> 查看</a>"; } else { item.CardFlagDesc = "<i class='fa fa-times fa-lg red' style='color:red;'></i>"; item.ClubCardDesc = "<a href='javascript:void(0)'> <i class='fa fa-credit-card'></i> 开卡</a>"; } item.CarDesc = "<a href='javascript:void(0)'><i class='fa fa-search'></i> 查看</a>"; item.Operation = "<a href='javascript:void(0)' onclick='Customer.Edit(" + item.DT_RowId + ")'><i class='fa fa-pencil'></i> 编辑</a> | <a href='javascript:void(0)' onclick='Package.Del(" + item.DT_RowId + ")'><i class='fa fa-times'></i> 删除</a>"; } result.draw = draw; result.recordsTotal = recordsTotal; result.recordsFiltered = recordsTotal; result.data = list; } catch (Exception ex) { LogHandler.Error(ex.Message.ToString()); } return Json(result, JsonRequestBehavior.AllowGet); }
public List<CustomerVO> GetCustomers(CustomerQueryEntity filter) { List<CustomerVO> result = new List<CustomerVO>(); #region Mock CustomerVO item1 = new CustomerVO(){ CardFlag = 1, CustomerID = 1, MobileNO = "15852659874", Name = "田志良" }; CustomerVO item2 = new CustomerVO() { CardFlag = 0, CustomerID = 2, MobileNO = "12687458596", Name = "郭艳艳" }; CustomerVO item3 = new CustomerVO() { CardFlag = 1, CustomerID = 3, MobileNO = "16358748965", Name = "程彩琪" }; CustomerVO item4 = new CustomerVO() { CardFlag = 0, CustomerID = 4, MobileNO = "15234951965", Name = "任东东" }; CustomerVO item5 = new CustomerVO() { CardFlag = 1, CustomerID = 5, MobileNO = "12365847596", Name = "刘勇" }; result.Add(item1); result.Add(item2); result.Add(item3); result.Add(item4); result.Add(item5); #endregion return result; }
List<CustomerVO> ICustomerMgm.GetCustomers(CustomerQueryEntity filter) { throw new NotImplementedException(); }
public int GetRecordCount(CustomerQueryEntity filter) { throw new NotImplementedException(); }
public int GetRecordCount(CustomerQueryEntity filter) { StringBuilder strSql1 = new StringBuilder(); if (!string.IsNullOrEmpty(filter.Name.Trim())) { strSql1.AppendFormat(" Name like '%{0}%' ", filter.Name); } if (!string.IsNullOrEmpty(filter.MobileNo.Trim())) { if (strSql1.Length > 0) strSql1.AppendFormat(" And "); strSql1.AppendFormat(" MobileNO like '%{0}%' ", filter.MobileNo); } if (!string.IsNullOrEmpty(filter.ICNo.Trim())) { if (strSql1.Length > 0) strSql1.AppendFormat(" And "); strSql1.AppendFormat(" ICNo like '%{0}%' ", filter.ICNo); } if (filter.CardFlag != -1) { if (strSql1.Length > 0) strSql1.AppendFormat(" And "); strSql1.AppendFormat(" CardFlag = {0} ", filter.CardFlag); } string strWhere = strSql1.ToString(); return _daoCustomer.GetRecordCount(strWhere); }