wx.SqlServer/yonghu_dizhi.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_dizhi:DbBase
    {
        ///<summary>
        ///此处是插入表RongNet_yonghu_dizhi数据函数，参数值由实体获取,使用中请生成对应实体类
        ///代码生成引擎GenerateCode1.0.1，生成时间2019/6/13 16:47:38
        ///</summary>
        ///<param name=RongNet_yonghu_dizhi>RongNet_yonghu_dizhi实体类</param>
        ///<returns>返回操作是否成功</returns>
        public int InsertRongNet_yonghu_dizhi(RongNet_yonghu_dizhi rongnet_yonghu_dizhi)
        {
            string sql = "INSERT INTO RongNet_yonghu_dizhi(Diqu1,Diqu2,Diqu3,Dizhi,Youbian,Xingming,Youjian,Shouji,Dianhua,User_name,User_id,Yn_moren,Lx,Wx_openid) VALUES(@Diqu1,@Diqu2,@Diqu3,@Dizhi,@Youbian,@Xingming,@Youjian,@Shouji,@Dianhua,@User_name,@User_id,@Yn_moren,@Lx,@Wx_openid)";
            SqlParameter[] pars = 
			{
				
				new SqlParameter("@Diqu1",rongnet_yonghu_dizhi.Diqu1),
				new SqlParameter("@Diqu2",rongnet_yonghu_dizhi.Diqu2),
				new SqlParameter("@Diqu3",rongnet_yonghu_dizhi.Diqu3),
				new SqlParameter("@Dizhi",rongnet_yonghu_dizhi.Dizhi),
				new SqlParameter("@Youbian",rongnet_yonghu_dizhi.Youbian),
				new SqlParameter("@Xingming",rongnet_yonghu_dizhi.Xingming),
				new SqlParameter("@Youjian",rongnet_yonghu_dizhi.Youjian),
				new SqlParameter("@Shouji",rongnet_yonghu_dizhi.Shouji),
				new SqlParameter("@Dianhua",rongnet_yonghu_dizhi.Dianhua),
				new SqlParameter("@User_name",rongnet_yonghu_dizhi.User_name),
				new SqlParameter("@User_id",rongnet_yonghu_dizhi.User_id),
				new SqlParameter("@Yn_moren",rongnet_yonghu_dizhi.Yn_moren),
				new SqlParameter("@Lx",rongnet_yonghu_dizhi.Lx),
				new SqlParameter("@Wx_openid",rongnet_yonghu_dizhi.Wx_openid)
			};
            int tmp = DbHelper.ExecuteNonQuery(CommandType.Text, sql,true, pars);
            return tmp;
        }

        /// <summary>
        ///此处是修改表RongNet_yonghu_dizhi数据函数，参数值由实体获取,使用中请生成对应实体类
        ///代码生成引擎GenerateCode1.0.1，生成时间2019/6/13 16:47:38
        ///</summary>
        ///<param name=RongNet_yonghu_dizhi>RongNet_yonghu_dizhi实体类</param>
        ///<returns>返回操作是否成功</returns>
        public bool UpdateRongNet_yonghu_dizhi(RongNet_yonghu_dizhi rongnet_yonghu_dizhi)
        {
            string sql = "UPDATE RongNet_yonghu_dizhi SET Diqu1=@Diqu1,Diqu2=@Diqu2,Diqu3=@Diqu3,Dizhi=@Dizhi,Youbian=@Youbian,Xingming=@Xingming,Youjian=@Youjian,Shouji=@Shouji,Dianhua=@Dianhua,User_name=@User_name,Yn_moren=@Yn_moren,Lx=@Lx,Wx_openid=@Wx_openid WHERE User_id=@User_id AND Id=@Id";
            SqlParameter[] pars = 
			{
				new SqlParameter("@Id",rongnet_yonghu_dizhi.Id),
				new SqlParameter("@Diqu1",rongnet_yonghu_dizhi.Diqu1),
				new SqlParameter("@Diqu2",rongnet_yonghu_dizhi.Diqu2),