/// <summary> /// 得到一个对象实体 /// </summary> public ROYcms.Sys.Model.ROYcms_Payment GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,UserID,PaymentType,PaymentName,PaymentAmount,PaymentNum,UpdateTime,CreateTime from ROYcms_Payment "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; ROYcms.Sys.Model.ROYcms_Payment model = new ROYcms.Sys.Model.ROYcms_Payment(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"] != null && ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } if (ds.Tables[0].Rows[0]["UserID"] != null && ds.Tables[0].Rows[0]["UserID"].ToString() != "") { model.UserID = int.Parse(ds.Tables[0].Rows[0]["UserID"].ToString()); } if (ds.Tables[0].Rows[0]["PaymentType"] != null && ds.Tables[0].Rows[0]["PaymentType"].ToString() != "") { model.PaymentType = ds.Tables[0].Rows[0]["PaymentType"].ToString(); } if (ds.Tables[0].Rows[0]["PaymentName"] != null && ds.Tables[0].Rows[0]["PaymentName"].ToString() != "") { model.PaymentName = ds.Tables[0].Rows[0]["PaymentName"].ToString(); } if (ds.Tables[0].Rows[0]["PaymentAmount"] != null && ds.Tables[0].Rows[0]["PaymentAmount"].ToString() != "") { model.PaymentAmount = int.Parse(ds.Tables[0].Rows[0]["PaymentAmount"].ToString()); } if (ds.Tables[0].Rows[0]["PaymentNum"] != null && ds.Tables[0].Rows[0]["PaymentNum"].ToString() != "") { model.PaymentNum = ds.Tables[0].Rows[0]["PaymentNum"].ToString(); } if (ds.Tables[0].Rows[0]["UpdateTime"] != null && ds.Tables[0].Rows[0]["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(ds.Tables[0].Rows[0]["UpdateTime"].ToString()); } if (ds.Tables[0].Rows[0]["CreateTime"] != null && ds.Tables[0].Rows[0]["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["CreateTime"].ToString()); } return(model); } else { return(null); } }
{ /// <summary> /// XML help? /// </summary> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ROYcms.Sys.BLL.ROYcms_Goods_Order Goods_Order_BLL = new ROYcms.Sys.BLL.ROYcms_Goods_Order(); ROYcms.Sys.Model.ROYcms_Goods_Order Goods_Order_Model = new ROYcms.Sys.Model.ROYcms_Goods_Order(); ROYcms.Sys.BLL.ROYcms_Payment Payment_BLL = new ROYcms.Sys.BLL.ROYcms_Payment(); ROYcms.Sys.Model.ROYcms_Payment Payment_Model = new ROYcms.Sys.Model.ROYcms_Payment(); ROYcms.Sys.BLL.ROYcms_user user_BLL = new ROYcms.Sys.BLL.ROYcms_user(); ROYcms.Sys.Model.ROYcms_user user_Model = new ROYcms.Sys.Model.ROYcms_user(); string OrderId = Request["order_id"]; if (OrderId != null) { //修改订单状态 Goods_Order_Model = Goods_Order_BLL.GetModel(OrderId); if (Goods_Order_Model == null) { //订单无效 return; } Goods_Order_Model.order_sn = OrderId; Goods_Order_Model.order_status = 1; Goods_Order_BLL.Update_(Goods_Order_Model); //创建支付记录 Payment_Model.PaymentAmount = Goods_Order_Model.goods_amount; Payment_Model.PaymentName = "支付接口名称"; Payment_Model.PaymentNum = "支付号"; Payment_Model.PaymentType = "支付接口类型"; Payment_Model.UserID = Goods_Order_Model.user_id; Payment_Model.UpdateTime = DateTime.Now; Payment_BLL.Add(Payment_Model); //修改用户积分 user_Model = user_BLL.GetModel(Convert.ToInt32(Goods_Order_Model.user_id)); if (user_Model == null) { //用户无效 return; } user_Model.money = user_Model.money + Goods_Order_Model.goods_amount; } else { ROYcms.Common.MessageBox.Show(this, "订单号码不能为空!"); } } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ROYcms.Sys.Model.ROYcms_Payment model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ROYcms_Payment set "); strSql.Append("UserID=@UserID,"); strSql.Append("PaymentType=@PaymentType,"); strSql.Append("PaymentName=@PaymentName,"); strSql.Append("PaymentAmount=@PaymentAmount,"); strSql.Append("PaymentNum=@PaymentNum,"); strSql.Append("UpdateTime=@UpdateTime,"); strSql.Append("CreateTime=@CreateTime"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@PaymentType", SqlDbType.VarChar, 50), new SqlParameter("@PaymentName", SqlDbType.VarChar, 4000), new SqlParameter("@PaymentAmount", SqlDbType.Int, 4), new SqlParameter("@PaymentNum", SqlDbType.VarChar, 100), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.UserID; parameters[1].Value = model.PaymentType; parameters[2].Value = model.PaymentName; parameters[3].Value = model.PaymentAmount; parameters[4].Value = model.PaymentNum; parameters[5].Value = model.UpdateTime; parameters[6].Value = model.CreateTime; parameters[7].Value = model.Id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ROYcms.Sys.Model.ROYcms_Payment model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ROYcms_Payment("); strSql.Append("UserID,PaymentType,PaymentName,PaymentAmount,PaymentNum,UpdateTime,CreateTime)"); strSql.Append(" values ("); strSql.Append("@UserID,@PaymentType,@PaymentName,@PaymentAmount,@PaymentNum,@UpdateTime,@CreateTime)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserID", SqlDbType.Int, 4), new SqlParameter("@PaymentType", SqlDbType.VarChar, 50), new SqlParameter("@PaymentName", SqlDbType.VarChar, 4000), new SqlParameter("@PaymentAmount", SqlDbType.Int, 4), new SqlParameter("@PaymentNum", SqlDbType.VarChar, 100), new SqlParameter("@UpdateTime", SqlDbType.DateTime), new SqlParameter("@CreateTime", SqlDbType.DateTime) }; parameters[0].Value = model.UserID; parameters[1].Value = model.PaymentType; parameters[2].Value = model.PaymentName; parameters[3].Value = model.PaymentAmount; parameters[4].Value = model.PaymentNum; parameters[5].Value = model.UpdateTime; parameters[6].Value = model.CreateTime; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }