wx.SqlServer/yonghu.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 yonghu:DbBase
    {
        ///<summary>
        ///此处是插入表RongNet_yonghu数据函数，参数值由实体获取,使用中请生成对应实体类
        ///代码生成引擎GenerateCode1.0.1，生成时间2019/6/13 15:44:04
        ///</summary>
        ///<param name=RongNet_yonghu>RongNet_yonghu实体类</param>
        ///<returns>返回操作是否成功</returns>
        public bool InsertRongNet_yonghu(RongNet_yonghu rongnet_yonghu)
        {
            string sql = "INSERT INTO RongNet_yonghu(Id,Shouji,Mima,QqOpenid,Yonghuming,Kahao,Xuhao,Yiyuan_id,Daili_id,Lx_id,Xingming,Nicheng,Email,Xingbie,Shouru,Shengri,Xueli,Hejiu_pinlv,Nali_liaojie,Add_date1,Add_date2,Wx_openid,Wx_nicheng,Wx_xingbie,Wx_touxiang,Wx_dizhi1,Wx_dizhi2,Wx_dizhi3,Wx_date,Wx_shijian,Fx_upid) VALUES(@Id,@Shouji,@Mima,@QqOpenid,@Yonghuming,@Kahao,@Xuhao,@Yiyuan_id,@Daili_id,@Lx_id,@Xingming,@Nicheng,@Email,@Xingbie,@Shouru,@Shengri,@Xueli,@Hejiu_pinlv,@Nali_liaojie,@Add_date1,@Add_date2,@Wx_openid,@Wx_nicheng,@Wx_xingbie,@Wx_touxiang,@Wx_dizhi1,@Wx_dizhi2,@Wx_dizhi3,@Wx_date,@Wx_shijian,@Fx_upid)";
            SqlParameter[] pars = 
			{
				new SqlParameter("@Id",rongnet_yonghu.Id),
				new SqlParameter("@Shouji",rongnet_yonghu.Shouji),
				new SqlParameter("@Mima",rongnet_yonghu.Mima),
				new SqlParameter("@QqOpenid",rongnet_yonghu.QqOpenid),
				new SqlParameter("@Yonghuming",rongnet_yonghu.Yonghuming),
				new SqlParameter("@Kahao",rongnet_yonghu.Kahao),
				new SqlParameter("@Xuhao",rongnet_yonghu.Xuhao),
				new SqlParameter("@Yiyuan_id",rongnet_yonghu.Yiyuan_id),
				new SqlParameter("@Daili_id",rongnet_yonghu.Daili_id),
				new SqlParameter("@Lx_id",rongnet_yonghu.Lx_id),
				new SqlParameter("@Xingming",rongnet_yonghu.Xingming),
				new SqlParameter("@Nicheng",rongnet_yonghu.Nicheng),
				new SqlParameter("@Email",rongnet_yonghu.Email),
				new SqlParameter("@Xingbie",rongnet_yonghu.Xingbie),
				new SqlParameter("@Shouru",rongnet_yonghu.Shouru),
				new SqlParameter("@Shengri",rongnet_yonghu.Shengri),
				new SqlParameter("@Xueli",rongnet_yonghu.Xueli),
				new SqlParameter("@Hejiu_pinlv",rongnet_yonghu.Hejiu_pinlv),
				new SqlParameter("@Nali_liaojie",rongnet_yonghu.Nali_liaojie),
				new SqlParameter("@Add_date1",rongnet_yonghu.Add_date1),
				new SqlParameter("@Add_date2",rongnet_yonghu.Add_date2),
				new SqlParameter("@Wx_openid",rongnet_yonghu.Wx_openid),
				new SqlParameter("@Wx_nicheng",rongnet_yonghu.Wx_nicheng),
				new SqlParameter("@Wx_xingbie",rongnet_yonghu.Wx_xingbie),
				new SqlParameter("@Wx_touxiang",rongnet_yonghu.Wx_touxiang),
				new SqlParameter("@Wx_dizhi1",rongnet_yonghu.Wx_dizhi1),
				new SqlParameter("@Wx_dizhi2",rongnet_yonghu.Wx_dizhi2),
				new SqlParameter("@Wx_dizhi3",rongnet_yonghu.Wx_dizhi3),
				new SqlParameter("@Wx_date",rongnet_yonghu.Wx_date),
				new SqlParameter("@Wx_shijian",rongnet_yonghu.Wx_shijian),
				new SqlParameter("@Fx_upid",rongnet_yonghu.Fx_upid)
			};
            if (DbHelper.ExecuteNonQuery(CommandType.Text, sql, pars) > 0)
            {
                return true;