[.net] 신규생성키

// 신규생성키
public static string getMaxKey( string table_nm ) {
 
    string nowdate = DateTime.Now.ToString( "yyyyMMdd" );
    string result = "";
    int result_number = 0;
    MySqlCommand cmd = null;
 
    using( MySqlConnection conn = new MySqlConnection( Base.commDBString ) ) {
 
        conn.Open( ref cmd );
 
        string query = "select max(BUY_NUM) from " + table_nm + " where BUY_NUM like '%" + nowdate + "%'";
        cmd.Query( query );
        string tmp_number = cmd.ExecuteScalar().ConString();
 
        if( tmp_number.Equals( "" ) ) {
             result_number = 1;
         } else {
            tmp_number = tmp_number.Substring( 8, 7 );
            result_number = Convert.ToInt32( tmp_number ) + 1;
         }
 
        result = string.Format( "{0}{1:D7}", nowdate, result_number );
        conn.Close();
 
    }
 
    return result;
 
}