ASP.NET学习网|ASP.NET教程|ASP.NET MVC|ASP.NET 源码|VS2010教程|ASP.NET视频教程

每张表 主键 （字符串）

每张表  加一个字段 “XUHAO” （整数）        

程序设计

主键＝创建主键方法CreatID

       例：string TableName = "UserInfo"; //表名

string Prefix = DateTime.Now.ToShortDateString();//前缀

int StartID = 1;//开始序号

ID= CreateID(TableName, Prefix, StartID);

XUHAO= CreateSequence(TableName, StartID);

#region==============创建主键=============

        /// <summary>

        /// 创建ID

        /// </summary>

        /// <param name="TableName">表名</param>

        /// <param name="Prefix">ID前缀</param>

        /// <param name="StartID">定义开始序号</param>

        /// <returns></returns>

        public static string CreateID(string TableName, string Prefix, int StartID)

        {

            string strsql = "select max(XUHAO)+1 from " + TableName;

            object obj = DbHelperSQL.GetSingle(strsql);

            if (string.IsNullOrEmpty(Prefix))

            {

                if (obj == null)

                {

                    return StartID.ToString();

                }

                else

                {

                    return obj.ToString();

                }

            }

            else

            {

                if (obj == null)

                {

                    return Prefix + StartID;

                }

                else

                {

                    return Prefix + int.Parse(obj.ToString());

                }

            }

        }

        #endregion

#region============创建序号===========

        /// <summary>

        /// 创建序号

        /// </summary>

        /// <param name="TableName">表名</param>

        /// <returns></returns>

        public static int CreateSequence(string TableName, int StartID)

        {

            string strsql = "select max(XUHAO) +1 from " + TableName;

            object obj = DbHelperSQL.GetSingle(strsql);

            if (obj == null)

            {

                return StartID;

            }

            else

            {

                return int.Parse(obj.ToString());

            }

        }

        #endregion