wx.SqlServer/shop_pinlun.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 shop_pinlun:DbBase
    {
        ///<summary>
        ///此处是插入表RongNet_shop_pinlun数据函数，参数值由实体获取,使用中请生成对应实体类
        ///代码生成引擎GenerateCode1.0.1，生成时间2019/6/13 14:25:57
        ///</summary>
        ///<param name=RongNet_shop_pinlun>RongNet_shop_pinlun实体类</param>
        ///<returns>返回操作是否成功</returns>
        public int InsertRongNet_shop_pinlun(RongNet_shop_pinlun rongnet_shop_pinlun)
        {
            string sql = "INSERT INTO RongNet_shop_pinlun(Xuanze_id,Xx,Cpid,Pinlun_neirong,User_name,User_id,Add_date,Gouwuche_id,Danhao,Yn_xianshi) VALUES(@Xuanze_id,@Xx,@Cpid,@Pinlun_neirong,@User_name,@User_id,@Add_date,@Gouwuche_id,@Danhao,@Yn_xianshi)";
            SqlParameter[] pars = 
			{
			
				new SqlParameter("@Xuanze_id",rongnet_shop_pinlun.Xuanze_id),
				new SqlParameter("@Xx",rongnet_shop_pinlun.Xx),
				new SqlParameter("@Cpid",rongnet_shop_pinlun.Cpid),
				new SqlParameter("@Pinlun_neirong",rongnet_shop_pinlun.Pinlun_neirong),
				new SqlParameter("@User_name",rongnet_shop_pinlun.User_name),
				new SqlParameter("@User_id",rongnet_shop_pinlun.User_id),
				new SqlParameter("@Add_date",rongnet_shop_pinlun.Add_date),
				new SqlParameter("@Gouwuche_id",rongnet_shop_pinlun.Gouwuche_id),
				new SqlParameter("@Danhao",rongnet_shop_pinlun.Danhao),
				new SqlParameter("@Yn_xianshi",rongnet_shop_pinlun.Yn_xianshi)
			};
            int tmp = DbHelper.ExecuteNonQuery(CommandType.Text, sql, true, pars);
            return tmp;
            //if (DbHelper.ExecuteNonQuery(CommandType.Text, sql, pars) > 0)
            //{
            //    return true;
            //}
            //return false;
        }

        /// <summary>
        ///此处是修改表RongNet_shop_pinlun数据函数，参数值由实体获取,使用中请生成对应实体类
        ///代码生成引擎GenerateCode1.0.1，生成时间2019/6/13 14:25:57
        ///</summary>
        ///<param name=RongNet_shop_pinlun>RongNet_shop_pinlun实体类</param>
        ///<returns>返回操作是否成功</returns>
        public bool UpdateRongNet_shop_pinlun(RongNet_shop_pinlun rongnet_shop_pinlun)
        {
            string sql = "UPDATE RongNet_shop_pinlun SET Xuanze_id=@Xuanze_id,Xx=@Xx,Cpid=@Cpid,Pinlun_neirong=@Pinlun_neirong,User_name=@User_name,User_id=@User_id,Add_date=@Add_date,Gouwuche_id=@Gouwuche_id,Danhao=@Danhao,Yn_xianshi=@Yn_xianshi WHERE Id=@Id";
            SqlParameter[] pars = 
			{
				new SqlParameter("@Id",rongnet_shop_pinlun.Id),
				new SqlParameter("@Xuanze_id",rongnet_shop_pinlun.Xuanze_id),
				new SqlParameter("@Xx",rongnet_shop_pinlun.Xx),