自动为表生成序列号

最新推荐文章于 2022-10-21 16:57:14 发布

godpreserve

最新推荐文章于 2022-10-21 16:57:14 发布

阅读量802

点赞数

分类专栏：自已的东西文章标签： string null sql

本文链接：https://blog.youkuaiyun.com/godpreserve/article/details/2346479

版权

自已的东西专栏收录该内容

28 篇文章

订阅专栏

底层SQL语句

SELECT MAX(SUBSTRING(LineStopID, 9, 2)) AS LineStopMAXID
FROM L_StopInfoDetail
WHERE (CONVERT(NVARCHAR(10), SUBSTRING(LineStopID, 3, 6), 112)
= SUBSTRING(CONVERT(NVARCHAR(10), GETDATE(), 112), 3, 6))

逻辑层调用方法

public string returnLSID()
        {
            string LSID = "";
            string STRDT = "";
            DateTime DT = new DateTime();
            DT = System.DateTime.Now;
            STRDT += (DT.Year.ToString()).Substring(2, 2);
            STRDT += DT.Month.ToString().PadLeft(2, '0');
            STRDT += DT.Day.ToString().PadLeft(2, '0');
            LSID += "LS" + STRDT;

            string str = "";
            L_StopInfoDetailTableAdapter stop = new L_StopInfoDetailTableAdapter();
            string MAX = null;
            MAX = stop.returnMaxID1();
            if (MAX != null)
            {
                str = Convert.ToString((int.Parse(MAX) + 1)).PadLeft(2, '0');
            }
            else
            {
                str = "0".PadLeft(2, '0');
            }
            LSID += str;
            return LSID;
        }