自动为表生成序列号，表生成序列号

自动为表生成序列号，表生成序列号

底层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;
        }