/// <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 ( ); }
/// <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"; // } //} }