wx.SqlServer/Order_history.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using wx.Data;
using wx.Entity;

namespace wx.SqlServer
{
    public class history:DbBase
    {
        ///<summary>
        ///此处是插入表Order_history数据函数，参数值由实体获取,使用中请生成对应实体类
        ///代码生成引擎GenerateCode1.0.1，生成时间2019/5/15 11:35:12
        ///</summary>
        ///<param name=Order_history>Order_history实体类</param>
        ///<returns>返回操作是否成功</returns>
        public bool InsertOrder_history(Order_history order_history)
        {
            string sql = "INSERT INTO Order_history(Room_id,Pay_price,Out_trade_no,Order_timestart,Openid,Creating_date) VALUES(@Room_id,@Pay_price,@Out_trade_no,@Order_timestart,@Openid,@Creating_date)";
            SqlParameter[] pars = 
			{
				new SqlParameter("@Room_id",order_history.Room_id),
				new SqlParameter("@Pay_price",order_history.Pay_price),
				new SqlParameter("@Out_trade_no",order_history.Out_trade_no),
				new SqlParameter("@Order_timestart",order_history.Order_timestart),
				new SqlParameter("@Openid",order_history.Openid),
				new SqlParameter("@Creating_date",order_history.Creating_date)
			};
            if (DbHelper.ExecuteNonQuery(CommandType.Text, sql, pars) > 0)
            {
                return true;
            }
            return false;
        }

        /// <summary>
        ///此处是修改表Order_history数据函数，参数值由实体获取,使用中请生成对应实体类
        ///代码生成引擎GenerateCode1.0.1，生成时间2019/5/15 11:35:12
        ///</summary>
        ///<param name=Order_history>Order_history实体类</param>
        ///<returns>返回操作是否成功</returns>
        public bool UpdateOrder_history(Order_history order_history)
        {
            string sql = "UPDATE Order_history SET Pay_price=@Pay_price,Out_trade_no=@Out_trade_no,Order_timestart=@Order_timestart,Openid=@Openid,Creating_date=@Creating_date WHERE Room_id=@Room_id";
            SqlParameter[] pars = 
			{
				new SqlParameter("@Room_id",order_history.Room_id),
				new SqlParameter("@Pay_price",order_history.Pay_price),
				new SqlParameter("@Out_trade_no",order_history.Out_trade_no),
				new SqlParameter("@Order_timestart",order_history.Order_timestart),
				new SqlParameter("@Openid",order_history.Openid),
				new SqlParameter("@Creating_date",order_history.Creating_date)
			};
            if (DbHelper.ExecuteNonQuery(CommandType.Text, sql, pars) > 0)
            {
                return true;