/// <summary>
/// 获取根据记录总数
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public int GetCountData(TrackRecordParam param)
{
sb?.Clear();
sb.Append(string.Format(@"SELECT COUNT(*) FROM BB_TrackRecord WHERE 1=1 "));
_param?.Clear();
//项目/区域
if (!string.IsNullOrEmpty(param.unit_code))
{
sb.Append(" AND unit_code = @unit_code ");
_param.Add("@unit_code", param.unit_code);
}
else if (!string.IsNullOrEmpty(param.area_code))
{
sb.Append(" AND area_code = @area_code ");
_param.Add("@area_code", param.area_code);
}
else
{
sb.Append(" AND 1=0 ");
}
//状态
if (!string.IsNullOrEmpty(param.trackStatus))
{
sb.Append(" AND tr_status = @tr_status ");
_param.Add("@tr_status", param.trackStatus);
}
//跟踪时间
if (!string.IsNullOrEmpty(param.trackDate))
{
sb.Append(string.Format(" AND CONVERT(varchar(100),track_date,23)=@track_date "));
_param.Add("@track_date", param.trackDate);
}
return(Helper.ToInt(SqlHelper.ExecuteScalar(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param))));
}
/// <summary>
/// 获取跟踪记录集合
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public List <TrackRecordModel> GetInitData(TrackRecordParam param)
{
if (null == param)
{
return(null);
}
return(DBSession.IBB_TrackRecordDAL.GetInitData(param));
}
/// <summary>
/// 获取跟踪记录集合
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public List <TrackRecordModel> GetInitData(TrackRecordParam param)
{
sb?.Clear();
sb.Append(string.Format(@"SELECT TOP {0} tt.*,code.tr_status_text FROM
(SELECT ROW_NUMBER() OVER(ORDER BY tr_id) AS RowNumber,tr_id,area_code,unit_name,unit_code,fa_number,tr_status,
CONVERT(varchar(100),track_date,23) AS track_date,track_name,tr_note FROM BB_TrackRecord WHERE 1=1 ", param.rows));
_param?.Clear();
//项目/区域
if (!string.IsNullOrEmpty(param.unit_code))
{
sb.Append(" AND unit_code = @unit_code ");
_param.Add("@unit_code", param.unit_code);
}
else if (!string.IsNullOrEmpty(param.area_code))
{
sb.Append(" AND area_code = @area_code ");
_param.Add("@area_code", param.area_code);
}
else
{
sb.Append(" AND 1=0 ");
}
//设备编码
if (!string.IsNullOrEmpty(param.fa_number))
{
sb.Append(" AND fa_number = @fa_number ");
_param.Add("@fa_number", param.fa_number);
}
//状态
if (!string.IsNullOrEmpty(param.trackStatus))
{
sb.Append(" AND tr_status = @tr_status ");
_param.Add("@tr_status", param.trackStatus);
}
//跟踪时间
if (!string.IsNullOrEmpty(param.trackDate))
{
sb.Append(string.Format(" AND CONVERT(varchar(100),track_date,23)=@track_date "));
_param.Add("@track_date", param.trackDate);
}
sb.Append(string.Format(@" ) tt LEFT JOIN(SELECT item1.*,item2.* FROM
(SELECT item_id, item_code FROM dbo.T_ItemCode WHERE item_code = 'TrackStatus') item1 INNER JOIN
(SELECT code_name AS tr_status_text, code_value AS tr_status, item_id AS id FROM dbo.T_ItemCodeMenum) item2 ON item1.item_id = item2.id) code ON tt.tr_status = code.tr_status WHERE tt.RowNumber > {0} ORDER BY tt.RowNumber;", (param.page - 1) * param.rows));
DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text, SqlHelper.GetParameters(_param));
return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <TrackRecordModel>(dt));
}
public ActionResult InitTable()
{
string area_code = RequestHelper.GetStrByName("area_code"), //区域代码
unit_code = RequestHelper.GetStrByName("unit_code"), //项目代码
trackStatus = RequestHelper.GetDeStrByName("trackStatus"), //设备状态
trackDate = RequestHelper.GetDeStrByName("trackDate"); //跟踪时间
int page = RequestHelper.GetIntByName("page"),
rows = RequestHelper.GetIntByName("rows");
TrackRecordParam param = new TrackRecordParam {
rows = rows, page = page, unit_code = unit_code, area_code = area_code, trackStatus = trackStatus, trackDate = trackDate
};
List <TrackRecordModel> list = operateContext.bllSession.BB_TrackRecord.GetInitData(param);
TableModel tModel = new TableModel()
{
total = operateContext.bllSession.BB_TrackRecord.GetCountData(param),
rows = list
};
return(Json(tModel, JsonRequestBehavior.AllowGet));
}
public ActionResult GetTrackObjByID()
{
string unit_code = RequestHelper.GetStrByName("unit_code"),
fa_number = RequestHelper.GetStrByName("fa_number");
if (string.IsNullOrEmpty(unit_code) || string.IsNullOrEmpty(fa_number))
{
return(null);
}
TrackRecordParam param = new TrackRecordParam {
rows = 10, page = 1, unit_code = unit_code, fa_number = fa_number
};
List <TrackRecordModel> list = operateContext.bllSession.BB_TrackRecord.GetInitData(param);
if (null == list || list.Count <= 0)
{
return(operateContext.RedirectAjax(1, "数据不存在~", "", ""));
}
return(operateContext.RedirectAjax(0, "数据删除成功~", list.FirstOrDefault(), ""));
}
/// <summary>
/// 获取根据记录总数
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public int GetCountData(TrackRecordParam param)
{
return(DBSession.IBB_TrackRecordDAL.GetCountData(param));
}
