public IList <Model.TD_Shop_OrderGoods> GetListByOrderID(string orderID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("SELECT OrderGoodsID,OrderID,GoodsID,Title,Amount,OrgID,OriPrice,RealPrice,OrderTime FROM TD_Shop_OrderGoods");
            strSql.Append(" where OrderID=@OrderID");
            MySqlParameter[] parameters =
            {
                new MySqlParameter("@OrderID", orderID)
            };
            IList <ShiMiao.Model.TD_Shop_OrderGoods> list = new List <ShiMiao.Model.TD_Shop_OrderGoods>();

            using (DbDataReader dr = MySqlHelperUtil.ExecuteReader(strSql.ToString(), parameters))
            {
                while (dr.Read())
                {
                    ShiMiao.Model.TD_Shop_OrderGoods model = new ShiMiao.Model.TD_Shop_OrderGoods();

                    if (dr[0] != DBNull.Value)
                    {
                        model.OrderGoodsID = dr.GetString(0);
                    }
                    if (dr[1] != DBNull.Value)
                    {
                        model.OrderID = dr.GetString(1);
                    }
                    if (dr[2] != DBNull.Value)
                    {
                        model.GoodsID = dr.GetString(2);
                    }
                    if (dr[3] != DBNull.Value)
                    {
                        model.Title = dr.GetString(3);
                    }
                    if (dr[4] != DBNull.Value)
                    {
                        model.Amount = dr.GetInt32(4);
                    }
                    if (dr[5] != DBNull.Value)
                    {
                        model.OrgID = dr.GetInt32(5);
                    }
                    if (dr[6] != DBNull.Value)
                    {
                        model.OriPrice = dr.GetDecimal(6);
                    }
                    if (dr[7] != DBNull.Value)
                    {
                        model.RealPrice = dr.GetDecimal(7);
                    }
                    if (dr[8] != DBNull.Value)
                    {
                        model.OrderTime = dr.GetDateTime(8);
                    }
                    list.Add(model);
                }
                return(list);
            }
        }
        public int Add(ShiMiao.Model.TD_Shop_OrderGoods model, string tranID)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into TD_Shop_OrderGoods(");
            strSql.Append("OrderGoodsID,OrderID,GoodsID,Title,Amount,OrgID,OriPrice,RealPrice,OrderTime");
            strSql.Append(") values (");
            strSql.Append("@OrderGoodsID,@OrderID,@GoodsID,@Title,@Amount,@OrgID,@OriPrice,@RealPrice,@OrderTime");
            strSql.Append(") ");

            MySqlParameter[] parameters =
            {
                new MySqlParameter("@OrderGoodsID", model.OrderGoodsID),
                new MySqlParameter("@OrderID",      model.OrderID),
                new MySqlParameter("@GoodsID",      model.GoodsID),
                new MySqlParameter("@Title",        model.Title),
                new MySqlParameter("@Amount",       model.Amount),
                new MySqlParameter("@OrgID",        model.OrgID),
                new MySqlParameter("@OriPrice",     model.OriPrice),
                new MySqlParameter("@RealPrice",    model.RealPrice),
                new MySqlParameter("@OrderTime",    model.OrderTime)
            };
            return(MySqlHelperUtil.ExecuteNonQuery(tranID, strSql.ToString(), parameters));
        }