public static string GetStoreExportCode() { StoExchangeDT storeExchangeDT = new StoExchangeDT(); string mmyy = getMMyy(); DataTable invoiceTable = storeExchangeDT.GetByCond("Code like 'XH" + mmyy + "%'", " Code DESC"); string prefix = "XH" + mmyy; string suffix = "0001"; if (invoiceTable != null && invoiceTable.Rows.Count > 0) { suffix = getSuffix(invoiceTable.Rows[0]["Code"].ToString()); } return(prefix + suffix); }