/// <summary>
/// 车牌修正数据(报表)
/// </summary>
/// <param name="parkcode"></param>
/// <returns></returns>
public List <CorrectCarnoModel> AllCorrectCarno(CorrectCarnoSearch model)
{
//批量数据都从数据库获取 redis并不缓存此实体
try
{
List <CorrectCarnoModel> list = _iReportContext.AllCorrectCarno(model) as List <CorrectCarnoModel>;
return(list);
}
catch (Exception ex)
{
return(null);
}
}
/// <summary>
/// 车牌修正数据(报表)
/// </summary>
/// <param name="parkcode"></param>
/// <returns></returns>
public List <CorrectCarnoModel> AllCorrectCarno(CorrectCarnoSearch model)
{
//批量数据都从数据库获取 redis并不缓存此实体
try
{
List <CorrectCarnoModel> list = carnoRecorddatabaseoperate.GetFromDataBaseByPage(model) as List <CorrectCarnoModel>;
return(list);
}
catch (Exception ex)
{
return(null);
}
}
public IHttpActionResult SearchCorrectCarnoRecord(CorrectCarnoRequest requestModel)
{
ResponseBasePaper <CorrectCarnoModel> response = new ResponseBasePaper <CorrectCarnoModel>()
{
IsSuccess = true,
MessageCode = (int)ApiBaseErrorCode.API_SUCCESS,
MessageContent = ApiBaseErrorCode.API_SUCCESS.ToString(),
Result = new List <CorrectCarnoModel>()
};
if (string.IsNullOrWhiteSpace(requestModel.ProjectGuid) ||
string.IsNullOrWhiteSpace(requestModel.ParkingCode) ||
requestModel.PageIndex <= 0 || requestModel.PageSize <= 0)
{
response.IsSuccess = false;
response.MessageCode = (int)ApiBaseErrorCode.API_PARAM_ERROR;
response.MessageContent = "必要参数格式不对,请检查";
return(Ok(response));
}
try
{
CorrectCarnoSearch searchModel = new CorrectCarnoSearch();
searchModel.PageIndex = requestModel.PageIndex;
searchModel.PageSize = requestModel.PageSize;
searchModel.ProjectGuid = requestModel.ProjectGuid;
searchModel.ParkingCode = requestModel.ParkingCode;
searchModel.OperationType = requestModel.OperationType;
searchModel.OldCarno = requestModel.OldCarno;
searchModel.NewCarno = requestModel.NewCarno;
searchModel.Operator = requestModel.Operator;
searchModel.StrTime = requestModel.StrTime;
searchModel.EndTime = requestModel.EndTime;
List <CorrectCarnoModel> list = _reportManager.AllCorrectCarno(searchModel);
response.Result = list;
response.TotalCount = searchModel.TotalCount;
}
catch (Exception ex)
{
response.IsSuccess = false;
response.MessageCode = (int)ApiBaseErrorCode.API_FAIL;
response.MessageContent = "请检查参数格式是否符合";
}
return(Ok(response));
}
public IList <CorrectCarnoModel> GetFromDataBaseByPage <T>(T model)
{
CorrectCarnoSearch searchModel = model as CorrectCarnoSearch;
List <CorrectCarnoModel> list = null;
MysqlHelper dbhelper = new MysqlHelper("name=parklotManager", "MySql.Data.MySqlClient");
DataTable table = new DataTable();
//车牌修正列表
string cmdText = " SELECT * FROM t_correctcarno INNER JOIN (SELECT id FROM t_correctcarno {0}"
+ $" ORDER BY id DESC LIMIT {(searchModel.PageIndex - 1) * searchModel.PageSize},{searchModel.PageSize}) AS page USING(id); ";
//查询条件cmd
string whereText = $" WHERE projectGuid = '{searchModel.ProjectGuid}' and parkCode = '{searchModel.ParkingCode}' ";
if (!string.IsNullOrEmpty(searchModel.OldCarno))
{
whereText += $" and ( oldcarNo = '{searchModel.OldCarno}' or oldcarNo like '%{searchModel.OldCarno}%')";
}
if (!string.IsNullOrEmpty(searchModel.NewCarno))
{
whereText += $" and (newCarno = '{searchModel.NewCarno}' or newCarno like '%{searchModel.NewCarno}%')";
}
if (!string.IsNullOrEmpty(searchModel.Operator))
{
whereText += $" and operator = '{searchModel.Operator}' ";
}
if (searchModel.StrTime != null && searchModel.StrTime != DateTime.MinValue)
{
whereText += $" and evnetTime >= '{searchModel.StrTime}' ";
}
if (searchModel.EndTime != null && searchModel.EndTime != DateTime.MinValue)
{
whereText += $" and evnetTime <= '{searchModel.StrTime}' ";
}
cmdText = string.Format(cmdText, whereText);
//总条数cmd
string cmdTextCount = "SELECT COUNT(*) FROM t_correctcarno " + whereText;
long count = (long)dbhelper.ExecuteScalar(cmdTextCount);
if (count <= 0)
{
return(list);
}
searchModel.TotalCount = count;
table = dbhelper.ExecuteDataTable(cmdText);
if (table == null || table.Rows.Count <= 0)
{
return(list);
}
list = new List <CorrectCarnoModel>();
foreach (DataRow item in table.Rows)
{
CorrectCarnoModel csm = new CorrectCarnoModel()
{
ProjectGuid = item["projectGuid"].ToString(),
ParkingCode = item["parkCode"].ToString(),
OperationType = (int)item["operationtype"],
OldCarno = item["oldcarNo"].ToString(),
NewCarno = item["newCarno"].ToString(),
InTime = Convert.ToDateTime(item["evnetTime"]),
ThroughName = item["throughName"].ToString(),
Discerncamera = item["discerncamera"].ToString(),
ImgUrl = item["imgUrl"].ToString(),
Operator = item["operator"].ToString()
};
list.Add(csm);
}
table.Clear();
return(list);
}
