/// <summary> /// 增加一条数据 /// </summary> public int Add(ShiMiao.Model.TD_Order_WeiXinPay model, string tranID) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TD_Order_WeiXinPay("); strSql.Append("OrderID,NonceStr,Timestamp,OrgID,WeiXinOrderID,OrderFee,CashFee,Package,Status,PayTime,CallBackTime"); strSql.Append(") values ("); strSql.Append("@OrderID,@NonceStr,@Timestamp,@OrgID,@WeiXinOrderID,@OrderFee,@CashFee,@Package,@Status,@PayTime,@CallBackTime"); strSql.Append(") "); MySqlParameter[] parameters = { new MySqlParameter("@OrderID", model.OrderID), new MySqlParameter("@NonceStr", model.NonceStr), new MySqlParameter("@Timestamp", model.Timestamp), new MySqlParameter("@OrgID", model.OrgID), new MySqlParameter("@WeiXinOrderID", model.WeiXinOrderID), new MySqlParameter("@OrderFee", model.OrderFee), new MySqlParameter("@CashFee", model.CashFee), new MySqlParameter("@Package", model.Package), new MySqlParameter("@Status", model.Status), new MySqlParameter("@PayTime", model.PayTime), new MySqlParameter("@CallBackTime", model.CallBackTime) }; return(MySqlHelperUtil.ExecuteNonQuery(tranID, strSql.ToString(), parameters)); }
/// <summary> /// 更新一条数据 /// </summary> public int Update(ShiMiao.Model.TD_Order_WeiXinPay model, string tranID) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TD_Order_WeiXinPay set "); strSql.Append(" OrderID = @OrderID , "); strSql.Append(" NonceStr = @NonceStr , "); strSql.Append(" Timestamp = @Timestamp , "); strSql.Append(" OrgID = @OrgID , "); strSql.Append(" WeiXinOrderID = @WeiXinOrderID , "); strSql.Append(" OrderFee = @OrderFee , "); strSql.Append(" CashFee = @CashFee , "); strSql.Append(" Package = @Package , "); strSql.Append(" Status = @Status , "); strSql.Append(" PayTime = @PayTime , "); strSql.Append(" CallBackTime = @CallBackTime "); strSql.Append(" where OrderID=@OrderID and NonceStr=@NonceStr "); MySqlParameter[] parameters = { new MySqlParameter("@OrderID", model.OrderID), new MySqlParameter("@NonceStr", model.NonceStr), new MySqlParameter("@Timestamp", model.Timestamp), new MySqlParameter("@OrgID", model.OrgID), new MySqlParameter("@WeiXinOrderID", model.WeiXinOrderID), new MySqlParameter("@OrderFee", model.OrderFee), new MySqlParameter("@CashFee", model.CashFee), new MySqlParameter("@Package", model.Package), new MySqlParameter("@Status", model.Status), new MySqlParameter("@PayTime", model.PayTime), new MySqlParameter("@CallBackTime", model.CallBackTime) }; return(MySqlHelperUtil.ExecuteNonQuery(tranID, strSql.ToString(), parameters)); }
/// <summary> /// 获得数据列表 /// </summary> public IList <ShiMiao.Model.TD_Order_WeiXinPay> GetList(string where, string orderBy, IDictionary <string, object> dictParams) { StringBuilder strSql = new StringBuilder(); strSql.Append("select OrderID, NonceStr, Timestamp, OrgID, WeiXinOrderID, OrderFee, CashFee, Package, Status, PayTime, CallBackTime "); strSql.Append(" FROM TD_Order_WeiXinPay "); if (!string.IsNullOrEmpty(where)) { strSql.AppendFormat(" where {0}", where); } if (!string.IsNullOrEmpty(orderBy)) { strSql.AppendFormat(" order by {0}", orderBy); } List <MySqlParameter> parameters = new List <MySqlParameter>(); if (dictParams != null) { foreach (var pair in dictParams) { MySqlParameter parameter = new MySqlParameter("@" + pair.Key, pair.Value); parameters.Add(parameter); } } IList <ShiMiao.Model.TD_Order_WeiXinPay> list = new List <ShiMiao.Model.TD_Order_WeiXinPay>(); using (DbDataReader dr = MySqlHelperUtil.ExecuteReader(strSql.ToString(), parameters.ToArray())) { while (dr.Read()) { ShiMiao.Model.TD_Order_WeiXinPay model = new ShiMiao.Model.TD_Order_WeiXinPay(); if (dr[0] != DBNull.Value) { model.OrderID = dr.GetString(0); } if (dr[1] != DBNull.Value) { model.NonceStr = dr.GetString(1); } if (dr[2] != DBNull.Value) { model.Timestamp = dr.GetInt32(2); } if (dr[3] != DBNull.Value) { model.OrgID = dr.GetInt32(3); } if (dr[4] != DBNull.Value) { model.WeiXinOrderID = dr.GetString(4); } if (dr[5] != DBNull.Value) { model.OrderFee = dr.GetInt32(5); } if (dr[6] != DBNull.Value) { model.CashFee = dr.GetInt32(6); } if (dr[7] != DBNull.Value) { model.Package = dr.GetString(7); } if (dr[8] != DBNull.Value) { model.Status = dr.GetInt32(8); } if (dr[9] != DBNull.Value) { model.PayTime = dr.GetDateTime(9); } if (dr[10] != DBNull.Value) { model.CallBackTime = dr.GetDateTime(10); } list.Add(model); } parameters.Clear(); return(list); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ShiMiao.Model.TD_Order_WeiXinPay GetModel(string OrderID, string NonceStr) { StringBuilder strSql = new StringBuilder(); strSql.Append("select OrderID, NonceStr, Timestamp, OrgID, WeiXinOrderID, OrderFee, CashFee, Package, Status, PayTime, CallBackTime "); strSql.Append(" from TD_Order_WeiXinPay "); strSql.Append(" where OrderID=@OrderID and NonceStr=@NonceStr "); MySqlParameter[] parameters = { new MySqlParameter("@OrderID", OrderID), new MySqlParameter("@NonceStr", NonceStr) }; ShiMiao.Model.TD_Order_WeiXinPay model = null; using (DbDataReader dr = MySqlHelperUtil.ExecuteReader(strSql.ToString(), parameters)) { while (dr.Read()) { model = new ShiMiao.Model.TD_Order_WeiXinPay(); if (dr[0] != DBNull.Value) { model.OrderID = dr.GetString(0); } if (dr[1] != DBNull.Value) { model.NonceStr = dr.GetString(1); } if (dr[2] != DBNull.Value) { model.Timestamp = dr.GetInt32(2); } if (dr[3] != DBNull.Value) { model.OrgID = dr.GetInt32(3); } if (dr[4] != DBNull.Value) { model.WeiXinOrderID = dr.GetString(4); } if (dr[5] != DBNull.Value) { model.OrderFee = dr.GetInt32(5); } if (dr[6] != DBNull.Value) { model.CashFee = dr.GetInt32(6); } if (dr[7] != DBNull.Value) { model.Package = dr.GetString(7); } if (dr[8] != DBNull.Value) { model.Status = dr.GetInt32(8); } if (dr[9] != DBNull.Value) { model.PayTime = dr.GetDateTime(9); } if (dr[10] != DBNull.Value) { model.CallBackTime = dr.GetDateTime(10); } } return(model); } }