Ejemplo n.º 1
0
        /// <summary>
        /// 获取单号
        /// </summary>
        /// <returns></returns>
        public string getCode( )
        {
            return(GetCodeUtils.getOddNum("MIKLGN", "LGN001"));

            //DateTime dt = UserInfoMation . sysTime;
            //StringBuilder strSql = new StringBuilder ( );
            //strSql . AppendFormat ( "SELECT MAX(LGN001) LGN001 FROM MIKLGN WHERE LGN001 LIKE '{0}%'" ,dt . ToString ( "yyyyMMdd" ) );

            //DataTable table = SqlHelper . ExecuteDataTable ( strSql . ToString ( ) );
            //if ( table == null || table . Rows . Count < 1 )
            //    return dt . ToString ( "yyyyMMdd" ) + "001";
            //else if ( string . IsNullOrEmpty ( table . Rows [ 0 ] [ "LGN001" ] . ToString ( ) ) )
            //    return dt . ToString ( "yyyyMMdd" ) + "001";
            //else
            //    return ( Convert . ToInt64 ( table . Rows [ 0 ] [ "LGN001" ] . ToString ( ) ) + 1 ) . ToString ( );
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 获取单号
        /// </summary>
        /// <returns></returns>
        public string getOddNum( )
        {
            return(GetCodeUtils.getOddNum("MIKLEC", "LEC001"));
            //StringBuilder strSql = new StringBuilder ( );
            //strSql . Append ( "SELECT MAX(LEC001) LEC001 FROM MIKLEC" );

            //DataTable table = SqlHelper . ExecuteDataTable ( strSql . ToString ( ) );
            //if ( table == null || table . Rows . Count < 0 )
            //    return UserInfoMation . sysTime . ToString ( "yyyyMMdd" ) + "001";
            //else
            //{
            //    string code = table . Rows [ 0 ] [ "LEC001" ] . ToString ( );
            //    if ( string . IsNullOrEmpty ( code ) )
            //        return UserInfoMation . sysTime . ToString ( "yyyyMMdd" ) + "001";
            //    else
            //    {
            //        if ( code . Substring ( 0 ,8 ) . Equals ( UserInfoMation . sysTime . ToString ( "yyyyMMdd" ) ) )
            //            return ( Convert . ToInt64 ( code ) + 1 ) . ToString ( );
            //        else
            //            return UserInfoMation . sysTime . ToString ( "yyyyMMdd" ) + "001";
            //    }
            //}
        }