/// <summary> /// 分配收货供应商 /// </summary> /// <returns></returns> public ActionResult SuppliersReceiving() { int _returnXSId = QueryString.IntSafeQ("returnXSId"); ReturnXSEntity entity = ReturnXSBLL.Instance.GetReturnXS(_returnXSId, -1); int _pagesize = CommonKey.PageSizeOrder; int _pageindex = QueryString.IntSafeQ("pageindex", 1); if (_pageindex == 0) { _pageindex = 1; } int _recordCount = 0; IList <ConditionUnit> _wherelist = new List <ConditionUnit>(); _wherelist.Add(new ConditionUnit { FieldName = SearchFieldName.B2BOrderCode, CompareValue = entity.ReturnOrderCode.ToString() }); //订单编号 _wherelist.Add(new ConditionUnit { FieldName = SearchFieldName.ProductId, CompareValue = entity.ProductId.ToString() }); //产品编号 IList <VWCGOrderReturnEntity> _entitylist = CGOrderTakeBLL.Instance.GetCGOrderSuppliers(_pagesize, _pageindex, ref _recordCount, _wherelist); string _url = "/Order/SuppliersReceiving/?returnXSId=" + _returnXSId; string _pageStr = HTMLPage.SetOrderListPage(_recordCount, _pagesize, _pageindex, _url); ViewBag.ReturnXSId = _returnXSId; ViewBag.ReturnType = entity.ReturnType; ViewBag.PageStr = _pageStr; ViewBag.entitylist = _entitylist; return(View()); }
/// <summary> /// 判断当前节点是否已存在相同的 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int ExistNum(ReturnXSEntity entity) { ///id=0,判断总数,ID>0判断除自己之外的总数 string sql = @"Select count(1) from dbo.[ReturnXS] WITH(NOLOCK) "; string where = "where "; if (entity.Id == 0) { where = where + " (ProductName=@ProductName) "; } else { where = where + " id<>@Id and (ProductName=@ProductName) "; } sql = sql + where; DbCommand cmd = db.GetSqlStringCommand(sql); if (entity.Id > 0) { db.AddInParameter(cmd, "@Id", DbType.Int32, entity.Id); } db.AddInParameter(cmd, "@ProductName", DbType.String, entity.ProductName); object identity = db.ExecuteScalar(cmd); if (identity == null || identity == DBNull.Value) { return(0); } return(Convert.ToInt32(identity)); }
/// <summary> /// 读取记录列表。 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public IList <ReturnXSEntity> GetReturnXSAll() { string sql = @"SELECT [Id], [ProductId],[ReturnOrderCode],[ReturnOrderDetailId],[ProductName],[Num],[Price],[ReturnType],[NewOrderCode],[ReturnDescription],[ReturnReason],[CreateTime],[Status],[MemId],[RejectReason],[CheckManId],[CheckTime] from dbo.[ReturnXS] WITH(NOLOCK) "; IList <ReturnXSEntity> entityList = new List <ReturnXSEntity>(); DbCommand cmd = db.GetSqlStringCommand(sql); using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { ReturnXSEntity entity = new ReturnXSEntity(); entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.ProductId = StringUtils.GetDbInt(reader["ProductId"]); entity.ReturnOrderCode = StringUtils.GetDbLong(reader["ReturnOrderCode"]); entity.ReturnOrderDetailId = StringUtils.GetDbInt(reader["ReturnOrderDetailId"]); entity.ProductName = StringUtils.GetDbString(reader["ProductName"]); entity.Num = StringUtils.GetDbInt(reader["Num"]); entity.Price = StringUtils.GetDbDecimal(reader["Price"]); entity.ReturnType = StringUtils.GetDbInt(reader["ReturnType"]); entity.NewOrderCode = StringUtils.GetDbString(reader["NewOrderCode"]); entity.ReturnDescription = StringUtils.GetDbString(reader["ReturnDescription"]); entity.ReturnReason = StringUtils.GetDbString(reader["ReturnReason"]); entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]); entity.Status = StringUtils.GetDbInt(reader["Status"]); entity.MemId = StringUtils.GetDbInt(reader["MemId"]); entity.RejectReason = StringUtils.GetDbString(reader["RejectReason"]); entity.CheckManId = StringUtils.GetDbString(reader["CheckManId"]); entity.CheckTime = StringUtils.GetDbDateTime(reader["CheckTime"]); entityList.Add(entity); } } return(entityList); }
public IList <ReturnXSEntity> GetReturnXSListByMemId(int pagesize, int pageindex, ref int RecordCount, int MemId) { string sql = @"SELECT [AahamaReciveType],[Id], [ProductId],[ReturnOrderCode],[ReturnOrderDetailId],[ProductName],[Num],[Price],[ReturnType],[NewOrderCode],[ReturnDescription],[ReturnReason],[CreateTime],[Status],[MemId],[RejectReason],[CheckManId],[CheckTime] FROM (SELECT ROW_NUMBER() OVER (ORDER BY Id desc) AS ROWNUMBER, [AahamaReciveType],[Id], [ProductId],[ReturnOrderCode],[ReturnOrderDetailId],[ProductName],[Num],[Price],[ReturnType],[NewOrderCode],[ReturnDescription],[ReturnReason],[CreateTime],[Status],[MemId],[RejectReason],[CheckManId],[CheckTime] from dbo.[ReturnXS] WITH(NOLOCK) WHERE MemId=@MemId ) as temp where rownumber BETWEEN ((@PageIndex - 1) * @PageSize + 1) AND @PageIndex * @PageSize" ; string sql2 = @"Select count(1) from dbo.[ReturnXS] with (nolock) "; IList <ReturnXSEntity> entityList = new List <ReturnXSEntity>(); DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@PageIndex", DbType.Int32, pageindex); db.AddInParameter(cmd, "@PageSize", DbType.Int32, pagesize); db.AddInParameter(cmd, "@MemId", DbType.Int32, MemId); using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { ReturnXSEntity entity = new ReturnXSEntity(); entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.ProductId = StringUtils.GetDbInt(reader["ProductId"]); entity.ReturnOrderCode = StringUtils.GetDbLong(reader["ReturnOrderCode"]); entity.ReturnOrderDetailId = StringUtils.GetDbInt(reader["ReturnOrderDetailId"]); entity.ProductName = StringUtils.GetDbString(reader["ProductName"]); entity.Num = StringUtils.GetDbInt(reader["Num"]); entity.Price = StringUtils.GetDbDecimal(reader["Price"]); entity.ReturnType = StringUtils.GetDbInt(reader["ReturnType"]); entity.NewOrderCode = StringUtils.GetDbString(reader["NewOrderCode"]); entity.ReturnDescription = StringUtils.GetDbString(reader["ReturnDescription"]); entity.ReturnReason = StringUtils.GetDbString(reader["ReturnReason"]); entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]); entity.Status = StringUtils.GetDbInt(reader["Status"]); entity.MemId = StringUtils.GetDbInt(reader["MemId"]); entity.RejectReason = StringUtils.GetDbString(reader["RejectReason"]); entity.CheckManId = StringUtils.GetDbString(reader["CheckManId"]); entity.CheckTime = StringUtils.GetDbDateTime(reader["CheckTime"]); entity.AahamaReciveType = StringUtils.GetDbInt(reader["AahamaReciveType"]); entityList.Add(entity); } } cmd = db.GetSqlStringCommand(sql2); using (IDataReader reader = db.ExecuteReader(cmd)) { if (reader.Read()) { RecordCount = StringUtils.GetDbInt(reader[0]); } else { RecordCount = 0; } } return(entityList); }
/// <summary> /// 根据主键值读取记录。如果数据库不存在这条数据将返回null /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public ReturnXSEntity GetReturnXS(int id, int memid) { string where = " where [Id]=@id "; if (memid != -1) { where += " and MemId=@MemId "; } string sql = @"SELECT [Id], [ProductId],[ReturnOrderCode],[ReturnOrderDetailId],[ProductName],[Num],[Price],[ReturnType],[NewOrderCode],[ReturnDescription],[ReturnReason],[CreateTime],[Status],[MemId],[RejectReason],[CheckManId],[CheckTime],ProductPic,[ProductPicSuffix],[ProvinceId],[CityId],[GetTime],[GetAddress],[AcceptName],[AcceptPhone],[PayType] FROM dbo.[ReturnXS] WITH(NOLOCK) " + where; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@Id", DbType.Int32, id); if (memid != -1) { db.AddInParameter(cmd, "@MemId", DbType.Int32, memid); } ReturnXSEntity entity = new ReturnXSEntity(); using (IDataReader reader = db.ExecuteReader(cmd)) { if (reader.Read()) { entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.ProductId = StringUtils.GetDbInt(reader["ProductId"]); entity.ReturnOrderCode = StringUtils.GetDbLong(reader["ReturnOrderCode"]); entity.ReturnOrderDetailId = StringUtils.GetDbInt(reader["ReturnOrderDetailId"]); entity.ProductName = StringUtils.GetDbString(reader["ProductName"]); entity.Num = StringUtils.GetDbInt(reader["Num"]); entity.Price = StringUtils.GetDbDecimal(reader["Price"]); entity.ReturnType = StringUtils.GetDbInt(reader["ReturnType"]); entity.NewOrderCode = StringUtils.GetDbString(reader["NewOrderCode"]); entity.ReturnDescription = StringUtils.GetDbString(reader["ReturnDescription"]); entity.ReturnReason = StringUtils.GetDbString(reader["ReturnReason"]); entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]); entity.Status = StringUtils.GetDbInt(reader["Status"]); entity.MemId = StringUtils.GetDbInt(reader["MemId"]); entity.RejectReason = StringUtils.GetDbString(reader["RejectReason"]); entity.CheckManId = StringUtils.GetDbString(reader["CheckManId"]); entity.CheckTime = StringUtils.GetDbDateTime(reader["CheckTime"]); entity.ProductPic = StringUtils.GetDbString(reader["ProductPic"]); entity.ProductPicSuffix = StringUtils.GetDbString(reader["ProductPicSuffix"]); entity.PayType = StringUtils.GetDbInt(reader["PayType"]); entity.ProvinceId = StringUtils.GetDbInt(reader["ProvinceId"]); entity.CityId = StringUtils.GetDbInt(reader["CityId"]); entity.GetTime = StringUtils.GetDbDateTime(reader["GetTime"]); entity.GetAddress = StringUtils.GetDbString(reader["GetAddress"]); entity.AcceptName = StringUtils.GetDbString(reader["AcceptName"]); entity.AcceptPhone = StringUtils.GetDbString(reader["AcceptPhone"]); } } return(entity); }
/// <summary> /// 退换货订单审核拒绝 /// </summary> /// <returns></returns> public int RefuseReturnApply() { int _id = FormString.IntSafeQ("id"); string _rejectreason = FormString.SafeQ("rejectreason", 1000); ReturnXSEntity _entity = ReturnXSBLL.Instance.GetReturnXS(_id, -1); _entity.CheckManId = memid.ToString(); _entity.CheckTime = DateTime.Now; _entity.Status = (int)ReturnOrderStatus.Reject; _entity.RejectReason = _rejectreason; return(ReturnXSBLL.Instance.UpdateReturnXS(_entity)); }
/// <summary> /// 插入一条记录到表ReturnXS,如果表中存在自增字段,则返回值为新记录的自增字段值,否则返回0 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="returnXS">待插入的实体对象</param> public int AddReturnXS(ReturnXSEntity entity) { string sql = @"insert into ReturnXS([PayType], [ProductPic],[ProductPicSuffix],[ProvinceId],[CityId],[GetTime],[GetAddress],[AcceptName],[AcceptPhone], [ProductId],[ReturnOrderCode],[ReturnOrderDetailId],[ProductName],[Num],[Price],[ReturnType],[NewOrderCode],[ReturnDescription],[ReturnReason],[CreateTime],[Status],[MemId],[RejectReason],[CheckManId])VALUES (@PayType,@ProductPic, @ProductPicSuffix,@ProvinceId,@CityId,@GetTime,@GetAddress,@AcceptName,@AcceptPhone,@ProductId,@ReturnOrderCode,@ReturnOrderDetailId,@ProductName,@Num,@Price,@ReturnType,@NewOrderCode,@ReturnDescription,@ReturnReason,@CreateTime,@Status,@MemId,@RejectReason,@CheckManId); SELECT SCOPE_IDENTITY();" ; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@ProductId", DbType.Int32, entity.ProductId); db.AddInParameter(cmd, "@ReturnOrderCode", DbType.Int64, entity.ReturnOrderCode); db.AddInParameter(cmd, "@ReturnOrderDetailId", DbType.Int32, entity.ReturnOrderDetailId); db.AddInParameter(cmd, "@ProductName", DbType.String, entity.ProductName); db.AddInParameter(cmd, "@Num", DbType.Int32, entity.Num); db.AddInParameter(cmd, "@Price", DbType.Decimal, entity.Price); db.AddInParameter(cmd, "@ReturnType", DbType.Int32, entity.ReturnType); db.AddInParameter(cmd, "@NewOrderCode", DbType.String, entity.NewOrderCode); db.AddInParameter(cmd, "@ReturnDescription", DbType.String, entity.ReturnDescription); db.AddInParameter(cmd, "@ReturnReason", DbType.String, entity.ReturnReason); db.AddInParameter(cmd, "@CreateTime", DbType.DateTime, entity.CreateTime); db.AddInParameter(cmd, "@Status", DbType.Int32, entity.Status); db.AddInParameter(cmd, "@MemId", DbType.Int32, entity.MemId); db.AddInParameter(cmd, "@RejectReason", DbType.String, entity.RejectReason); db.AddInParameter(cmd, "@CheckManId", DbType.String, entity.CheckManId); //db.AddInParameter(cmd, "@CheckTime", DbType.DateTime, entity.CheckTime); db.AddInParameter(cmd, "@ProductPic", DbType.String, entity.ProductPic); db.AddInParameter(cmd, "@ProductPicSuffix", DbType.String, entity.ProductPicSuffix); db.AddInParameter(cmd, "@PayType", DbType.Int32, entity.PayType); db.AddInParameter(cmd, "@ProvinceId", DbType.Int32, entity.ProvinceId); db.AddInParameter(cmd, "@CityId", DbType.Int32, entity.CityId); db.AddInParameter(cmd, "@GetTime", DbType.DateTime, entity.GetTime); db.AddInParameter(cmd, "@GetAddress", DbType.String, entity.GetAddress); db.AddInParameter(cmd, "@AcceptName", DbType.String, entity.AcceptName); db.AddInParameter(cmd, "@AcceptPhone", DbType.String, entity.AcceptPhone); object identity = db.ExecuteScalar(cmd); if (identity == null || identity == DBNull.Value) { return(0); } return(Convert.ToInt32(identity)); }
/// <summary> /// 插入一条记录到表ReturnXS,如果表中存在自增字段,则返回值为新记录的自增字段值,否则返回0。 /// 该方法提供给界面等UI层调用 /// </summary> /// <param name="returnXS">要添加的ReturnXS数据实体对象</param> public int AddReturnXS(ReturnXSEntity returnXS) { if (returnXS.Id > 0) { return(UpdateReturnXS(returnXS)); } else if (string.IsNullOrEmpty(returnXS.ProductName)) { return((int)CommonStatus.ADD_Fail_Empty); } //else if (ReturnXSBLL.Instance.IsExist(returnXS)) //{ // return (int)CommonStatus.ADD_Fail_Exist; //} else { return(ReturnXSDA.Instance.AddReturnXS(returnXS)); } }
/// <summary> /// 通知供应商收货 /// </summary> /// <returns></returns> public string NoteMsgToCGMem() { ResultObj result = new ResultObj(); int returnId = FormString.IntSafeQ("returnId"); if (!ReturnXSBLL.Instance.ReturnNumEqDist(returnId)) { result.Status = (int)CommonStatus.RebackNumNoValid; } else { if (ReturnXSBLL.Instance.UpdateReturnXSStatus(returnId, (int)ReturnOrderStatus.Returning, (int)ReturnOrderStatus.Adopt) > 0) { //采购系统接口, if (CGReturnBLL.Instance.NoteMsgToCGMems(returnId) > 0) { result.Status = (int)CommonStatus.Success; } } else { ReturnXSEntity en = ReturnXSBLL.Instance.GetReturnXS(returnId, -1); if (en.Status == (int)ReturnOrderStatus.Returning) { //采购系统接口, if (CGReturnBLL.Instance.NoteMsgToCGMems(returnId) > 0) { result.Status = (int)CommonStatus.Success; } } else { result.Status = (int)CommonStatus.Fail; } } } return(JsonJC.ObjectToJson(result)); }
/// <summary> /// 根据主键值更新记录的全部字段(注意:该方法不会对自增字段、timestamp类型字段以及主键字段更新!如果要更新主键字段,请使用Update方法)。 /// 如果数据库有数据被更新了则返回True,否则返回False /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="returnXS">待更新的实体对象</param> public int UpdateReturnXS(ReturnXSEntity entity) { string sql = @" UPDATE dbo.[ReturnXS] SET [PayType]=@PayType,ProvinceId=@ProvinceId,CityId=@CityId,GetTime=@GetTime,GetAddress=@GetAddress,AcceptName=@AcceptName,AcceptPhone=@AcceptPhone,ProductPicSuffix=@ProductPicSuffix, [ProductId]=@ProductId,[ReturnOrderCode]=@ReturnOrderCode,[ReturnOrderDetailId]=@ReturnOrderDetailId,[ProductName]=@ProductName,[Num]=@Num,[Price]=@Price,[ReturnType]=@ReturnType,[NewOrderCode]=@NewOrderCode,[ReturnDescription]=@ReturnDescription,[ReturnReason]=@ReturnReason,[CreateTime]=@CreateTime,[Status]=@Status,[MemId]=@MemId,[RejectReason]=@RejectReason,[CheckManId]=@CheckManId,[CheckTime]=@CheckTime WHERE [Id]=@id"; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@Id", DbType.Int32, entity.Id); db.AddInParameter(cmd, "@ProductId", DbType.Int32, entity.ProductId); db.AddInParameter(cmd, "@ReturnOrderCode", DbType.Int64, entity.ReturnOrderCode); db.AddInParameter(cmd, "@ReturnOrderDetailId", DbType.Int32, entity.ReturnOrderDetailId); db.AddInParameter(cmd, "@ProductName", DbType.String, entity.ProductName); db.AddInParameter(cmd, "@Num", DbType.Int32, entity.Num); db.AddInParameter(cmd, "@Price", DbType.Decimal, entity.Price); db.AddInParameter(cmd, "@ReturnType", DbType.Int32, entity.ReturnType); db.AddInParameter(cmd, "@NewOrderCode", DbType.String, entity.NewOrderCode); db.AddInParameter(cmd, "@ReturnDescription", DbType.String, entity.ReturnDescription); db.AddInParameter(cmd, "@ReturnReason", DbType.String, entity.ReturnReason); db.AddInParameter(cmd, "@CreateTime", DbType.DateTime, entity.CreateTime); db.AddInParameter(cmd, "@Status", DbType.Int32, entity.Status); db.AddInParameter(cmd, "@MemId", DbType.Int32, entity.MemId); db.AddInParameter(cmd, "@RejectReason", DbType.String, entity.RejectReason); db.AddInParameter(cmd, "@CheckManId", DbType.String, entity.CheckManId); db.AddInParameter(cmd, "@CheckTime", DbType.DateTime, entity.CheckTime); db.AddInParameter(cmd, "@ProductPicSuffix", DbType.String, entity.ProductPicSuffix); db.AddInParameter(cmd, "@PayType", DbType.Int32, entity.PayType); db.AddInParameter(cmd, "@ProvinceId", DbType.Int32, entity.ProvinceId); db.AddInParameter(cmd, "@CityId", DbType.Int32, entity.CityId); db.AddInParameter(cmd, "@GetTime", DbType.DateTime, entity.GetTime); db.AddInParameter(cmd, "@GetAddress", DbType.String, entity.GetAddress); db.AddInParameter(cmd, "@AcceptName", DbType.String, entity.AcceptName); db.AddInParameter(cmd, "@AcceptPhone", DbType.String, entity.AcceptPhone); return(db.ExecuteNonQuery(cmd)); }
/// <summary> /// 读取记录列表。 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public IList <ReturnXSEntity> GetReturnXSList(int pagesize, int pageindex, ref int recordCount, int memid, int returntype, string keyword, int term, int status) { string where = " WHERE 1=1 "; if (memid > 0) { where += " AND MemId=@MemId "; } if (returntype > 0) { where += " AND ReturnType=@ReturnType"; } if (!string.IsNullOrEmpty(keyword)) { where += " AND (ReturnOrderCode like @KeyWord)"; } if (term > -1) { switch (term) { case (int)ReturnOrderTerm.ThreeMonth: { where += " AND CreateTime>DATEADD(mm,-3,getdate())"; break; } case (int)ReturnOrderTerm.HalfYear: { where += " AND CreateTime>DATEADD(mm,-6,getdate())"; break; } case (int)ReturnOrderTerm.ThisYear: { where += " AND year(CreateTime)=year(getdate())"; break; } case (int)ReturnOrderTerm.LastYear: { where += " AND year(CreateTime)=year(getdate())-1"; break; } case (int)ReturnOrderTerm.PreviousYear: { where += " AND year(CreateTime)=year(getdate())-2"; break; } } } if (status > -1) { where += " AND Status=@Status"; } string sql = @"SELECT [AahamaReciveType],[PayType],[ProductPicSuffix],[ProvinceId],[CityId],[GetTime],[GetAddress],[AcceptName],[AcceptPhone], [Id], [ProductId],[ReturnOrderCode],[ReturnOrderDetailId],[ProductName],[Num],[Price],[ReturnType],[NewOrderCode],[ReturnDescription],[ReturnReason],[CreateTime],[Status],[MemId],[RejectReason],[CheckManId],[CheckTime] FROM (SELECT ROW_NUMBER() OVER (ORDER BY id desc) AS ROWNUMBER, [AahamaReciveType],[PayType],[ProductPicSuffix],[ProvinceId],[CityId],[GetTime],[GetAddress],[AcceptName],[AcceptPhone], [Id], [ProductId],[ReturnOrderCode],[ReturnOrderDetailId],[ProductName],[Num],[Price],[ReturnType],[NewOrderCode],[ReturnDescription],[ReturnReason],[CreateTime],[Status] ,[MemId],[RejectReason],[CheckManId],[CheckTime] from dbo.[ReturnXS] WITH(NOLOCK) " + where + @") as temp where rownumber BETWEEN ((@PageIndex - 1) * @PageSize + 1) AND @PageIndex * @PageSize" ; string sql2 = @"Select count(1) from dbo.[ReturnXS] with (nolock) " + where; IList <ReturnXSEntity> entityList = new List <ReturnXSEntity>(); DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@PageIndex", DbType.Int32, pageindex); db.AddInParameter(cmd, "@PageSize", DbType.Int32, pagesize); if (memid > 0) { db.AddInParameter(cmd, "@MemId", DbType.Int32, memid); } if (returntype > 0) { db.AddInParameter(cmd, "@ReturnType", DbType.Int32, returntype); } if (!string.IsNullOrEmpty(keyword)) { db.AddInParameter(cmd, "@KeyWord", DbType.String, "%" + keyword + "%"); } if (status > -1) { db.AddInParameter(cmd, "@Status", DbType.String, status); } using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { ReturnXSEntity entity = new ReturnXSEntity(); entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.ProductId = StringUtils.GetDbInt(reader["ProductId"]); entity.ReturnOrderCode = StringUtils.GetDbLong(reader["ReturnOrderCode"]); entity.ReturnOrderDetailId = StringUtils.GetDbInt(reader["ReturnOrderDetailId"]); entity.ProductName = StringUtils.GetDbString(reader["ProductName"]); entity.Num = StringUtils.GetDbInt(reader["Num"]); entity.Price = StringUtils.GetDbDecimal(reader["Price"]); entity.ReturnType = StringUtils.GetDbInt(reader["ReturnType"]); entity.NewOrderCode = StringUtils.GetDbString(reader["NewOrderCode"]); entity.ReturnDescription = StringUtils.GetDbString(reader["ReturnDescription"]); entity.ReturnReason = StringUtils.GetDbString(reader["ReturnReason"]); entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]); entity.Status = StringUtils.GetDbInt(reader["Status"]); entity.MemId = StringUtils.GetDbInt(reader["MemId"]); entity.RejectReason = StringUtils.GetDbString(reader["RejectReason"]); entity.CheckManId = StringUtils.GetDbString(reader["CheckManId"]); entity.CheckTime = StringUtils.GetDbDateTime(reader["CheckTime"]); entity.ProductPicSuffix = StringUtils.GetDbString(reader["ProductPicSuffix"]); entity.PayType = StringUtils.GetDbInt(reader["PayType"]); entity.ProvinceId = StringUtils.GetDbInt(reader["ProvinceId"]); entity.CityId = StringUtils.GetDbInt(reader["CityId"]); entity.GetTime = StringUtils.GetDbDateTime(reader["GetTime"]); entity.GetAddress = StringUtils.GetDbString(reader["GetAddress"]); entity.AcceptName = StringUtils.GetDbString(reader["AcceptName"]); entity.AcceptPhone = StringUtils.GetDbString(reader["AcceptPhone"]); entity.AahamaReciveType = StringUtils.GetDbInt(reader["AahamaReciveType"]); entityList.Add(entity); } } cmd = db.GetSqlStringCommand(sql2); if (memid > 0) { db.AddInParameter(cmd, "@MemId", DbType.Int32, memid); } if (returntype > 0) { db.AddInParameter(cmd, "@ReturnType", DbType.Int32, returntype); } if (!string.IsNullOrEmpty(keyword)) { db.AddInParameter(cmd, "@KeyWord", DbType.String, "%" + keyword + "%"); } if (status > -1) { db.AddInParameter(cmd, "@Status", DbType.String, status); } using (IDataReader reader = db.ExecuteReader(cmd)) { if (reader.Read()) { recordCount = StringUtils.GetDbInt(reader[0]); } else { recordCount = 0; } } return(entityList); }
/// <summary> /// 更新一条ReturnXS记录。 /// 该方法提供给界面等UI层调用 /// </summary> /// <param name="returnXS">待更新的实体对象</param> /// <param name="columns">要更新的列名,不提供任何列名时默认将更新主键之外的所有列</param> public int UpdateReturnXS(ReturnXSEntity returnXS) { return(ReturnXSDA.Instance.UpdateReturnXS(returnXS)); }
/// <summary> /// 判断对象是否存在 /// </summary> /// <param name="dicEnum"></param> /// <returns></returns> public bool IsExist(ReturnXSEntity returnXS) { return(ReturnXSDA.Instance.ExistNum(returnXS) > 0); }