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); }
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())) { 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); } 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> >(); if (customerPOList == null) { customerPOList = new List <CustomerPO>(); } customerPOList.ForEach(i => { customerVOList.Add(Mapper.Map <CustomerPO, CustomerVO>(i)); }); return(customerVOList); }
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)); }
public int GetRecordCount(CustomerQueryEntity filter) { CustomerData custdata = new CustomerData(); return(custdata.GetRecordCount(filter)); }
public int GetRecordCount(CustomerQueryEntity filter) { throw new NotImplementedException(); }
List <CustomerVO> ICustomerMgm.GetCustomers(CustomerQueryEntity filter) { throw new NotImplementedException(); }
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], "desc"); 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], "CustomerID"); if (sortName == "CardFlagDesc" || sortName == "ClubCardDesc" || sortName == "CarDesc" || sortName == "Operation") { sortName = "CustomerID"; } 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 }; ICustomerMgm coustomer = new CustomerMgm(); var list = coustomer.GetCustomers(filter); if (list == null) { list = new List <CustomerVO>(); } int recordsTotal = coustomer.GetRecordCount(filter); 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)' onclick='Customer.EditClubcard(" + item.DT_RowId + ")'><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)' onclick='Customer.AddCludcard(" + item.DT_RowId + ")'> <i class='fa fa-credit-card'></i> 开卡</a>"; } item.CarDesc = "<a href='javascript:void(0)' onclick='Customer.EditCar(" + item.DT_RowId + ")'><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='Customer.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) { result.data = new List <CustomerVO>(); LogHandler.Error(ex.Message.ToString()); result.error = ex.ToString(); } return(Json(result, JsonRequestBehavior.AllowGet)); }