/// <summary>
/// 根据条件获得合同号列表
/// </summary>
/// <param name="companyId">公司编号</param>
/// <param name="info">查询</param>
/// <returns></returns>
public IList <Model.ConStructure.MContractNumList> GetAutocompleteHeTongs(string companyId, EyouSoft.Model.ConStructure.MAutocompleteChaXunInfo info)
{
IList <EyouSoft.Model.ConStructure.MContractNumList> ResultList = null;
string sql = string.Empty;
sql += string.Format(" SELECT TOP {0} [ContractId],[ContractCode] FROM [tbl_ContractNum] ", info.Length);
sql += string.Format(" WHERE [CompanyId]='{0}' AND [IsDelete]='0' ", companyId);
if (!string.IsNullOrEmpty(info.HeTongCode))
{
sql += string.Format(" AND [ContractCode] LIKE '%{0}%' ", info.HeTongCode);
}
if (info.LeiXing.HasValue)
{
sql += string.Format(" AND [ContractType]={0} ", (int)info.LeiXing.Value);
}
if (info.Status.HasValue || !string.IsNullOrEmpty(info.HeTongId))
{
sql += " AND(1=0 ";
if (info.Status.HasValue)
{
sql += string.Format(" OR [ContractStatus]={0} ", (int)info.Status.Value);
}
if (!string.IsNullOrEmpty(info.HeTongId))
{
sql += string.Format(" OR [ContractId]='{0}' ", info.HeTongId);
}
sql += " ) ";
}
DbCommand dc = this._db.GetSqlStringCommand(sql);
using (IDataReader dr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(dc, this._db))
{
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.GetString(dr.GetOrdinal("ContractId"));
model.ContractCode = dr["ContractCode"].ToString();
ResultList.Add(model);
}
};
return(ResultList);
}
/// <summary>
/// 根据合同编号获得合同号列表
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <param name="Ids">合同号ids</param>
/// <returns></returns>
public IList <Model.ConStructure.MContractNumList> GetContractNumList(string CompanyId, params string[] Ids)
{
StringBuilder sId = new StringBuilder();
for (int i = 0; i < Ids.Length; i++)
{
sId.AppendFormat("'{0}',", Ids[i]);
}
sId.Remove(sId.Length - 1, 1);
IList <EyouSoft.Model.ConStructure.MContractNumList> ResultList = null;
string sql = string.Format("SELECT ContractId,CompanyId,ContractType,ContractCode,CollarTime,UseName,OrderCode,RouteName,BuyCompanyName,Adults,Childs,Others,SumPrice,SellerName,ContractStatus from view_ContractNum where CompanyId='{0}' and ContractId in ({1})", CompanyId, sId.ToString());
DbCommand dc = this._db.GetSqlStringCommand(sql);
using (IDataReader dr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(dc, this._db))
{
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.UseName = !dr.IsDBNull(dr.GetOrdinal("UseName")) ? dr.GetString(dr.GetOrdinal("UseName")) : "";
model.OrderCode = !dr.IsDBNull(dr.GetOrdinal("OrderCode")) ? dr.GetString(dr.GetOrdinal("OrderCode")) : "";
model.RouteName = !dr.IsDBNull(dr.GetOrdinal("RouteName")) ? dr.GetString(dr.GetOrdinal("RouteName")) : "";
model.BuyCompanyName = !dr.IsDBNull(dr.GetOrdinal("BuyCompanyName")) ? dr.GetString(dr.GetOrdinal("BuyCompanyName")) : "";
model.Adults = !dr.IsDBNull(dr.GetOrdinal("Adults")) ? dr.GetInt32(dr.GetOrdinal("Adults")) : 0;
model.Childs = !dr.IsDBNull(dr.GetOrdinal("Childs")) ? dr.GetInt32(dr.GetOrdinal("Childs")) : 0;
model.Others = !dr.IsDBNull(dr.GetOrdinal("Others")) ? dr.GetInt32(dr.GetOrdinal("Others")) : 0;
model.SumPrice = !dr.IsDBNull(dr.GetOrdinal("SumPrice")) ? dr.GetDecimal(dr.GetOrdinal("SumPrice")) : 0;
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);
}
/// <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);
}
