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));
}