/// <summary> /// 增加一条订单评价信息 /// </summary> /// <param name="model">订单评价信息实体</param> /// <returns>受影响行数</returns> public virtual int AddRateOrder(EyouSoft.Model.TourStructure.RateOrder model) { DbCommand dc = base.TourStore.GetSqlStringCommand(Sql_RateOrder_Add); #region 参数赋值 base.TourStore.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, model.ID); base.TourStore.AddInParameter(dc, "BuyCompanyId", DbType.AnsiStringFixedLength, model.BuyCompanyId); base.TourStore.AddInParameter(dc, "BuyCompanyName", DbType.String, model.BuyCompanyName); base.TourStore.AddInParameter(dc, "BuyUserId", DbType.AnsiStringFixedLength, model.BuyUserId); base.TourStore.AddInParameter(dc, "BuyUserContactName", DbType.String, model.BuyUserContactName); base.TourStore.AddInParameter(dc, "SellCompanyId", DbType.AnsiStringFixedLength, model.SellCompanyId); base.TourStore.AddInParameter(dc, "RateType", DbType.Byte, (int)model.RateType); base.TourStore.AddInParameter(dc, "ServiceQuality", DbType.Decimal, model.ServiceQuality); base.TourStore.AddInParameter(dc, "PriceQuality", DbType.Decimal, model.PriceQuality); base.TourStore.AddInParameter(dc, "TravelPlan", DbType.Decimal, model.TravelPlan); base.TourStore.AddInParameter(dc, "AgreeLevel", DbType.Decimal, model.AgreeLevel); base.TourStore.AddInParameter(dc, "RateScore", DbType.Decimal, model.RateScore); base.TourStore.AddInParameter(dc, "RateContent", DbType.String, model.RateContent); base.TourStore.AddInParameter(dc, "OrderId", DbType.AnsiStringFixedLength, model.OrderId); base.TourStore.AddInParameter(dc, "TourId", DbType.AnsiStringFixedLength, model.TourId); base.TourStore.AddInParameter(dc, "RouteName", DbType.String, model.RouteName); base.TourStore.AddInParameter(dc, "SettlePeoplePrice", DbType.Decimal, model.SettlePeoplePrice); base.TourStore.AddInParameter(dc, "SettleChildPrice", DbType.Decimal, model.SettleChildPrice); base.TourStore.AddInParameter(dc, "IssueTime", DbType.DateTime, model.IssueTime); base.TourStore.AddInParameter(dc, "ExpireTime", DbType.DateTime, model.ExpireTime); base.TourStore.AddInParameter(dc, "IsSystemRate", DbType.AnsiStringFixedLength, model.IsSystemRate ? "1" : "0"); #endregion return(DbHelper.ExecuteSql(dc, base.TourStore)); }
/// <summary> /// 更新一条订单评价信息,评论日期不更新 /// </summary> /// <param name="model">订单评价信息实体</param> /// <returns>0:Error;1:Success</returns> public int UpdateRateOrderById(EyouSoft.Model.TourStructure.RateOrder model) { if (model == null) { return(0); } if (dal.UpdateRateOrderById(model) > 0) { return(1); } else { return(0); } }
/// <summary> /// 增加一条订单评价信息 /// </summary> /// <param name="model">订单评价信息实体</param> /// <returns>0:Error;1:Success</returns> public int AddRateOrder(EyouSoft.Model.TourStructure.RateOrder model) { if (model == null) { return(0); } if (dal.AddRateOrder(model) > 0) { return(1); } else { return(0); } }
/// <summary> /// 更新一条订单评价信息(只更新评价部分,订单、团队、公司、用户以及评价时间不更新) /// </summary> /// <param name="model">订单评价信息实体</param> /// <returns>受影响行数</returns> public virtual int UpdateRateOrderById(EyouSoft.Model.TourStructure.RateOrder model) { DbCommand dc = base.TourStore.GetSqlStringCommand(Sql_RateOrder_Update); #region 参数赋值 base.TourStore.AddInParameter(dc, "RateType", DbType.Byte, (int)model.RateType); base.TourStore.AddInParameter(dc, "ServiceQuality", DbType.Decimal, model.ServiceQuality); base.TourStore.AddInParameter(dc, "PriceQuality", DbType.Decimal, model.PriceQuality); base.TourStore.AddInParameter(dc, "TravelPlan", DbType.Decimal, model.TravelPlan); base.TourStore.AddInParameter(dc, "AgreeLevel", DbType.Decimal, model.AgreeLevel); base.TourStore.AddInParameter(dc, "RateScore", DbType.Decimal, model.RateScore); base.TourStore.AddInParameter(dc, "RateContent", DbType.String, model.RateContent); base.TourStore.AddInParameter(dc, "SettlePeoplePrice", DbType.Decimal, model.SettlePeoplePrice); base.TourStore.AddInParameter(dc, "SettleChildPrice", DbType.Decimal, model.SettleChildPrice); base.TourStore.AddInParameter(dc, "ID", DbType.AnsiStringFixedLength, model.ID); #endregion return(DbHelper.ExecuteSql(dc, base.TourStore)); }
/// <summary> /// 执行查询命令返回订单评价实体集合 /// </summary> /// <param name="dc">查询命令</param> /// <returns>返回订单评价实体集合</returns> private IList <EyouSoft.Model.TourStructure.RateOrder> GetQueryList(DbCommand dc) { IList <EyouSoft.Model.TourStructure.RateOrder> list = new List <EyouSoft.Model.TourStructure.RateOrder>(); using (IDataReader dr = base.TourStore.ExecuteReader(dc)) { EyouSoft.Model.TourStructure.RateOrder model = null; while (dr.Read()) { model = new EyouSoft.Model.TourStructure.RateOrder(); model.ID = dr[0].ToString(); model.BuyCompanyId = dr[1].ToString(); model.BuyCompanyName = dr[2].ToString(); model.BuyUserId = dr[3].ToString(); model.BuyUserContactName = dr[4].ToString(); model.SellCompanyId = dr[5].ToString(); if (!dr.IsDBNull(6)) { model.RateType = (Model.TourStructure.RateType)dr.GetInt32(6); } if (!dr.IsDBNull(7)) { model.ServiceQuality = dr.GetDecimal(7); } if (!dr.IsDBNull(8)) { model.PriceQuality = dr.GetDecimal(8); } if (!dr.IsDBNull(9)) { model.TravelPlan = dr.GetDecimal(9); } if (!dr.IsDBNull(10)) { model.AgreeLevel = dr.GetDecimal(10); } if (!dr.IsDBNull(11)) { model.RateScore = dr.GetDecimal(11); } model.RateContent = dr[12].ToString(); model.OrderId = dr[13].ToString(); model.TourId = dr[14].ToString(); model.RouteName = dr[15].ToString(); if (!dr.IsDBNull(16)) { model.SettlePeoplePrice = dr.GetDecimal(16); } if (!dr.IsDBNull(17)) { model.SettleChildPrice = dr.GetDecimal(17); } if (!dr.IsDBNull(18)) { model.IssueTime = dr.GetDateTime(18); } if (!dr.IsDBNull(19)) { model.ExpireTime = dr.GetDateTime(19); } if (!dr.IsDBNull(20)) { model.IsSystemRate = dr[20].ToString() == "1" ? true : false; } list.Add(model); } model = null; } return(list); }
/// <summary> /// 获取某一公司作为卖家时所有的订单评价数据 /// </summary> /// <param name="PageSize">每页条数</param> /// <param name="PageIndex">当前页数</param> /// <param name="RecordCount">总记录数</param> /// <param name="OrderIndex">排序索引,0:IssueTime升序;1:IssueTime降序</param> /// <param name="SellCompanyId">卖家公司ID(必须传值)</param> /// <param name="RateType">评价类型(小于等于0不作条件)</param> /// <returns></returns> public virtual IList <EyouSoft.Model.TourStructure.RateOrder> GetRateOrderList(int PageSize, int PageIndex, ref int RecordCount, int OrderIndex, string SellCompanyId, int RateType) { IList <EyouSoft.Model.TourStructure.RateOrder> list = new List <EyouSoft.Model.TourStructure.RateOrder>(); string strFiles = " [ID],[BuyCompanyId],[BuyCompanyName],[BuyUserId],[BuyUserContactName],[SellCompanyId],[RateType],[ServiceQuality],[PriceQuality],[TravelPlan],[AgreeLevel],[RateScore],[RateContent],[OrderId],[TourId],[RouteName],[SettlePeoplePrice],[SettleChildPrice],[IssueTime],[ExpireTime],[IsSystemRate] "; string strOrder = string.Empty; string strWhere = string.Format(" [SellCompanyId] = '{0}' ", SellCompanyId); if (RateType > 0) { strWhere += string.Format(" and RateType = {0} ", RateType); } switch (OrderIndex) { case 0: strOrder = " [IssueTime] asc "; break; case 1: strOrder = " [IssueTime] desc "; break; default: strOrder = " [IssueTime] desc "; break; } using (IDataReader dr = DbHelper.ExecuteReader(base.TourStore, PageSize, PageIndex, ref RecordCount, "tbl_RateOrder", "[ID]", strFiles, strWhere, strOrder)) { EyouSoft.Model.TourStructure.RateOrder model = null; while (dr.Read()) { model = new EyouSoft.Model.TourStructure.RateOrder(); model.ID = dr[0].ToString(); model.BuyCompanyId = dr[1].ToString(); model.BuyCompanyName = dr[2].ToString(); model.BuyUserId = dr[3].ToString(); model.BuyUserContactName = dr[4].ToString(); model.SellCompanyId = dr[5].ToString(); if (!dr.IsDBNull(6)) { model.RateType = (Model.TourStructure.RateType)dr.GetInt32(6); } if (!dr.IsDBNull(7)) { model.ServiceQuality = dr.GetDecimal(7); } if (!dr.IsDBNull(8)) { model.PriceQuality = dr.GetDecimal(8); } if (!dr.IsDBNull(9)) { model.TravelPlan = dr.GetDecimal(9); } if (!dr.IsDBNull(10)) { model.AgreeLevel = dr.GetDecimal(10); } if (!dr.IsDBNull(11)) { model.RateScore = dr.GetDecimal(11); } model.RateContent = dr[12].ToString(); model.OrderId = dr[13].ToString(); model.TourId = dr[14].ToString(); model.RouteName = dr[15].ToString(); if (!dr.IsDBNull(16)) { model.SettlePeoplePrice = dr.GetDecimal(16); } if (!dr.IsDBNull(17)) { model.SettleChildPrice = dr.GetDecimal(17); } if (!dr.IsDBNull(18)) { model.IssueTime = dr.GetDateTime(18); } if (!dr.IsDBNull(19)) { model.ExpireTime = dr.GetDateTime(19); } if (!dr.IsDBNull(20)) { model.IsSystemRate = dr[20].ToString() == "1" ? true : false; } list.Add(model); } model = null; } return(list); }