/// <summary>
/// 根据条件获得合同号列表
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <param name="ContractType">合同类型(0:国内，1：境外，2：所有)</param>
/// <param name="SearchModel">查询参数实体</param>
/// <param name="PageSize">页面数据总记录数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">每页显示的记录数</param>
/// <returns></returns>
public IList <Model.ConStructure.MContractNumList> GetContractNumList(string CompanyId, int ContractType, Model.ConStructure.MContractNumSearch SearchModel, int PageSize, int PageIndex, ref int RecordCount)
{
IList <Model.ConStructure.MContractNumList> list = null;
if (!string.IsNullOrEmpty(CompanyId))
{
list = new List <Model.ConStructure.MContractNumList>();
list = dal.GetContractNumList(CompanyId, ContractType, SearchModel, PageSize, PageIndex, ref RecordCount);
}
return(list);
}
/// <summary>
/// 根据条件获得合同号列表
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <param name="ContractType">合同类型</param>
/// <param name="SearchModel">查询参数实体</param>
/// <param name="PageSize">页面数据总记录数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">每页显示的记录数</param>
/// <returns></returns>
public IList <Model.ConStructure.MContractNumList> GetContractNumList(string CompanyId, int ContractType, Model.ConStructure.MContractNumSearch SearchModel, int PageSize, int PageIndex, ref int RecordCount)
{
IList <EyouSoft.Model.ConStructure.MContractNumList> ResultList = null;
string tableName = "view_ContractNum";
string identityColumnName = "ContractId";
string fields = "ContractId,CompanyId,ContractType,ContractCode,DepartId,TourId,CollarTime,UseId,UseName,OrderId,OrderCode,RouteId,RouteName,BuyCompanyId,BuyCompanyName,Adults,Childs,Others,SumPrice,SellerId,SellerName,ContractStatus,IssueTime ";
string query = string.Format(" CompanyId='{0}' AND ContractType = {1} ", CompanyId, ContractType);
if (SearchModel != null)
{
if (!string.IsNullOrEmpty(SearchModel.ContractCode))
{
query = query + string.Format(" AND ContractCode LIKE '%{0}%' ", SearchModel.ContractCode);
}
if (!string.IsNullOrEmpty(SearchModel.UseId))
{
query = query + string.Format(" AND UseId = '{0}' ", SearchModel.UseId);
}
if (!string.IsNullOrEmpty(SearchModel.UseName))
{
query = query + string.Format(" AND UseName LIKE '%{0}%' ", SearchModel.UseName);
}
if (SearchModel.TimeStart != null)
{
query = query + string.Format(" AND CollarTime >= '{0}' ", SearchModel.TimeStart.Value.ToShortDateString() + " 00:00:00");
}
if (SearchModel.TimeEnd != null)
{
query = query + string.Format(" AND CollarTime <= '{0}' ", SearchModel.TimeEnd.Value.ToShortDateString() + " 23:59:59");
}
if (SearchModel.ContractStatus != null)
{
query = query + string.Format(" AND ContractStatus = {0} ", (int)SearchModel.ContractStatus);
}
}
string orderByString = "ContractCode ASC";
using (IDataReader dr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(_db, PageSize, PageIndex, ref RecordCount, tableName, identityColumnName, fields, query, orderByString))
{
ResultList = new List <EyouSoft.Model.ConStructure.MContractNumList>();
EyouSoft.Model.ConStructure.MContractNumList model = null;
while (dr.Read())
{
model = new EyouSoft.Model.ConStructure.MContractNumList();
model.ContractId = !dr.IsDBNull(dr.GetOrdinal("ContractId")) ? dr.GetString(dr.GetOrdinal("ContractId")) : "";
model.ContractCode = !dr.IsDBNull(dr.GetOrdinal("ContractCode")) ? dr.GetString(dr.GetOrdinal("ContractCode")) : "";
if (!dr.IsDBNull(dr.GetOrdinal("CollarTime")))
{
model.CollarTime = dr.GetDateTime(dr.GetOrdinal("CollarTime"));
}
model.UseId = !dr.IsDBNull(dr.GetOrdinal("UseId")) ? dr.GetString(dr.GetOrdinal("UseId")) : "";
model.UseName = !dr.IsDBNull(dr.GetOrdinal("UseName")) ? dr.GetString(dr.GetOrdinal("UseName")) : "";
model.TourId = !dr.IsDBNull(dr.GetOrdinal("TourId")) ? dr.GetString(dr.GetOrdinal("TourId")) : "";
model.OrderId = !dr.IsDBNull(dr.GetOrdinal("OrderId")) ? dr.GetString(dr.GetOrdinal("OrderId")) : "";
model.OrderCode = !dr.IsDBNull(dr.GetOrdinal("OrderCode")) ? dr.GetString(dr.GetOrdinal("OrderCode")) : "";
model.RouteId = !dr.IsDBNull(dr.GetOrdinal("RouteId")) ? dr.GetString(dr.GetOrdinal("RouteId")) : "";
model.RouteName = !dr.IsDBNull(dr.GetOrdinal("RouteName")) ? dr.GetString(dr.GetOrdinal("RouteName")) : "";
model.BuyCompanyId = !dr.IsDBNull(dr.GetOrdinal("BuyCompanyId")) ? dr.GetString(dr.GetOrdinal("BuyCompanyId")) : "";
model.BuyCompanyName = !dr.IsDBNull(dr.GetOrdinal("BuyCompanyName")) ? dr.GetString(dr.GetOrdinal("BuyCompanyName")) : "";
model.Adults = !dr.IsDBNull(dr.GetOrdinal("Adults")) ? dr.GetInt32(dr.GetOrdinal("Adults")) : -1;
model.Childs = !dr.IsDBNull(dr.GetOrdinal("Childs")) ? dr.GetInt32(dr.GetOrdinal("Childs")) : -1;
model.Others = !dr.IsDBNull(dr.GetOrdinal("Others")) ? dr.GetInt32(dr.GetOrdinal("Others")) : -1;
model.SumPrice = !dr.IsDBNull(dr.GetOrdinal("SumPrice")) ? dr.GetDecimal(dr.GetOrdinal("SumPrice")) : -1;
model.SellerId = !dr.IsDBNull(dr.GetOrdinal("SellerId")) ? dr.GetString(dr.GetOrdinal("SellerId")) : "";
model.SellerName = !dr.IsDBNull(dr.GetOrdinal("SellerName")) ? dr.GetString(dr.GetOrdinal("SellerName")) : "";
model.ContractStatus = (EyouSoft.Model.EnumType.ConStructure.ContractStatus)dr.GetByte(dr.GetOrdinal("ContractStatus"));
ResultList.Add(model);
model = null;
}
};
return(ResultList);
}
