/// <summary> /// 插入一条记录到表OrderPayLineConfirm,如果表中存在自增字段,则返回值为新记录的自增字段值,否则返回0 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="orderPayLineConfirm">待插入的实体对象</param> public int AddOrderPayLineConfirm(OrderPayLineConfirmEntity entity) { string sql = @" DECLARE @idenid INT insert into OrderPayLineConfirm( [OrderCode],[Reason],[CreateTime],[CreateManId],[Status])VALUES ( @OrderCode,@Reason,GETDATE(),@CreateManId,@Status); SET @idenid=SCOPE_IDENTITY(); update dbo.[Order] set FinancialStatus=@WaitConfirm where Code=@OrderCode and FinancialStatus=@FinanceDefault ; SELECT @idenid " ; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@OrderCode", DbType.Int64, entity.OrderCode); db.AddInParameter(cmd, "@Reason", DbType.String, entity.Reason); db.AddInParameter(cmd, "@CreateManId", DbType.Int32, entity.CreateManId); db.AddInParameter(cmd, "@Status", DbType.Int32, entity.Status); db.AddInParameter(cmd, "@WaitConfirm", DbType.Int32, (int)SuperMarket.Model.FinancialStatus.WaitChecked); db.AddInParameter(cmd, "@FinanceDefault", DbType.Int32, (int)SuperMarket.Model.FinancialStatus.Default); object identity = db.ExecuteScalar(cmd); if (identity == null || identity == DBNull.Value) { return(0); } return(Convert.ToInt32(identity)); }
public string AddToLineConfirm() { ResultObj result = new ResultObj(); long _ordercode = FormString.LongIntSafeQ("ordercode"); if (OrderPayLineConfirmBLL.Instance.IsExist(_ordercode, (int)PayLineConfirm.Default)) { result.Status = (int)CommonStatus.HasAddToLineConfirm; } else { OrderPayLineConfirmEntity confirmentity = new OrderPayLineConfirmEntity(); confirmentity.OrderCode = _ordercode; confirmentity.Reason = "待付款订单线下确认"; confirmentity.CreateManId = memid; confirmentity.Status = (int)PayLineConfirm.Default; if (OrderPayLineConfirmBLL.Instance.AddOrderPayLineConfirm(confirmentity) > 0) { result.Status = (int)CommonStatus.Success; } else { result.Status = (int)CommonStatus.Fail; } } return(JsonJC.ObjectToJson(result)); }
/// <summary> /// 根据主键值读取记录。如果数据库不存在这条数据将返回null /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public OrderPayLineConfirmEntity GetPayLineConfirm(int id, long ordercode) { string sql = @"SELECT [Id],[OrderCode],[Reason],[CreateTime],[CreateManId],[FinanceDealManId],[FinanceDealTime],[Status] FROM dbo.[OrderPayLineConfirm] WITH(NOLOCK) WHERE [Id]=@id and OrderCode=@OrderCode and Status=@Status" ; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@Id", DbType.Int32, id); db.AddInParameter(cmd, "@OrderCode", DbType.Int64, ordercode); db.AddInParameter(cmd, "@Status", DbType.Int32, (int)PayLineConfirm.Default); OrderPayLineConfirmEntity entity = new OrderPayLineConfirmEntity(); using (IDataReader reader = db.ExecuteReader(cmd)) { if (reader.Read()) { entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.OrderCode = StringUtils.GetDbLong(reader["OrderCode"]); entity.Reason = StringUtils.GetDbString(reader["Reason"]); entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]); entity.CreateManId = StringUtils.GetDbInt(reader["CreateManId"]); entity.FinanceDealManId = StringUtils.GetDbInt(reader["FinanceDealManId"]); entity.FinanceDealTime = StringUtils.GetDbDateTime(reader["FinanceDealTime"]); entity.Status = StringUtils.GetDbInt(reader["Status"]); } } return(entity); }
/// <summary> /// 根据主键值更新记录的全部字段(注意:该方法不会对自增字段、timestamp类型字段以及主键字段更新!如果要更新主键字段,请使用Update方法)。 /// 如果数据库有数据被更新了则返回True,否则返回False /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="orderPayLineConfirm">待更新的实体对象</param> public int UpdateOrderPayLineConfirm(OrderPayLineConfirmEntity entity) { string sql = @" UPDATE dbo.[OrderPayLineConfirm] SET [OrderCode]=@OrderCode,[Reason]=@Reason,[CreateTime]=@CreateTime,[CreateManId]=@CreateManId,[FinanceDealManId]=@FinanceDealManId,[FinanceDealTime]=@FinanceDealTime,[Status]=@Status WHERE [Id]=@id"; DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@Id", DbType.Int32, entity.Id); db.AddInParameter(cmd, "@OrderCode", DbType.Int64, entity.OrderCode); db.AddInParameter(cmd, "@Reason", DbType.String, entity.Reason); db.AddInParameter(cmd, "@CreateTime", DbType.DateTime, entity.CreateTime); db.AddInParameter(cmd, "@CreateManId", DbType.Int32, entity.CreateManId); db.AddInParameter(cmd, "@FinanceDealManId", DbType.Int32, entity.FinanceDealManId); db.AddInParameter(cmd, "@FinanceDealTime", DbType.DateTime, entity.FinanceDealTime); db.AddInParameter(cmd, "@Status", DbType.Int32, entity.Status); return(db.ExecuteNonQuery(cmd)); }
/// <summary> /// 读取记录列表。 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public IList <OrderPayLineConfirmEntity> GetOrderPayLineConfirmList(int pagesize, int pageindex, ref int recordCount) { string sql = @"SELECT [Id],[OrderCode],[Reason],[CreateTime],[CreateManId],[FinanceDealManId],[FinanceDealTime],[Status] FROM (SELECT ROW_NUMBER() OVER (ORDER BY Id desc) AS ROWNUMBER, [Id],[OrderCode],[Reason],[CreateTime],[CreateManId],[FinanceDealManId],[FinanceDealTime],[Status] from dbo.[OrderPayLineConfirm] WITH(NOLOCK) WHERE 1=1 ) as temp where rownumber BETWEEN ((@PageIndex - 1) * @PageSize + 1) AND @PageIndex * @PageSize" ; string sql2 = @"Select count(1) from dbo.[OrderPayLineConfirm] with (nolock) "; IList <OrderPayLineConfirmEntity> entityList = new List <OrderPayLineConfirmEntity>(); DbCommand cmd = db.GetSqlStringCommand(sql); db.AddInParameter(cmd, "@PageIndex", DbType.Int32, pageindex); db.AddInParameter(cmd, "@PageSize", DbType.Int32, pagesize); using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { OrderPayLineConfirmEntity entity = new OrderPayLineConfirmEntity(); entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.OrderCode = StringUtils.GetDbLong(reader["OrderCode"]); entity.Reason = StringUtils.GetDbString(reader["Reason"]); entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]); entity.CreateManId = StringUtils.GetDbInt(reader["CreateManId"]); entity.FinanceDealManId = StringUtils.GetDbInt(reader["FinanceDealManId"]); entity.FinanceDealTime = StringUtils.GetDbDateTime(reader["FinanceDealTime"]); entity.Status = StringUtils.GetDbInt(reader["Status"]); 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); }
public string PayLineConfirm() { ResultObj result = new ResultObj(); int _id = FormString.IntSafeQ("id"); long _ordercode = FormString.LongIntSafeQ("ordercode"); OrderPayLineConfirmEntity entity = OrderPayLineConfirmBLL.Instance.GetPayLineConfirm(_id, _ordercode); if (entity != null && entity.Id > 0) { OrderPayLineConfirmBLL.Instance.ConfirmRecived(_id, _ordercode, memid); result.Status = (int)CommonStatus.Success; } else { result.Status = (int)CommonStatus.Fail; } return(JsonJC.ObjectToJson(result)); }
/// <summary> /// 读取记录列表。 /// </summary> /// <param name="db">数据库操作对象</param> /// <param name="columns">需要返回的列,不提供任何列名时默认将返回所有列</param> public IList <OrderPayLineConfirmEntity> GetOrderPayLineConfirmAll() { string sql = @"SELECT [Id],[OrderCode],[Reason],[CreateTime],[CreateManId],[FinanceDealManId],[FinanceDealTime],[Status] from dbo.[OrderPayLineConfirm] WITH(NOLOCK) "; IList <OrderPayLineConfirmEntity> entityList = new List <OrderPayLineConfirmEntity>(); DbCommand cmd = db.GetSqlStringCommand(sql); using (IDataReader reader = db.ExecuteReader(cmd)) { while (reader.Read()) { OrderPayLineConfirmEntity entity = new OrderPayLineConfirmEntity(); entity.Id = StringUtils.GetDbInt(reader["Id"]); entity.OrderCode = StringUtils.GetDbLong(reader["OrderCode"]); entity.Reason = StringUtils.GetDbString(reader["Reason"]); entity.CreateTime = StringUtils.GetDbDateTime(reader["CreateTime"]); entity.CreateManId = StringUtils.GetDbInt(reader["CreateManId"]); entity.FinanceDealManId = StringUtils.GetDbInt(reader["FinanceDealManId"]); entity.FinanceDealTime = StringUtils.GetDbDateTime(reader["FinanceDealTime"]); entity.Status = StringUtils.GetDbInt(reader["Status"]); entityList.Add(entity); } } return(entityList); }
/// <summary> /// 更新一条OrderPayLineConfirm记录。 /// 该方法提供给界面等UI层调用 /// </summary> /// <param name="orderPayLineConfirm">待更新的实体对象</param> /// <param name="columns">要更新的列名,不提供任何列名时默认将更新主键之外的所有列</param> public int UpdateOrderPayLineConfirm(OrderPayLineConfirmEntity orderPayLineConfirm) { return(OrderPayLineConfirmDA.Instance.UpdateOrderPayLineConfirm(orderPayLineConfirm)); }
/// <summary> /// 插入一条记录到表OrderPayLineConfirm,如果表中存在自增字段,则返回值为新记录的自增字段值,否则返回0。 /// 该方法提供给界面等UI层调用 /// </summary> /// <param name="orderPayLineConfirm">要添加的OrderPayLineConfirm数据实体对象</param> public int AddOrderPayLineConfirm(OrderPayLineConfirmEntity orderPayLineConfirm) { return(OrderPayLineConfirmDA.Instance.AddOrderPayLineConfirm(orderPayLineConfirm)); }