//查询
public IEnumerable <CRMDriver> GetCRMDriverByConditionNoPaging(CRMDriverSearchCondition SearchCondition)
{
string sqlWhere = this.GenGetCRMDriverWhere(SearchCondition);
DbParam[] dbParams = new DbParam[] {
new DbParam("@Where", DbType.String, sqlWhere, ParameterDirection.Input)
};
return(this.ExecuteDataTable("Proc_GetCRMDriverByConditionNoPaging", dbParams).ConvertToEntityCollection <CRMDriver>());
}
//查询及页数。。
public IEnumerable <CRMDriver> GetCRMDriverByCondition(CRMDriverSearchCondition Driver, int PageIndex, int PageSize, out int RowCount)
{
string sqlWhere = this.GenGetCRMDriverWhere(Driver);
int tempRowCount = 0;
DbParam[] dbParams = new DbParam[] {
new DbParam("@Where", DbType.String, sqlWhere, ParameterDirection.Input),
new DbParam("@PageIndex", DbType.Int32, PageIndex, ParameterDirection.Input),
new DbParam("@PageSize", DbType.Int32, PageSize, ParameterDirection.Input),
new DbParam("@RowCount", DbType.Int32, tempRowCount, ParameterDirection.Output)
};
DataTable dt = this.ExecuteDataTable("Proc_GetCRMDriverByCondition", dbParams);
RowCount = (int)dbParams[3].Value;
return(dt.ConvertToEntityCollection <CRMDriver>());
}
private string GenGetCRMDriverWhere(CRMDriverSearchCondition SearchCondition)
{
StringBuilder sb = new StringBuilder();
//司机姓名
if (!string.IsNullOrEmpty(SearchCondition.DriverName))
{
sb.Append(" AND CRM_Driver.DriverName like '%").Append(SearchCondition.DriverName).Append("%' ");
}
//物流公司
if (!string.IsNullOrEmpty(SearchCondition.DriverLogisticsCompany))
{
sb.Append(" AND CRM_Driver.DriverLogisticsCompany like '%").Append(SearchCondition.DriverLogisticsCompany).Append("%' ");
}
//联系电话
if (!string.IsNullOrEmpty(SearchCondition.DriverPhone))
{
sb.Append(" AND CRM_Driver.DriverPhone like '%").Append(SearchCondition.DriverPhone).Append("%' ");
}
//开始为服务日期
if (!string.IsNullOrEmpty(SearchCondition.StartServeForRunbowTime))
{
sb.Append(" and CRM_Driver.DriverStartServeForRunbowDate>='").Append(SearchCondition.StartServeForRunbowTime).Append("'");
//sb.Append(" AND CRM_Driver.DriverStartServeForRunbowDate='").Append(SearchCondition.DriverStartServeForRunbowDate).Append("' ");
}
if (!string.IsNullOrEmpty(SearchCondition.EndServeForRunbowTime))
{
sb.Append(" and CRM_Driver.DriverStartServeForRunbowDate<='").Append(SearchCondition.EndServeForRunbowTime).Append("'");
//sb.Append(" AND CRM_Driver.DriverStartServeForRunbowDate='").Append(SearchCondition.DriverStartServeForRunbowDate).Append("' ");
}
//身份证号码
if (!string.IsNullOrEmpty(SearchCondition.DriverIDCard))
{
sb.Append(" AND CRM_Driver.DriverIDCard like '%").Append(SearchCondition.DriverIDCard).Append("%' ");
}
//驾驶证档案号
if (!string.IsNullOrEmpty(SearchCondition.DriverCardNo))
{
sb.Append(" AND CRM_Driver.DriverCardNo like '%").Append(SearchCondition.DriverCardNo).Append("%' ");
}
//是否在服务中
if (!string.IsNullOrEmpty(SearchCondition.DriverIsServing))
{
sb.Append(" AND CRM_Driver.DriverIsServing='").Append(SearchCondition.DriverIsServing).Append("' ");
}
//驾照类型
if (!string.IsNullOrEmpty(SearchCondition.DriverCardType))
{
sb.Append(" AND CRM_Driver.DriverCardType='").Append(SearchCondition.DriverCardType).Append("' ");
}
//登记证签发地
if (!string.IsNullOrEmpty(SearchCondition.DriverRegistrationCardSignedAddress))
{
sb.Append(" AND CRM_Driver.DriverRegistrationCardSignedAddress like '%").Append(SearchCondition.DriverRegistrationCardSignedAddress).Append("%' ");
}
//服务区域
if (!string.IsNullOrEmpty(SearchCondition.DriverServiceArea))
{
sb.Append(" AND CRM_Driver.DriverServiceArea like '%").Append(SearchCondition.DriverServiceArea).Append("%' ");
}
//驾驶车辆牌号
if (!string.IsNullOrEmpty(SearchCondition.DriverCarNo))
{
sb.Append(" AND CRM_Driver.DriverCarNo like '%").Append(SearchCondition.DriverCarNo).Append("%' ");
}
//主要行驶路线
if (!string.IsNullOrEmpty(SearchCondition.DriverMainRoute))
{
sb.Append(" AND CRM_Driver.DriverMainRoute like '%").Append(SearchCondition.DriverMainRoute).Append("%' ");
}
return(sb.ToString());
}
