///// <summary>
///// 获?取¨?所¨′有?D订?单ì￡¤
///// </summary>
///// <param name="model"></param>
///// <returns></returns>
//public DataSet GetOrders(string ID, string PartitionCode)
//{
// string strSql = @"SELECT * FROM dbo.CR_ORDER_RECORD_INFO WHERE INOUT_RECODE_ID = '{0}' AND PARTITION_CODE ='{1}' ";
// strSql = string.Format(strSql, ID, PartitionCode);
// return DbHelperSQL.Query(strSql.ToString());
//}
/// <summary>
/// 获?取¨?所¨′有?D订?单ì￡¤
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public DataSet GetOrders(Core.Model.CR_INOUT_RECODE model)
{
string strSql = @"SELECT * FROM dbo.CR_ORDER_RECORD_INFO WHERE INOUT_RECODE_ID = '{0}' ";
strSql = string.Format(strSql, model.ID);
return(DbHelperSQL.Query(strSql.ToString()));
}
/// <summary>
/// 获?取¨?当ì?à前??区?域?¨°所¨′有?D订?单ì￡¤
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public Core.Model.CR_ORDER_RECORD_INFO GetCurrentPartitionOrder(Core.Model.CR_INOUT_RECODE model)
{
string strSql = @"SELECT TOP 1 * FROM dbo.CR_ORDER_RECORD_INFO
WHERE PARTITION_CODE = '{0}'
AND INOUT_RECODE_ID = '{1}' ";
strSql = string.Format(strSql, model.CURR_PARTITION_CODE, model.ID);
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/*
* /// <summary>
* /// 分页获取数据列表
* /// </summary>
* public DataSet GetList(int PageSize,int PageIndex,string strWhere)
* {
* SqlParameter[] parameters = {
* new SqlParameter("@tblName", SqlDbType.VarChar, 255),
* new SqlParameter("@fldName", SqlDbType.VarChar, 255),
* new SqlParameter("@PageSize", SqlDbType.Int),
* new SqlParameter("@PageIndex", SqlDbType.Int),
* new SqlParameter("@IsReCount", SqlDbType.Bit),
* new SqlParameter("@OrderType", SqlDbType.Bit),
* new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
* };
* parameters[0].Value = "CR_INOUT_RECODE";
* parameters[1].Value = "ID";
* parameters[2].Value = PageSize;
* parameters[3].Value = PageIndex;
* parameters[4].Value = 0;
* parameters[5].Value = 0;
* parameters[6].Value = strWhere;
* return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
* }*/
#endregion BasicMethod
#region ExtensionMethod
/// <summary>
/// 获?取¨?占?用??车|ì位?记?录?
/// </summary>
/// <param name="recordInfo"></param>
/// <returns></returns>
public List <Parking.Core.Model.CR_INOUT_RECODE> GetInOccupyRecordList(ProcessRecord recordInfo)
{
StringBuilder strSql = new StringBuilder();
string[] InOuts = recordInfo.INOUT_RECODE.OccupyIds.Split(',');
string strInOuts = string.Empty;
foreach (var temp in InOuts)
{
strInOuts += "'" + temp + "',";
}
strInOuts = strInOuts.TrimEnd(',');
strSql.Append(@"SELECT VEHICLE_NO,IN_TIME,OUT_TIME FROM dbo.CR_INOUT_RECODE WHERE ID IN(" + strInOuts + @")");
strSql.Append(" UNION ALL ");
strSql.Append(@"SELECT VEHICLE_NO,IN_TIME,OUT_TIME FROM dbo.CR_INOUT_RECODE_ARCHIVE WHERE ID IN(" + strInOuts + @")");
DataSet ds = DbHelperSQL.Query(string.Format(strSql.ToString()));
List <Parking.Core.Model.CR_INOUT_RECODE> list = new List <Parking.Core.Model.CR_INOUT_RECODE>();
foreach (DataRow row in ds.Tables[0].Rows)
{
Parking.Core.Model.CR_INOUT_RECODE model = new Core.Model.CR_INOUT_RECODE();
if (row["IN_TIME"] != null && row["IN_TIME"].ToString() != "")
{
model.IN_TIME = Convert.ToDateTime(row["IN_TIME"].ToString());
}
if (row["OUT_TIME"] != null && row["OUT_TIME"].ToString() != "")
{
model.OUT_TIME = Convert.ToDateTime(row["OUT_TIME"].ToString());
}
if (row["VEHICLE_NO"] != null)
{
model.VEHICLE_NO = row["VEHICLE_NO"].ToString();
}
list.Add(model);
}
return(list);
}
/// <summary>
/// 获?取¨?当ì?à前??区?域?¨°所¨′有?D订?单ì￡¤
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public Core.Model.CR_ORDER_RECORD_INFO GetCurrentPartitionOrder(Core.Model.CR_INOUT_RECODE model)
{
return(dal.GetCurrentPartitionOrder(model));
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public List <Core.Model.CR_ORDER_RECORD_INFO> GetOrders(Core.Model.CR_INOUT_RECODE model)
{
DataSet ds = dal.GetOrders(model);
return(DataTableToList(ds.Tables[0]));
}
