/// <summary> /// 得到 carts 数据实体 /// </summary> /// <param name="dr">dr</param> /// <returns>carts 数据实体</returns> public CartsEntity Populate_CartsEntity_FromDr(IDataReader dr) { CartsEntity Obj = new CartsEntity(); Obj.CartId = ((dr["CartId"]) == DBNull.Value)?0:Convert.ToInt32(dr["CartId"]); Obj.ProductId = ((dr["ProductId"]) == DBNull.Value)?0:Convert.ToInt32(dr["ProductId"]); Obj.uid = dr["uid"].ToString(); Obj.Number = ((dr["Number"]) == DBNull.Value)?0:Convert.ToInt32(dr["Number"]); Obj.Status = ((dr["Status"]) == DBNull.Value)?0:Convert.ToInt32(dr["Status"]); Obj.AddTime = ((dr["AddTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(dr["AddTime"]); Obj.UpdateTime = ((dr["UpdateTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(dr["UpdateTime"]); return(Obj); }
public bool Delete(Guid Id) { bool toReturn = false; using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter()) { CartsEntity _CartsEntity = new CartsEntity(Id); if (adapter.FetchEntity(_CartsEntity)) { adapter.DeleteEntity(_CartsEntity); toReturn = true; } } return toReturn; }
/// <summary> /// 根据ID,返回一个Carts对象 /// </summary> /// <param name="cartId">cartId</param> /// <returns>Carts对象</returns> public CartsEntity Get_CartsEntity(int cartId) { CartsEntity _obj = null; SqlParameter[] _param = { new SqlParameter("@CartId", SqlDbType.Int) }; _param[0].Value = cartId; string sqlStr = "select * from Carts with(nolock) where CartId=@CartId"; using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.WfxRW, CommandType.Text, sqlStr, _param)) { while (dr.Read()) { _obj = Populate_CartsEntity_FromDr(dr); } } return(_obj); }
/// <summary> /// 得到 carts 数据实体 /// </summary> /// <param name="row">row</param> /// <returns>carts 数据实体</returns> public CartsEntity Populate_CartsEntity_FromDr(DataRow row) { CartsEntity Obj = new CartsEntity(); if (row != null) { Obj.CartId = ((row["CartId"]) == DBNull.Value)?0:Convert.ToInt32(row["CartId"]); Obj.ProductId = ((row["ProductId"]) == DBNull.Value)?0:Convert.ToInt32(row["ProductId"]); Obj.uid = row["uid"].ToString(); Obj.Number = ((row["Number"]) == DBNull.Value)?0:Convert.ToInt32(row["Number"]); Obj.Status = ((row["Status"]) == DBNull.Value)?0:Convert.ToInt32(row["Status"]); Obj.AddTime = ((row["AddTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(row["AddTime"]); Obj.UpdateTime = ((row["UpdateTime"]) == DBNull.Value)?Convert.ToDateTime("1900-1-1"):Convert.ToDateTime(row["UpdateTime"]); } else { return(null); } return(Obj); }
/// <summary> /// 向数据库中插入一条新记录。带事务 /// </summary> /// <param name="sp">事务对象</param> /// <param name="_CartsModel">Carts实体</param> /// <returns>新插入记录的编号</returns> public int Insert(SqlTransaction sp, CartsEntity _CartsModel) { string sqlStr = "insert into Carts([ProductId],[uid],[Number],[Status],[AddTime],[UpdateTime]) values(@ProductId,@uid,@Number,@Status,@AddTime,@UpdateTime) select @@identity"; int res; SqlParameter[] _param = { new SqlParameter("@ProductId", SqlDbType.Int), new SqlParameter("@uid", SqlDbType.VarChar), new SqlParameter("@Number", SqlDbType.Int), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@UpdateTime", SqlDbType.DateTime) }; _param[0].Value = _CartsModel.ProductId; _param[1].Value = _CartsModel.uid; _param[2].Value = _CartsModel.Number; _param[3].Value = _CartsModel.Status; _param[4].Value = _CartsModel.AddTime; _param[5].Value = _CartsModel.UpdateTime; res = Convert.ToInt32(SqlHelper.ExecuteScalar(sp, CommandType.Text, sqlStr, _param)); return(res); }
/// <summary> /// 向数据表Carts更新一条记录。带事务 /// </summary> /// <param name="sp">事务对象</param> /// <param name="_CartsModel">_CartsModel</param> /// <returns>影响的行数</returns> public int Update(SqlTransaction sp, CartsEntity _CartsModel) { string sqlStr = "update Carts set [ProductId]=@ProductId,[uid]=@uid,[Number]=@Number,[Status]=@Status,[AddTime]=@AddTime,[UpdateTime]=@UpdateTime where CartId=@CartId"; SqlParameter[] _param = { new SqlParameter("@CartId", SqlDbType.Int), new SqlParameter("@ProductId", SqlDbType.Int), new SqlParameter("@uid", SqlDbType.VarChar), new SqlParameter("@Number", SqlDbType.Int), new SqlParameter("@Status", SqlDbType.Int), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@UpdateTime", SqlDbType.DateTime) }; _param[0].Value = _CartsModel.CartId; _param[1].Value = _CartsModel.ProductId; _param[2].Value = _CartsModel.uid; _param[3].Value = _CartsModel.Number; _param[4].Value = _CartsModel.Status; _param[5].Value = _CartsModel.AddTime; _param[6].Value = _CartsModel.UpdateTime; return(SqlHelper.ExecuteNonQuery(sp, CommandType.Text, sqlStr, _param)); }
public void Update(CartsEntity cartsEntity) { cartsdal.Update(cartsEntity); }
public int Insert(CartsEntity cartsEntity) { return(cartsdal.Insert(cartsEntity)); }
public bool Update(Guid Id, Guid SessionId, Guid ProductId, Guid SupplierId, string ProductName, decimal Price, decimal TotalAmount) { bool toReturn = false; using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter()) { CartsEntity _CartsEntity = new CartsEntity(Id); if (adapter.FetchEntity(_CartsEntity)) { _CartsEntity.SessionId = SessionId; _CartsEntity.ProductId = ProductId; _CartsEntity.SupplierId = SupplierId; _CartsEntity.ProductName = ProductName; _CartsEntity.Price = Price; _CartsEntity.TotalAmount = TotalAmount; adapter.SaveEntity(_CartsEntity, true); toReturn = true; } } return toReturn; }
public bool Update(CartsEntity _CartsEntity, RelationPredicateBucket filter) { bool toReturn = false; using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter()) { adapter.UpdateEntitiesDirectly(_CartsEntity, filter); toReturn = true; } return toReturn; }
public bool Update(CartsEntity _CartsEntity) { bool toReturn = false; using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter()) { RelationPredicateBucket filter = new RelationPredicateBucket(); IPredicateExpression _PredicateExpression = new PredicateExpression(); _PredicateExpression.Add(CartsFields.Id == _CartsEntity.Id); filter.PredicateExpression.Add(_PredicateExpression); adapter.UpdateEntitiesDirectly(_CartsEntity, filter); toReturn = true; } return toReturn; }
public CartsEntity SelectOne(Guid Id) { CartsEntity toReturn = null; using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter()) { CartsEntity _CartsEntity = new CartsEntity(Id); if (adapter.FetchEntity(_CartsEntity)) { toReturn = _CartsEntity; } } return toReturn; }
public CartsEntity Insert(Guid SessionId, Guid ProductId, Guid SupplierId, string ProductName, decimal Price, decimal TotalAmount) { CartsEntity _CartsEntity = new CartsEntity(); using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter()) { _CartsEntity.SessionId = SessionId; _CartsEntity.ProductId = ProductId; _CartsEntity.SupplierId = SupplierId; _CartsEntity.ProductName = ProductName; _CartsEntity.Price = Price; _CartsEntity.TotalAmount = TotalAmount; adapter.SaveEntity(_CartsEntity, true); } return _CartsEntity; }
public CartsEntity Insert(CartsEntity _CartsEntity) { using(DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter()) { adapter.SaveEntity(_CartsEntity, true); } return _CartsEntity; }