wx.SqlServer/Nav.cs

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

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

using MFPA.Entity;
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;

namespace wx.SqlServer
{
    public class Nav:DbBase
    {
        ///<summary>
        ///此处是插入表MFPA_Nav数据函数，参数值由实体获取,使用中请生成对应实体类
        ///代码生成引擎GenerateCode1.0.1，生成时间2018/3/29 14:46:50
        ///</summary>
        ///<param name=MFPA_Nav>MFPA_Nav实体类</param>
        ///<returns>返回操作是否成功</returns>
        public bool InsertMFPA_Nav(MFPA_Nav mfpa_nav)
        {
            string sql = "INSERT INTO MFPA_Nav(ID,Name,State,IconCls,Url,Nid) VALUES(@ID,@Name,@State,@IconCls,@Url,@Nid)";
            SqlParameter[] pars = 
			{
				new SqlParameter("@ID",mfpa_nav.ID),
				new SqlParameter("@Name",mfpa_nav.Name),
				new SqlParameter("@State",mfpa_nav.State),
				new SqlParameter("@IconCls",mfpa_nav.IconCls),
				new SqlParameter("@Url",mfpa_nav.Url),
				new SqlParameter("@Nid",mfpa_nav.Nid)
			};
            if (DbHelper.ExecuteNonQuery(CommandType.Text, sql, pars) > 0)
            {
                return true;
            }
            return false;
        }

        /// <summary>
        ///此处是修改表MFPA_Nav数据函数，参数值由实体获取,使用中请生成对应实体类
        ///代码生成引擎GenerateCode1.0.1，生成时间2018/3/29 14:46:50
        ///</summary>
        ///<param name=MFPA_Nav>MFPA_Nav实体类</param>
        ///<returns>返回操作是否成功</returns>
        public bool UpdateMFPA_Nav(MFPA_Nav mfpa_nav)
        {
            string sql = "UPDATE MFPA_Nav SET Name=@Name,State=@State,IconCls=@IconCls,Url=@Url,Nid=@Nid WHERE ID=@ID";
            SqlParameter[] pars = 
			{
				new SqlParameter("@ID",mfpa_nav.ID),
				new SqlParameter("@Name",mfpa_nav.Name),
				new SqlParameter("@State",mfpa_nav.State),
				new SqlParameter("@IconCls",mfpa_nav.IconCls),
				new SqlParameter("@Url",mfpa_nav.Url),
				new SqlParameter("@Nid",mfpa_nav.Nid)
			};
            if (DbHelper.ExecuteNonQuery(CommandType.Text, sql, pars) > 0)
            {